Backing up SQL Server express db that runs in user instance?

Hi,
I want to do a backup of my database that runs in User Instance. The
problem is that due to connection pooling the file is constantly locked
so I can't copy the file or perform a backup in Management Studio.
Does anyone have any tips on how to do it?
I assume I'm not the only one that has these problems.
Thanks in advance
/Mats
How about just executing the TSQL BACKUP DATABASE command?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:uDBGGEYJGHA.3912@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I want to do a backup of my database that runs in User Instance. The problem is that due to
> connection pooling the file is constantly locked so I can't copy the file or perform a backup in
> Management Studio.
> Does anyone have any tips on how to do it?
> I assume I'm not the only one that has these problems.
> Thanks in advance
> /Mats
|||Tibor Karaszi wrote:
> How about just executing the TSQL BACKUP DATABASE command?
>
Thanks for the reply.
I'm still not getting it to work tho, actually I'm not sure how to
select the database to do the backup on.
My database instance is a .mdf file which I want to do a backup of.
How do I write the backup statement to perform the backup?
I've tried this in sqlcmd.
1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF' TO
DISK = 'C:\backup.dat'
2> GO
But it complains about the reference to the database.
How do I tell it that I want to do a backup of that file?
|||Mats Lycken wrote:
> Tibor Karaszi wrote:
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to
> select the database to do the backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF' TO
> DISK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?
The correct syntax is
BACKUP DATABASE CMSDB TO DISK = 'C:\backup.dat'
(Assuming your database is named CMSDB)
You can look up the BACKUP DATABASE syntax in Books On Line. Here you
can also find all the various options you can use.
Regards
STeen
|||Use instances are special. You can get the name of the pipe from the parent instance and then use
that name to connect from your app where you want to execute the backup command. This is explained
in
http://msdn.microsoft.com/sql/expres...xpuserinst.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:%23FBYdFaJGHA.524@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to select the database to do the
> backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF' TO DISK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?
|||The database name is not a string. Try doing a "select name from
sys.databases" in sseutil to see what the database name is. Chances are the
backup command would be:
1> BACKUP DATABASE [C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MD F] TO
DISK = 'C:\backup.dat'
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:%23FBYdFaJGHA.524@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to select
> the database to do the backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF' TO
> DISK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?

Backing up SQL Server express db that runs in user instance?

Hi,
I want to do a backup of my database that runs in User Instance. The
problem is that due to connection pooling the file is constantly locked
so I can't copy the file or perform a backup in Management Studio.
Does anyone have any tips on how to do it?
I assume I'm not the only one that has these problems.
Thanks in advance
/MatsHow about just executing the TSQL BACKUP DATABASE command?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:uDBGGEYJGHA.3912@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I want to do a backup of my database that runs in User Instance. The problem is that due to
> connection pooling the file is constantly locked so I can't copy the file or perform a backup in
> Management Studio.
> Does anyone have any tips on how to do it?
> I assume I'm not the only one that has these problems.
> Thanks in advance
> /Mats|||Tibor Karaszi wrote:
> How about just executing the TSQL BACKUP DATABASE command?
>
Thanks for the reply.
I'm still not getting it to work tho, actually I'm not sure how to
select the database to do the backup on.
My database instance is a .mdf file which I want to do a backup of.
How do I write the backup statement to perform the backup?
I've tried this in sqlcmd.
1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF' TO
DISK = 'C:\backup.dat'
2> GO
But it complains about the reference to the database.
How do I tell it that I want to do a backup of that file?|||Mats Lycken wrote:
> Tibor Karaszi wrote:
>> How about just executing the TSQL BACKUP DATABASE command?
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to
> select the database to do the backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF' TO
> DISK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?
The correct syntax is
BACKUP DATABASE CMSDB TO DISK = 'C:\backup.dat'
(Assuming your database is named CMSDB)
You can look up the BACKUP DATABASE syntax in Books On Line. Here you
can also find all the various options you can use.
Regards
STeen|||Use instances are special. You can get the name of the pipe from the parent instance and then use
that name to connect from your app where you want to execute the backup command. This is explained
in
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:%23FBYdFaJGHA.524@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
>> How about just executing the TSQL BACKUP DATABASE command?
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to select the database to do the
> backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF' TO DISK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?|||The database name is not a string. Try doing a "select name from
sys.databases" in sseutil to see what the database name is. Chances are the
backup command would be:
1> BACKUP DATABASE [C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF] TO
DISK = 'C:\backup.dat'
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:%23FBYdFaJGHA.524@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
>> How about just executing the TSQL BACKUP DATABASE command?
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to select
> the database to do the backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\CMSDB.MDF' TO
> DISK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?

Backing up SQL Server express db that runs in user instance?

Hi,
I want to do a backup of my database that runs in User Instance. The
problem is that due to connection pooling the file is constantly locked
so I can't copy the file or perform a backup in Management Studio.
Does anyone have any tips on how to do it?
I assume I'm not the only one that has these problems.
Thanks in advance
/MatsHow about just executing the TSQL BACKUP DATABASE command?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:uDBGGEYJGHA.3912@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I want to do a backup of my database that runs in User Instance. The probl
em is that due to
> connection pooling the file is constantly locked so I can't copy the file
or perform a backup in
> Management Studio.
> Does anyone have any tips on how to do it?
> I assume I'm not the only one that has these problems.
> Thanks in advance
> /Mats|||Tibor Karaszi wrote:
> How about just executing the TSQL BACKUP DATABASE command?
>
Thanks for the reply.
I'm still not getting it to work tho, actually I'm not sure how to
select the database to do the backup on.
My database instance is a .mdf file which I want to do a backup of.
How do I write the backup statement to perform the backup?
I've tried this in sqlcmd.
1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\C
MSDB.MDF' TO
DISK = 'C:\backup.dat'
2> GO
But it complains about the reference to the database.
How do I tell it that I want to do a backup of that file?|||Mats Lycken wrote:
> Tibor Karaszi wrote:
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to
> select the database to do the backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\C
MSDB.MDF' TO
> DISK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?
The correct syntax is
BACKUP DATABASE CMSDB TO DISK = 'C:\backup.dat'
(Assuming your database is named CMSDB)
You can look up the BACKUP DATABASE syntax in Books On Line. Here you
can also find all the various options you can use.
Regards
STeen|||Use instances are special. You can get the name of the pipe from the parent
instance and then use
that name to connect from your app where you want to execute the backup comm
and. This is explained
in
sqlexpuserinst.asp" target="_blank">http://msdn.microsoft.com/sql/expre...expuserinst.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:%23FBYdFaJGHA.524@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to select
the database to do the
> backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\C
MSDB.MDF' TO DI
SK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?|||The database name is not a string. Try doing a "select name from
sys.databases" in sseutil to see what the database name is. Chances are the
backup command would be:
1> BACKUP DATABASE & #91;C:\Inetpub\wwwroot\SlottsCMS\App_Dat
a\CMSDB.MDF] TO
DISK = 'C:\backup.dat'
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Mats Lycken" <MatsL@.newsgroups.nospam> wrote in message
news:%23FBYdFaJGHA.524@.TK2MSFTNGP09.phx.gbl...
> Tibor Karaszi wrote:
> Thanks for the reply.
> I'm still not getting it to work tho, actually I'm not sure how to select
> the database to do the backup on.
> My database instance is a .mdf file which I want to do a backup of.
> How do I write the backup statement to perform the backup?
> I've tried this in sqlcmd.
> 1> BACKUP DATABASE 'C:\Inetpub\wwwroot\SlottsCMS\App_Data\C
MSDB.MDF' TO
> DISK = 'C:\backup.dat'
> 2> GO
> But it complains about the reference to the database.
> How do I tell it that I want to do a backup of that file?sql

Backing Up Muliple Databases in Same Instance

I've 6 databases in the same instance which I wish to se a backup routine
for. How can I select all the databases at a go and create a backup procedure
just once in enerprise manager. I tried highlighting all he databases, but
each time I click backup up. he sysem comes up with one database at a time
for me o create backup for.
Regards
Is this something you want to schedule or do only once?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
> I've 6 databases in the same instance which I wish to se a backup routine
> for. How can I select all the databases at a go and create a backup procedure
> just once in enerprise manager. I tried highlighting all he databases, but
> each time I click backup up. he sysem comes up with one database at a time
> for me o create backup for.
> --
> Regards
|||I want to schedule it.
Regards
"Tibor Karaszi" wrote:

> Is this something you want to schedule or do only once?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
> news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
>
|||Create a Maintenance Plans. The regular backup dialog doesn't support selecting multiple databases,
but a Maint Plans does.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
news:7EFD5154-BBB8-40D0-8791-51EF2B744CC3@.microsoft.com...[vbcol=seagreen]
>I want to schedule it.
> --
> Regards
>
> "Tibor Karaszi" wrote:

Backing Up Muliple Databases in Same Instance

I've 6 databases in the same instance which I wish to se a backup routine
for. How can I select all the databases at a go and create a backup procedure
just once in enerprise manager. I tried highlighting all he databases, but
each time I click backup up. he sysem comes up with one database at a time
for me o create backup for.
--
RegardsIs this something you want to schedule or do only once?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
> I've 6 databases in the same instance which I wish to se a backup routine
> for. How can I select all the databases at a go and create a backup procedure
> just once in enerprise manager. I tried highlighting all he databases, but
> each time I click backup up. he sysem comes up with one database at a time
> for me o create backup for.
> --
> Regards|||I want to schedule it.
--
Regards
"Tibor Karaszi" wrote:
> Is this something you want to schedule or do only once?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
> news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
> > I've 6 databases in the same instance which I wish to se a backup routine
> > for. How can I select all the databases at a go and create a backup procedure
> > just once in enerprise manager. I tried highlighting all he databases, but
> > each time I click backup up. he sysem comes up with one database at a time
> > for me o create backup for.
> > --
> > Regards
>|||Create a Maintenance Plans. The regular backup dialog doesn't support selecting multiple databases,
but a Maint Plans does.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
news:7EFD5154-BBB8-40D0-8791-51EF2B744CC3@.microsoft.com...
>I want to schedule it.
> --
> Regards
>
> "Tibor Karaszi" wrote:
>> Is this something you want to schedule or do only once?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
>> news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
>> > I've 6 databases in the same instance which I wish to se a backup routine
>> > for. How can I select all the databases at a go and create a backup procedure
>> > just once in enerprise manager. I tried highlighting all he databases, but
>> > each time I click backup up. he sysem comes up with one database at a time
>> > for me o create backup for.
>> > --
>> > Regards
>>

Backing Up Muliple Databases in Same Instance

I've 6 databases in the same instance which I wish to se a backup routine
for. How can I select all the databases at a go and create a backup procedur
e
just once in enerprise manager. I tried highlighting all he databases, but
each time I click backup up. he sysem comes up with one database at a time
for me o create backup for.
--
RegardsIs this something you want to schedule or do only once?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
> I've 6 databases in the same instance which I wish to se a backup routine
> for. How can I select all the databases at a go and create a backup proced
ure
> just once in enerprise manager. I tried highlighting all he databases, but
> each time I click backup up. he sysem comes up with one database at a time
> for me o create backup for.
> --
> Regards|||I want to schedule it.
--
Regards
"Tibor Karaszi" wrote:

> Is this something you want to schedule or do only once?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
> news:A9E328AC-0817-4DF6-8EA6-AD550DFBDCDC@.microsoft.com...
>|||Create a Maintenance Plans. The regular backup dialog doesn't support select
ing multiple databases,
but a Maint Plans does.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ogemdi" <Ogemdi@.discussions.microsoft.com> wrote in message
news:7EFD5154-BBB8-40D0-8791-51EF2B744CC3@.microsoft.com...[vbcol=seagreen]
>I want to schedule it.
> --
> Regards
>
> "Tibor Karaszi" wrote:
>

AWE questions

We are looking to take advantage of AWE in a single instance of SQL Server
2000 Enterprise running on a Windows 2000 Advanced Server. The cluster will
have 8GB of physical memory. I would like Sql Server to use 7GB and leave
1 GB for the O/S. If I understand the documentation correctly we need to do
the following:
1. Add "/pae /3gb /awe" to the boot.ini (I believe "/pae" is
necessary and the others are optional)
2. Make sure the sql server startup account is either an administrator
or has the Windows 2000 lock pages in memory privilege.
3. In query analyzer:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 7168
RECONFIGURE
GO
4. Reboot Server
MarkYou don't need the /awe switch but other than you are right :-)
Also, note this KB about AWE + cluster failover Pending Timeout
http://support.microsoft.com/default.aspx?scid=kb;en-us;329914
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mark Sullivan" <msullivan@.getconnected.com> wrote in message
news:eDBCz8RuDHA.2360@.TK2MSFTNGP09.phx.gbl...
We are looking to take advantage of AWE in a single instance of SQL Server
2000 Enterprise running on a Windows 2000 Advanced Server. The cluster will
have 8GB of physical memory. I would like Sql Server to use 7GB and leave
1 GB for the O/S. If I understand the documentation correctly we need to do
the following:
1. Add "/pae /3gb /awe" to the boot.ini (I believe "/pae" is
necessary and the others are optional)
2. Make sure the sql server startup account is either an administrator
or has the Windows 2000 lock pages in memory privilege.
3. In query analyzer:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 7168
RECONFIGURE
GO
4. Reboot Server
Mark|||Thanks for the reply. Has AWE been a positive experience?
Ken

awe enabled but still has dynamic memory set

The main reason for these questions is each time I view the propery page for this instance I get and error generated in the event log => 1 Configuration option \'show advanced options\' changed from 1 to 1 <= and even though it is a warning it wasn't there before the awe memory was changed.

The dedicated s2k machine has 8GB of memory. AWE has been enabled, and max server memory set to 5120 (this is a clustered instance and the second machine only has 6 Gb. More is on order). When viewing properties for the instance it shows memory as being dynamic with max server memory = 5120.

Should the memory be set to something other than dynamically managed?

I confirmed the settings via sp_configure and AWE is enabled and memory is 5120... And perf mon shows target memory as around 5120 so it looks like things are set correctly. But the dynamically configure sql memory is still selected.

So is that an issue?

Thanks for any input.

MikeMike,

Set the memory to fixed when you use AWE. This way SQL won't have extend the memory whenever it needs it. It will save you some overhead.|||I was plan on making the change but was looking for some doco from Bill 1st.

Thanks for the response!!

Mike

AWE and multiple instance

I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have
installed SP4 and the AWE hotfix.
I have 3 instances running on the box:
If I have 1 instance using 7GB and the other 2 are using 4GB each, does
AWE need to be enabled on the instancese which are set to 4GB?
Thanks!
They won't be able to use the 4GB unless you enable AWE for them.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"traceable1" <tracykc@.gmail.com> wrote in message
news:1141139567.679350.285320@.z34g2000cwc.googlegr oups.com...
I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have
installed SP4 and the AWE hotfix.
I have 3 instances running on the box:
If I have 1 instance using 7GB and the other 2 are using 4GB each, does
AWE need to be enabled on the instancese which are set to 4GB?
Thanks!
|||Unless of course they are running on Win2K3 x64. In that case, the SQL2000
instance should be able use up to 4GB without enabling AWE.
Linchi
"Tom Moreau" wrote:

> They won't be able to use the 4GB unless you enable AWE for them.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "traceable1" <tracykc@.gmail.com> wrote in message
> news:1141139567.679350.285320@.z34g2000cwc.googlegr oups.com...
> I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have
> installed SP4 and the AWE hotfix.
> I have 3 instances running on the box:
> If I have 1 instance using 7GB and the other 2 are using 4GB each, does
> AWE need to be enabled on the instancese which are set to 4GB?
> Thanks!
>
|||I just assumed he was on 32-bit hardware, but you raise a good point.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:07C2D7BC-D085-4C5A-BA3D-ED599E571785@.microsoft.com...
Unless of course they are running on Win2K3 x64. In that case, the SQL2000
instance should be able use up to 4GB without enabling AWE.
Linchi
"Tom Moreau" wrote:

> They won't be able to use the 4GB unless you enable AWE for them.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "traceable1" <tracykc@.gmail.com> wrote in message
> news:1141139567.679350.285320@.z34g2000cwc.googlegr oups.com...
> I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have
> installed SP4 and the AWE hotfix.
> I have 3 instances running on the box:
> If I have 1 instance using 7GB and the other 2 are using 4GB each, does
> AWE need to be enabled on the instancese which are set to 4GB?
> Thanks!
>
|||One interesting question at that point...
What if had 16GB of RAM and would like to run first instance with 10GB RAM
and another 4 instances with 1GB of RAM each. (all 32 bit).
It's clear that the first one would need AWE, but what about the other 4?
2 of them wouldn't need AWE and they could alocate RAM dynamically right (3
with /3GB in boot.ini)?
But witch two? Is that important?
Would the instances without AWE have to start first and then the rest or
something like that?
Am I thinking in the right way here?
Tom K.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uObHIyKPGHA.1040@.TK2MSFTNGP12.phx.gbl...
>I just assumed he was on 32-bit hardware, but you raise a good point.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:07C2D7BC-D085-4C5A-BA3D-ED599E571785@.microsoft.com...
> Unless of course they are running on Win2K3 x64. In that case, the SQL2000
> instance should be able use up to 4GB without enabling AWE.
> Linchi
> "Tom Moreau" wrote:
>
|||That's an odd requirement. IIRC, up to about 12GB (per instance), you'd go
with both /3GB and /PAE. However, if you have those others that want 1GB,
I'd be sure to limit them explicitly to 1GB. Since they don't use AWE, then
if they start first and then the big instance starts up, I believe the
smaller ones would give up memory (if they're not already limited) to the
one requesting the AWE memory. Once it has its AWE memory, it won't give it
up.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Tom" <mcseman@.hotmail.com> wrote in message
news:u40kZ9KPGHA.648@.TK2MSFTNGP14.phx.gbl...
One interesting question at that point...
What if had 16GB of RAM and would like to run first instance with 10GB RAM
and another 4 instances with 1GB of RAM each. (all 32 bit).
It's clear that the first one would need AWE, but what about the other 4?
2 of them wouldn't need AWE and they could alocate RAM dynamically right (3
with /3GB in boot.ini)?
But witch two? Is that important?
Would the instances without AWE have to start first and then the rest or
something like that?
Am I thinking in the right way here?
Tom K.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uObHIyKPGHA.1040@.TK2MSFTNGP12.phx.gbl...
>I just assumed he was on 32-bit hardware, but you raise a good point.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:07C2D7BC-D085-4C5A-BA3D-ED599E571785@.microsoft.com...
> Unless of course they are running on Win2K3 x64. In that case, the SQL2000
> instance should be able use up to 4GB without enabling AWE.
> Linchi
> "Tom Moreau" wrote:
>

Availability after an instance crash.

Up to now I have no experience with an instance failure of
a large database.
If you have a database say 150 Gb, and the machine has
to 'reboot', what would be a 'normal' time before the
database is available again ?
And in a worse case scenario ?
What if the OS does start a diskcheck before booting ?
(On home pc's I have seen this happening, but never
on a serious server, can this happen on a server ?)
How long will it take SQL-server to 'recover', from
a crash ?
(I am thinking of failures like a power failure or
an OS crash, not a hardware failure).
On a small testsystem where I did try this kind of
scenario's, after the OS boot, it took SQL-server only
a small time to recover (seconds).
thanks for your attention,
ben brugman.Be
It really depends on the perfomance of your hardware. There is no set rule that I know of for time. It also depends on what needs to be recovered and what was in the log at the time of the crash. The more of the work in the log the longer the time. It could take anywhere from 1 minute to 45 minutes depending on how much work it has to do
Sorry it is so vagu
Jef
MCDBA, MCSE+I|||The recovery interval setting can impact the speed at which the =databases will be made available.
exec sp_configure 'recovery interval (min)'
Lots more information available within Books Online (within the SQL =Server program group). Read up on the recovery interval option.
I have not observed a checkdisk within a server based OS. I don't know =if it could happen or not.
In my experience the databases are available shortly after the machine =comes online. I have experienced a few hardware related machine crashes =that have caused a server to black screen (become totally unresponsive). = We had to press the power button to turn the machine off and back on =again. Upon restarting the database was available almost right away. =This was an OLTP database roughly 30 GB.
I have also worked with OLAP databases that were in the 150-200GB range =that the machine became unplugged from the UPS. Upon power-up SQL =Server was running and the databases were available in a few seconds.
The worst case scenario...you could loose your data.
A proper backup strategy is important! Make sure that you know how to =backup and restore databases. Books Online has lots of good information =in this area.
-- Keith
"ben brugman" <ben@.niethier.nl> wrote in message =news:OTyxOZ8IEHA.3720@.tk2msftngp13.phx.gbl...
> Up to now I have no experience with an instance failure of
> a large database.
> > If you have a database say 150 Gb, and the machine has
> to 'reboot', what would be a 'normal' time before the
> database is available again ?
> And in a worse case scenario ?
> > What if the OS does start a diskcheck before booting ?
> (On home pc's I have seen this happening, but never
> on a serious server, can this happen on a server ?)
> > How long will it take SQL-server to 'recover', from
> a crash ?
> > (I am thinking of failures like a power failure or
> an OS crash, not a hardware failure).
> > On a small testsystem where I did try this kind of
> scenario's, after the OS boot, it took SQL-server only
> a small time to recover (seconds).
> > thanks for your attention,
> ben brugman.
> >|||Thanks Jeff and Keith,
My greatest concern was the time the OS will take on a reboot.
(And do diskchecks or other time consuming matters).
As you both indicate that you are not concerned, I'll drop this
concern.
Thanks for your answers,
Ben Brugman
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OMKoDB9IEHA.3968@.TK2MSFTNGP12.phx.gbl...
The recovery interval setting can impact the speed at which the databases
will be made available.
exec sp_configure 'recovery interval (min)'
Lots more information available within Books Online (within the SQL Server
program group). Read up on the recovery interval option.
I have not observed a checkdisk within a server based OS. I don't know if
it could happen or not.
In my experience the databases are available shortly after the machine comes
online. I have experienced a few hardware related machine crashes that have
caused a server to black screen (become totally unresponsive). We had to
press the power button to turn the machine off and back on again. Upon
restarting the database was available almost right away. This was an OLTP
database roughly 30 GB.
I have also worked with OLAP databases that were in the 150-200GB range that
the machine became unplugged from the UPS. Upon power-up SQL Server was
running and the databases were available in a few seconds.
The worst case scenario...you could loose your data.
A proper backup strategy is important! Make sure that you know how to
backup and restore databases. Books Online has lots of good information in
this area.
Keith
"ben brugman" <ben@.niethier.nl> wrote in message
news:OTyxOZ8IEHA.3720@.tk2msftngp13.phx.gbl...
> Up to now I have no experience with an instance failure of
> a large database.
> If you have a database say 150 Gb, and the machine has
> to 'reboot', what would be a 'normal' time before the
> database is available again ?
> And in a worse case scenario ?
> What if the OS does start a diskcheck before booting ?
> (On home pc's I have seen this happening, but never
> on a serious server, can this happen on a server ?)
> How long will it take SQL-server to 'recover', from
> a crash ?
> (I am thinking of failures like a power failure or
> an OS crash, not a hardware failure).
> On a small testsystem where I did try this kind of
> scenario's, after the OS boot, it took SQL-server only
> a small time to recover (seconds).
> thanks for your attention,
> ben brugman.
>

Availability after an instance crash.

Up to now I have no experience with an instance failure of
a large database.
If you have a database say 150 Gb, and the machine has
to 'reboot', what would be a 'normal' time before the
database is available again ?
And in a worse case scenario ?
What if the OS does start a diskcheck before booting ?
(On home pc's I have seen this happening, but never
on a serious server, can this happen on a server ?)
How long will it take SQL-server to 'recover', from
a crash ?
(I am thinking of failures like a power failure or
an OS crash, not a hardware failure).
On a small testsystem where I did try this kind of
scenario's, after the OS boot, it took SQL-server only
a small time to recover (seconds).
thanks for your attention,
ben brugman.
Ben
It really depends on the perfomance of your hardware. There is no set rule that I know of for time. It also depends on what needs to be recovered and what was in the log at the time of the crash. The more of the work in the log the longer the time. It
could take anywhere from 1 minute to 45 minutes depending on how much work it has to do.
Sorry it is so vague
Jeff
MCDBA, MCSE+I
|||The recovery interval setting can impact the speed at which the =
databases will be made available.
exec sp_configure 'recovery interval (min)'
Lots more information available within Books Online (within the SQL =
Server program group). Read up on the recovery interval option.
I have not observed a checkdisk within a server based OS. I don't know =
if it could happen or not. =20
In my experience the databases are available shortly after the machine =
comes online. I have experienced a few hardware related machine crashes =
that have caused a server to black screen (become totally unresponsive). =
We had to press the power button to turn the machine off and back on =
again. Upon restarting the database was available almost right away. =
This was an OLTP database roughly 30 GB.
I have also worked with OLAP databases that were in the 150-200GB range =
that the machine became unplugged from the UPS. Upon power-up SQL =
Server was running and the databases were available in a few seconds.
The worst case scenario...you could loose your data.
A proper backup strategy is important! Make sure that you know how to =
backup and restore databases. Books Online has lots of good information =
in this area.
--=20
Keith
"ben brugman" <ben@.niethier.nl> wrote in message =
news:OTyxOZ8IEHA.3720@.tk2msftngp13.phx.gbl...
> Up to now I have no experience with an instance failure of
> a large database.
>=20
> If you have a database say 150 Gb, and the machine has
> to 'reboot', what would be a 'normal' time before the
> database is available again ?
> And in a worse case scenario ?
>=20
> What if the OS does start a diskcheck before booting ?
> (On home pc's I have seen this happening, but never
> on a serious server, can this happen on a server ?)
>=20
> How long will it take SQL-server to 'recover', from
> a crash ?
>=20
> (I am thinking of failures like a power failure or
> an OS crash, not a hardware failure).
>=20
> On a small testsystem where I did try this kind of
> scenario's, after the OS boot, it took SQL-server only
> a small time to recover (seconds).
>=20
> thanks for your attention,
> ben brugman.
>=20
>
|||Thanks Jeff and Keith,
My greatest concern was the time the OS will take on a reboot.
(And do diskchecks or other time consuming matters).
As you both indicate that you are not concerned, I'll drop this
concern.
Thanks for your answers,
Ben Brugman
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OMKoDB9IEHA.3968@.TK2MSFTNGP12.phx.gbl...
The recovery interval setting can impact the speed at which the databases
will be made available.
exec sp_configure 'recovery interval (min)'
Lots more information available within Books Online (within the SQL Server
program group). Read up on the recovery interval option.
I have not observed a checkdisk within a server based OS. I don't know if
it could happen or not.
In my experience the databases are available shortly after the machine comes
online. I have experienced a few hardware related machine crashes that have
caused a server to black screen (become totally unresponsive). We had to
press the power button to turn the machine off and back on again. Upon
restarting the database was available almost right away. This was an OLTP
database roughly 30 GB.
I have also worked with OLAP databases that were in the 150-200GB range that
the machine became unplugged from the UPS. Upon power-up SQL Server was
running and the databases were available in a few seconds.
The worst case scenario...you could loose your data.
A proper backup strategy is important! Make sure that you know how to
backup and restore databases. Books Online has lots of good information in
this area.
Keith
"ben brugman" <ben@.niethier.nl> wrote in message
news:OTyxOZ8IEHA.3720@.tk2msftngp13.phx.gbl...
> Up to now I have no experience with an instance failure of
> a large database.
> If you have a database say 150 Gb, and the machine has
> to 'reboot', what would be a 'normal' time before the
> database is available again ?
> And in a worse case scenario ?
> What if the OS does start a diskcheck before booting ?
> (On home pc's I have seen this happening, but never
> on a serious server, can this happen on a server ?)
> How long will it take SQL-server to 'recover', from
> a crash ?
> (I am thinking of failures like a power failure or
> an OS crash, not a hardware failure).
> On a small testsystem where I did try this kind of
> scenario's, after the OS boot, it took SQL-server only
> a small time to recover (seconds).
> thanks for your attention,
> ben brugman.
>

Availability after an instance crash.

Up to now I have no experience with an instance failure of
a large database.
If you have a database say 150 Gb, and the machine has
to 'reboot', what would be a 'normal' time before the
database is available again ?
And in a worse case scenario ?
What if the OS does start a diskcheck before booting ?
(On home pc's I have seen this happening, but never
on a serious server, can this happen on a server ?)
How long will it take SQL-server to 'recover', from
a crash ?
(I am thinking of failures like a power failure or
an OS crash, not a hardware failure).
On a small testsystem where I did try this kind of
scenario's, after the OS boot, it took SQL-server only
a small time to recover (seconds).
thanks for your attention,
ben brugman.Ben
It really depends on the perfomance of your hardware. There is no set rule
that I know of for time. It also depends on what needs to be recovered and
what was in the log at the time of the crash. The more of the work in the l
og the longer the time. It
could take anywhere from 1 minute to 45 minutes depending on how much work i
t has to do.
Sorry it is so vague
Jeff
MCDBA, MCSE+I|||The recovery interval setting can impact the speed at which the =
databases will be made available.
exec sp_configure 'recovery interval (min)'
Lots more information available within Books Online (within the SQL =
Server program group). Read up on the recovery interval option.
I have not observed a checkdisk within a server based OS. I don't know =
if it could happen or not. =20
In my experience the databases are available shortly after the machine =
comes online. I have experienced a few hardware related machine crashes =
that have caused a server to black screen (become totally unresponsive). =
We had to press the power button to turn the machine off and back on =
again. Upon restarting the database was available almost right away. =
This was an OLTP database roughly 30 GB.
I have also worked with OLAP databases that were in the 150-200GB range =
that the machine became unplugged from the UPS. Upon power-up SQL =
Server was running and the databases were available in a few seconds.
The worst case scenario...you could loose your data.
A proper backup strategy is important! Make sure that you know how to =
backup and restore databases. Books Online has lots of good information =
in this area.
--=20
Keith
"ben brugman" <ben@.niethier.nl> wrote in message =
news:OTyxOZ8IEHA.3720@.tk2msftngp13.phx.gbl...
> Up to now I have no experience with an instance failure of
> a large database.
>=20
> If you have a database say 150 Gb, and the machine has
> to 'reboot', what would be a 'normal' time before the
> database is available again ?
> And in a worse case scenario ?
>=20
> What if the OS does start a diskcheck before booting ?
> (On home pc's I have seen this happening, but never
> on a serious server, can this happen on a server ?)
>=20
> How long will it take SQL-server to 'recover', from
> a crash ?
>=20
> (I am thinking of failures like a power failure or
> an OS crash, not a hardware failure).
>=20
> On a small testsystem where I did try this kind of
> scenario's, after the OS boot, it took SQL-server only
> a small time to recover (seconds).
>=20
> thanks for your attention,
> ben brugman.
>=20
>|||Thanks Jeff and Keith,
My greatest concern was the time the OS will take on a reboot.
(And do diskchecks or other time consuming matters).
As you both indicate that you are not concerned, I'll drop this
concern.
Thanks for your answers,
Ben Brugman
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OMKoDB9IEHA.3968@.TK2MSFTNGP12.phx.gbl...
The recovery interval setting can impact the speed at which the databases
will be made available.
exec sp_configure 'recovery interval (min)'
Lots more information available within Books Online (within the SQL Server
program group). Read up on the recovery interval option.
I have not observed a checkdisk within a server based OS. I don't know if
it could happen or not.
In my experience the databases are available shortly after the machine comes
online. I have experienced a few hardware related machine crashes that have
caused a server to black screen (become totally unresponsive). We had to
press the power button to turn the machine off and back on again. Upon
restarting the database was available almost right away. This was an OLTP
database roughly 30 GB.
I have also worked with OLAP databases that were in the 150-200GB range that
the machine became unplugged from the UPS. Upon power-up SQL Server was
running and the databases were available in a few seconds.
The worst case scenario...you could loose your data.
A proper backup strategy is important! Make sure that you know how to
backup and restore databases. Books Online has lots of good information in
this area.
Keith
"ben brugman" <ben@.niethier.nl> wrote in message
news:OTyxOZ8IEHA.3720@.tk2msftngp13.phx.gbl...
> Up to now I have no experience with an instance failure of
> a large database.
> If you have a database say 150 Gb, and the machine has
> to 'reboot', what would be a 'normal' time before the
> database is available again ?
> And in a worse case scenario ?
> What if the OS does start a diskcheck before booting ?
> (On home pc's I have seen this happening, but never
> on a serious server, can this happen on a server ?)
> How long will it take SQL-server to 'recover', from
> a crash ?
> (I am thinking of failures like a power failure or
> an OS crash, not a hardware failure).
> On a small testsystem where I did try this kind of
> scenario's, after the OS boot, it took SQL-server only
> a small time to recover (seconds).
> thanks for your attention,
> ben brugman.
>

Autostart MS Agent on Win98/Me

Hello,
does anyone know how I could autostart the MSAgent on Win98/Me with a
named instance.
I try with
scm.exe -Action 1 -Service SQLAgent$$" & str_InstanceName
where str_InstanceName is the name of the MSDE Instance.
The password is correct (I exported the crypted password from a computer
with Entreprise manager and the agent start with WinNT...
It can also start manually.
On Winnt, 2K and XP, all is fine, on Win98/Me, I receive the message
Service operation has been completed successfully but the agent did not
start. I can manually start the agent with the MSDE service manager, but
if my custommer forget it then he has no automatic backup of his database.
Thank you
Marc Allard
Allcomp
If you really rely on SQL Server Agent being started and you have not a lot
of control over the machine, start SQL Server Agent from within SQL Server:
-- Create a procedure to start SQL Server Agent
USE master
GO
CREATE PROC usp_start_sqlserveragent
AS
EXEC master..xp_cmdshell 'net start SQLServerAgent'
GO
-- Mark stored procedure to run on SQL Server start
EXEC sp_procoption 'usp_start_sqlserveragent', 'startup', 'true'
Jacco Schalkwijk
SQL Server MVP
"Allcomp" <marc@.nospam.allcomp.be> wrote in message
news:41e279f2$0$2676$ba620e4c@.news.skynet.be...
> Hello,
> does anyone know how I could autostart the MSAgent on Win98/Me with a
> named instance.
> I try with
> scm.exe -Action 1 -Service SQLAgent$$" & str_InstanceName
> where str_InstanceName is the name of the MSDE Instance.
> The password is correct (I exported the crypted password from a computer
> with Entreprise manager and the agent start with WinNT...
> It can also start manually.
> On Winnt, 2K and XP, all is fine, on Win98/Me, I receive the message
> Service operation has been completed successfully but the agent did not
> start. I can manually start the agent with the MSDE service manager, but
> if my custommer forget it then he has no automatic backup of his database.
>
> Thank you
> Marc Allard
> Allcomp
|||That will never work on Windows 9x based OS's since there is no concept of a
real service which gets started with NET START. Only Windows NT based OS's
(and OS/2) have NET START.
You can use SCM.EXE instead
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid > wrote
in message news:eU1Ed3y9EHA.2876@.TK2MSFTNGP12.phx.gbl...
> If you really rely on SQL Server Agent being started and you have not a
> lot of control over the machine, start SQL Server Agent from within SQL
> Server:
> -- Create a procedure to start SQL Server Agent
> USE master
> GO
> CREATE PROC usp_start_sqlserveragent
> AS
> EXEC master..xp_cmdshell 'net start SQLServerAgent'
> GO
> -- Mark stored procedure to run on SQL Server start
> EXEC sp_procoption 'usp_start_sqlserveragent', 'startup', 'true'
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Allcomp" <marc@.nospam.allcomp.be> wrote in message
> news:41e279f2$0$2676$ba620e4c@.news.skynet.be...
>
|||Right. Seems Win9x is a bit too long ago for me. I better not answer any
more questions that involve Win 9x
Jacco Schalkwijk
SQL Server MVP
"Gert E.R. Drapers" <GertD@.SQLDev.Net> wrote in message
news:eyuMfi09EHA.1544@.TK2MSFTNGP11.phx.gbl...
> That will never work on Windows 9x based OS's since there is no concept of
> a real service which gets started with NET START. Only Windows NT based
> OS's (and OS/2) have NET START.
> You can use SCM.EXE instead
> GertD@.SQLDev.Net
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> You assume all risk for your use.
> Copyright SQLDev.Net 1991-2004 All rights reserved.
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid >
> wrote in message news:eU1Ed3y9EHA.2876@.TK2MSFTNGP12.phx.gbl...
>
|||Hello,
Thank you for your answers, but I already try to start the agent with
scm, but it doesn't start. If I start it manually with SQL Server
Service Manager, then it is working.
Is there something to do an automatic backup without the agent?
Thank you
Marc Allard
Allcomp
Jacco Schalkwijk wrote:
> Right. Seems Win9x is a bit too long ago for me. I better not answer any
> more questions that involve Win 9x
>

AutoStart

Hi,
Installed MSDE desktop (sp3) on XP, however the server does not autostart on
re-booting the machine. In the service manager the server/instance name is
missing after every re-boot. I enter it manually, check the autostart box
and it runs fine, but again after re-boot the server/instance name is lost
again.
I know our work machines are limited in allowing us to edit the registry,
but on a same build machine with full sql svr installed the problem does not
occur.
Any idea?
Cheers, Josh
Hi,
In Control Panel -- Admin tools -- Services -- Select the SQL Server
service.
Double click on the services and make it to automatic and click ok.
Thanks
Hari
SQL Server MVP
"Josh" <joshua.phillips@.notthisbit.blueyonder.co.uk> wrote in message
news:8CF778B9-DED3-48D2-912E-9EEFCC91BA80@.microsoft.com...
> Hi,
> Installed MSDE desktop (sp3) on XP, however the server does not autostart
> on
> re-booting the machine. In the service manager the server/instance name
> is
> missing after every re-boot. I enter it manually, check the autostart box
> and it runs fine, but again after re-boot the server/instance name is lost
> again.
> I know our work machines are limited in allowing us to edit the registry,
> but on a same build machine with full sql svr installed the problem does
> not
> occur.
> Any idea?
> Cheers, Josh
|||Hi,
It is alreday set to auto - the icon in the task bar tray does start, but
the white circle is empty. When I then click on the sql server service
manager, the server / instance name is blank - i.e. it is not remembering the
server / instance name from before the reboot.
Josh
"Hari Prasad" wrote:

> Hi,
> In Control Panel -- Admin tools -- Services -- Select the SQL Server
> service.
> Double click on the services and make it to automatic and click ok.
> Thanks
> Hari
> SQL Server MVP
>
> "Josh" <joshua.phillips@.notthisbit.blueyonder.co.uk> wrote in message
> news:8CF778B9-DED3-48D2-912E-9EEFCC91BA80@.microsoft.com...
>
>
|||hi Josh,
Josh wrote:
> Hi,
> Installed MSDE desktop (sp3) on XP, however the server does not
> autostart on re-booting the machine. In the service manager the
> server/instance name is missing after every re-boot. I enter it
> manually, check the autostart box and it runs fine, but again after
> re-boot the server/instance name is lost again.
> I know our work machines are limited in allowing us to edit the
> registry, but on a same build machine with full sql svr installed the
> problem does not occur.
please have a look at
http://support.microsoft.com/default...b;EN-US;814132
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