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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Backup tail of database before restore

Author  Topic 

nguyenl
Posting Yak Master

128 Posts

Posted - 2009-02-27 : 12:45:18
Hi,

Sql always makes you backup the tail of the database that you are restoring. Are we able to override this? What if we don't want to back it up?

Please assist.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-27 : 14:14:46
You don't have to backup the tail of the database to perform a restore. What happens if the database isn't available in the first place due to a crash?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

nguyenl
Posting Yak Master

128 Posts

Posted - 2009-02-27 : 17:11:58
Hi,

I have 2 databases. 1 is the test database, and the other is production. The backup is done for the Production database, and after the backup has completed, I would like to restore it to the Test database. Since it is a database used just for testing, I don't want to back it up.

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-27 : 17:16:33
There is nothing out of the ordinary with what you have described. You just need to specify WITH REPLACE on the RESTORE command.

You may be interested in a blog I posted earlier this week which shows how to restore a test database with a copy of production: http://weblogs.sqlteam.com/tarad/archive/2009/02/25/How-to-refresh-a-SQL-Server-database-automatically.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -