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 |
|
smorty44
Yak Posting Veteran
93 Posts |
 Posted - 2008-01-18 : 17:40:12
|
| We are using a .bat script to restore several client dbs onto our sql server 2000 db. We want to set the client dbs from full recovery to simple. What command should I use in the .bat file to make this change?.bat file ==:: Second, restore data from SQL Server backup file to SQL server...isql -E -S ao3\ao3 -Q "RESTORE DATABASE CBSN FROM DISK = 'D:\MARS_SYS\DATAUPDATES\CBSN\CBSN.BAK' WITH MOVE 'MEDISUN_BCNV_Data' TO 'D:\SQLDATA\CBSN_data.mdf', MOVE 'MEDISUN_BCNV_Log' TO 'D:\SQLDATA\CBSN_log.ldf',REPLACE;" |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-18 : 21:19:09
|
| need to execute an alter database set recovery statement. cant do it as far as i know in a restore stmt |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-19 : 05:03:29
|
| ALTER DATABASE DatabaseName SET RECOVERY SIMPLEJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
Recovery Model to Simple