April 1, 2002 at 12:50 pm
Hello everyone,
I have a database with 1_Data.mdf and five
2_Data.Ndf, 3_Data.Ndf, 4_Data.Ndf, 5_Data.Ndf files, my backups are on 1_date.bak file (data backups) full backup on weekend and differential on weekdays. My question is in case I need to run recovery, will SQLServer be able to spread across five different data files with 1 backup file or am I in trouble?
Thanks for help
Raghu
Raghu
Raghu
April 1, 2002 at 2:27 pm
April 1, 2002 at 2:51 pm
Do this all the time to seperate read tables from read/write tables and have never had an issue with single Backup file (Just test them periodically to make sure no instabilities/corruption in the file).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 1, 2002 at 9:13 pm
We do this without issue as well where multiple .MDF files go into a single .BAK file. We've not had a failure, though we do test periodically, as Antares has already indicated.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply