Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
 Posted - 2008-01-30 : 08:09:46
|
| Does anyone know how to manually start-up databases? Because an error occurs if for example you have like 300 databases in a server and you restarted your server and executed something on the 300th database which is not started yet.database (ID) cannot be autostarted on server shutdown startup.SlayerS_`BoxeR` + [ReD]NaDa |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-01-30 : 08:36:28
|
quote:
Originally posted by mightypenny_ph
Does anyone know how to manually start-up databases? Because an error occurs if for example you have like 300 databases in a server and you restarted your server and executed something on the 300th database which is not started yet.database (ID) cannot be autostarted on server shutdown startup.SlayerS_`BoxeR` + [ReD]NaDa
This happens ??? strange !! i would want to know how to go about this as well... and whoa ! 300 databases on a server ?? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-30 : 08:38:32
|
I don't get you.The server is started and you try to "execute something" on a database that is "not" started?To "execute" something you have to make a connection to the database first.If the server is not ready, the connection can not be made.Please explain more what your problem is.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2008-01-30 : 08:52:53
|
| i mean the server is started but the database is not. There's an autoclose property in the database right?For example, your connection's DB is master and you executed something like this like 2seconds after starting SQL Server. Also note that this is executed via VBS file.SELECT * FROM <300th DB>..sysfilesSlayerS_`BoxeR` + [ReD]NaDa |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-30 : 09:05:11
|
You have AUTOCLOSE checked for production databases?And I can image you also have AUTOSHRINK turned on?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2008-01-30 : 09:09:06
|
| yes. it's actually archived databases.SlayerS_`BoxeR` + [ReD]NaDa |
|
|
|
|
|
|
How to manually start databases?