Hi all,
What are all the options to backup and restore part of a large database. Please note that I need the option to restore only part of the database from an old backup but to be able to keep the rest of the database current.
Thanks,
Avi
Hi,
as you already might have found out this is not supported unless you backed up single file groups which would be restoreable while other data would be available. If you made full backup, you will have to restore the database with another name, get the data from the restored database and delete it afterwards.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment