Database Mirroring in 2005 Standard

Hi all,
I've been checking the editions comparison at the MS website for SQL Server
2005.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Under High Availability, I'm confused by the Database Mirroring entry. It
has a '1' by the actual Database Mirroring that, in the key, states "For
evaluation purposes only".
Does this mean that mirroring is only available for evaluation full stop or
only in certain editions? Ideally, I'd like it to be available in Standard.
Any ideas would be greatly appreciated.
Cheers,
IanDatabase mirroring is currently for evaluation only in standard, enterprise
and developer editions. The plan is to fully support database mirroring in
the first half of 2006.
> Ideally, I'd like it to be available in Standard.
It will be available in standard edition with the restrictions described in
footnote '2'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
> Hi all,
> I've been checking the editions comparison at the MS website for SQL
> Server
> 2005.
> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> Under High Availability, I'm confused by the Database Mirroring entry. It
> has a '1' by the actual Database Mirroring that, in the key, states "For
> evaluation purposes only".
> Does this mean that mirroring is only available for evaluation full stop
> or
> only in certain editions? Ideally, I'd like it to be available in
> Standard.
> Any ideas would be greatly appreciated.
> Cheers,
> Ian|||"Dan Guzman" wrote:
> Database mirroring is currently for evaluation only in standard, enterprise
> and developer editions. The plan is to fully support database mirroring in
> the first half of 2006.
> > Ideally, I'd like it to be available in Standard.
> It will be available in standard edition with the restrictions described in
> footnote '2'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
> news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
> > Hi all,
> >
> > I've been checking the editions comparison at the MS website for SQL
> > Server
> > 2005.
> >
> > http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
> >
> > Under High Availability, I'm confused by the Database Mirroring entry. It
> > has a '1' by the actual Database Mirroring that, in the key, states "For
> > evaluation purposes only".
> >
> > Does this mean that mirroring is only available for evaluation full stop
> > or
> > only in certain editions? Ideally, I'd like it to be available in
> > Standard.
> >
> > Any ideas would be greatly appreciated.
> >
> > Cheers,
> >
> > Ian
Thanks Dan, that answers my question perfectly :-)
Cheers,
Ian

Database Mirroring in 2005 Standard

Hi all,
I've been checking the editions comparison at the MS website for SQL Server
2005.
http://www.microsoft.com/sql/prodin...e-features.mspx
Under High Availability, I'm confused by the Database Mirroring entry. It
has a '1' by the actual Database Mirroring that, in the key, states "For
evaluation purposes only".
Does this mean that mirroring is only available for evaluation full stop or
only in certain editions? Ideally, I'd like it to be available in Standard.
Any ideas would be greatly appreciated.
Cheers,
IanDatabase mirroring is currently for evaluation only in standard, enterprise
and developer editions. The plan is to fully support database mirroring in
the first half of 2006.

> Ideally, I'd like it to be available in Standard.
It will be available in standard edition with the restrictions described in
footnote '2'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
> Hi all,
> I've been checking the editions comparison at the MS website for SQL
> Server
> 2005.
> http://www.microsoft.com/sql/prodin...e-features.mspx
> Under High Availability, I'm confused by the Database Mirroring entry. It
> has a '1' by the actual Database Mirroring that, in the key, states "For
> evaluation purposes only".
> Does this mean that mirroring is only available for evaluation full stop
> or
> only in certain editions? Ideally, I'd like it to be available in
> Standard.
> Any ideas would be greatly appreciated.
> Cheers,
> Ian|||"Dan Guzman" wrote:
[vbcol=seagreen]
> Database mirroring is currently for evaluation only in standard, enterpris
e
> and developer editions. The plan is to fully support database mirroring i
n
> the first half of 2006.
>
> It will be available in standard edition with the restrictions described i
n
> footnote '2'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
> news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
Thanks Dan, that answers my question perfectly :-)
Cheers,
Iansql

Database Mirroring in 2005 Standard

Hi all,
I've been checking the editions comparison at the MS website for SQL Server
2005.
http://www.microsoft.com/sql/prodinf...-features.mspx
Under High Availability, I'm confused by the Database Mirroring entry. It
has a '1' by the actual Database Mirroring that, in the key, states "For
evaluation purposes only".
Does this mean that mirroring is only available for evaluation full stop or
only in certain editions? Ideally, I'd like it to be available in Standard.
Any ideas would be greatly appreciated.
Cheers,
Ian
Database mirroring is currently for evaluation only in standard, enterprise
and developer editions. The plan is to fully support database mirroring in
the first half of 2006.

> Ideally, I'd like it to be available in Standard.
It will be available in standard edition with the restrictions described in
footnote '2'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
> Hi all,
> I've been checking the editions comparison at the MS website for SQL
> Server
> 2005.
> http://www.microsoft.com/sql/prodinf...-features.mspx
> Under High Availability, I'm confused by the Database Mirroring entry. It
> has a '1' by the actual Database Mirroring that, in the key, states "For
> evaluation purposes only".
> Does this mean that mirroring is only available for evaluation full stop
> or
> only in certain editions? Ideally, I'd like it to be available in
> Standard.
> Any ideas would be greatly appreciated.
> Cheers,
> Ian
|||"Dan Guzman" wrote:
[vbcol=seagreen]
> Database mirroring is currently for evaluation only in standard, enterprise
> and developer editions. The plan is to fully support database mirroring in
> the first half of 2006.
>
> It will be available in standard edition with the restrictions described in
> footnote '2'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
> news:14B492FF-E625-4DEE-9421-4A07F4DAAD10@.microsoft.com...
Thanks Dan, that answers my question perfectly :-)
Cheers,
Ian

Database Mail

We have a user set up for our .net framework (webuser) with access to a database we created for our website. "webuser" needs to be able to send out emails using Databse Mail (SQL Server 2005) via a stored proc by excuting msdb.dbo.sp_send_dbmail. This stopred proc works fine when I am logged in as administrator but won't work for "webuser" and I can't seem to grant DatabaseMailUserRole to our that user either. What do I need to do?

I have bee trying to find a "how to" on setting this up but have been unsuccessful.

What do you mean by you can't grant? What errors or problems did you have? Did you add the user to msdb and then add the user to the role?

-Sue

|||Hi,
1.) Goto "Databasemail" under Management,
2.) Click on "Manage Profile Security"
3.) Goto "Private profiles" and select the 'webuser' from the dropdown menu and give access to the profile which webuser should use

or else

you can go to the 'public profile', There you can select a profile which can be used as public users and make this as default profile. And call this profile in webapplication to send mail.

Database Mail

We have a user set up for our .net framework (webuser) with access to a database we created for our website. "webuser" needs to be able to send out emails using Databse Mail (SQL Server 2005) via a stored proc by excuting msdb.dbo.sp_send_dbmail. This stopred proc works fine when I am logged in as administrator but won't work for "webuser" and I can't seem to grant DatabaseMailUserRole to our that user either. What do I need to do?

I have bee trying to find a "how to" on setting this up but have been unsuccessful.

What do you mean by you can't grant? What errors or problems did you have? Did you add the user to msdb and then add the user to the role?

-Sue

|||Hi,
1.) Goto "Databasemail" under Management,
2.) Click on "Manage Profile Security"
3.) Goto "Private profiles" and select the 'webuser' from the dropdown menu and give access to the profile which webuser should use

or else

you can go to the 'public profile', There you can select a profile which can be used as public users and make this as default profile. And call this profile in webapplication to send mail.

Database Mail

We have a user set up for our .net framework (webuser) with access to a database we created for our website. "webuser" needs to be able to send out emails using Databse Mail (SQL Server 2005) via a stored proc by excuting msdb.dbo.sp_send_dbmail. This stopred proc works fine when I am logged in as administrator but won't work for "webuser" and I can't seem to grant DatabaseMailUserRole to our that user either. What do I need to do?

I have bee trying to find a "how to" on setting this up but have been unsuccessful.

What do you mean by you can't grant? What errors or problems did you have? Did you add the user to msdb and then add the user to the role?

-Sue

|||Hi,
1.) Goto "Databasemail" under Management,
2.) Click on "Manage Profile Security"
3.) Goto "Private profiles" and select the 'webuser' from the dropdown menu and give access to the profile which webuser should use

or else

you can go to the 'public profile', There you can select a profile which can be used as public users and make this as default profile. And call this profile in webapplication to send mail.

Database Limit

I have heard the answer before, but I do not remember and I cannot find it
on Microsoft's website. Is the 2 GB limit per database or per server? Can
I have multiple databases reach 2 GB on one MSDE server, or is the maximum
for all databases on the server 2 GB?
Thank you,
Marc
Marc,
The limit is per database.
Regards
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Marc Meltzer wrote:
> I have heard the answer before, but I do not remember and I cannot find it
> on Microsoft's website. Is the 2 GB limit per database or per server? Can
> I have multiple databases reach 2 GB on one MSDE server, or is the maximum
> for all databases on the server 2 GB?
> Thank you,
> Marc
>
|||hi Marc,
Marc Meltzer wrote:
> I have heard the answer before, but I do not remember and I cannot
> find it on Microsoft's website. Is the 2 GB limit per database or
> per server? Can I have multiple databases reach 2 GB on one MSDE
> server, or is the maximum for all databases on the server 2 GB?
the limit is per database, and regarding the datafiles only...
you can have multiple databases reaching 2gb per data files on the same
instance..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||It's 2GB per database. The limit applies to the size of the data files, not
log files.
This is covered in one of the footnotes from
http://msdn.microsoft.com/library/?u...sp?frame=true:
3 The data portion of a database cannot exceed 2 GB in size when using the
SQL Server 2000 Desktop Engine (MSDE 2000) or the Microsoft Data Engine
(MSDE) 1.0. The total size of the database, including log files, can exceed
2 GB provided the sum of the sizes of the data files remains 2 GB or lower.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.