October 21, 2013 at 9:51 pm
Dear All
On General tab of backup screen in SMMS we have Destination. Here we can add multiple files (assuming we selected back up to disk). This creates a media set correct?
Does this means that the backup is split into many files?
Regards
Krishna
October 22, 2013 at 1:05 am
Yes, the backup is striped over all the specified files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2013 at 5:00 am
And you'll need each and every one of those files to restore the database.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
October 24, 2013 at 3:33 am
Thanks all
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply