Re: Bulk restoring databases
Thanks a lot Ian! I thought I got no responses to that one, but it seems my mail filters are ineffective... ;) David Ian Tait wrote: > > You could script it... > > >From tsql help: > > This example restores a full database and transaction log and moves the > restored database into the C:\Program Files\Microsoft SQL > Server\MSSQL\Data > directory. > > RESTORE DATABASE MyNwind >FROM MyNwind_1 >WITH NORECOVERY, > MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL > Server\MSSQL\Data\NewNwind.mdf', > MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL > Server\MSSQL\Data\NewNwind.ldf' > RESTORE LOG MyNwind >FROM MyNwindLog1 >WITH RECOVERY > > Restore an entire database: > > RESTORE DATABASE { database_name | @database_name_var } > [ FROM < backup_device > [ ,...n ] ] > [ WITH > [ RESTRICTED_USER ] > [ [ , ] FILE = { file_number | @file_number } ] > [ [ , ] PASSWORD = { password | @password_variable } ] > [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] > [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable > } ] > [ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ] > [ ,...n ] > [ [ , ] KEEP_REPLICATION ] > [ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ] > [ [ , ] { NOREWIND | REWIND } ] > [ [ , ] { NOUNLOAD | UNLOAD } ] > [ [ , ] REPLACE ] > [ [ , ] RESTART ] > [ [ , ] STATS [ = percentage ] ] > ] > > Ian > > -Original Message- > From: David Cummins [mailto:[EMAIL PROTECTED]] > Sent: 27 February 2002 05:11 > To: CF-Talk > Subject: Bulk restoring databases > > Hi all, > > Anybody know how to bulk restore MSSQL 7 databases, i.e. if you have 40 > backups > how you'd restore them all on the same SQL box? Bulk backup capability > would > also be nice if you know how... > > David > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bulk restoring databases
You could script it... >From tsql help: This example restores a full database and transaction log and moves the restored database into the C:\Program Files\Microsoft SQL Server\MSSQL\Data directory. RESTORE DATABASE MyNwind FROM MyNwind_1 WITH NORECOVERY, MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf', MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf' RESTORE LOG MyNwind FROM MyNwindLog1 WITH RECOVERY Restore an entire database: RESTORE DATABASE { database_name | @database_name_var } [ FROM < backup_device > [ ,...n ] ] [ WITH [ RESTRICTED_USER ] [ [ , ] FILE = { file_number | @file_number } ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ] [ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ] [ ,...n ] [ [ , ] KEEP_REPLICATION ] [ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ] [ [ , ] { NOREWIND | REWIND } ] [ [ , ] { NOUNLOAD | UNLOAD } ] [ [ , ] REPLACE ] [ [ , ] RESTART ] [ [ , ] STATS [ = percentage ] ] ] Ian -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: 27 February 2002 05:11 To: CF-Talk Subject: Bulk restoring databases Hi all, Anybody know how to bulk restore MSSQL 7 databases, i.e. if you have 40 backups how you'd restore them all on the same SQL box? Bulk backup capability would also be nice if you know how... David __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Bulk restoring databases
David, It may be worth your while looking into the BCP utility. Check the sql server books online. Jared Clinton NEC Australia -Original Message- From: David Cummins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 27 February 2002 3:11 PM To: CF-Talk Subject: Bulk restoring databases Hi all, Anybody know how to bulk restore MSSQL 7 databases, i.e. if you have 40 backups how you'd restore them all on the same SQL box? Bulk backup capability would also be nice if you know how... David __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists