April 16, 2010 at 2:57 am
Hi,
I have a large database which i want to make a backup, but we want to eliminate the data of the main database when the backup is done.. What's the better strategy to make this? Create different files of backup or we can concat information in the original file of backup?
April 16, 2010 at 3:02 am
You can use striped backup but its is sometimes risky
Backup database database name to disk='C:\backupfile_1.bak',disk='D:\backupfile_2.bak','E:\backupfile_3.bak
You need all these files for proper restore. Any corruption in single file can make the entire set useless
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply