How to restore split backups? - SQL Server Forums

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

SQL Server 2005 Forums

SSIS and Import/Export (2005)

How to restore split backups?

Author

Topic

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2008-08-15 : 16:30:45

Hi All,

I have recieved backup files from someone that belong to a same database, which I need to restore on one of our server. The backup files (same database) looks some kind of split files and there's no extenion in the file name. Here are the name of the backup files.

PSDB8-14-08Splitzip.z01
PSDB8-14-08Splitzip.z02
PSDB8-14-08Splitzip.z03
PSDB8-14-08Splitzip.z04
PSDB8-14-08Splitzip.z05
PSDB8-14-08Splitzip.z06
PSDB8-14-08Splitzip.z07
PSDB8-14-08Splitzip.z08
PSDB8-14-08Splitzip.z09

I am used to restore .bak file backups and have never dealt with splits backup. The .bak backups are easy to restore and I restore it in SQL 2005 managment studio with the following steps;
a) I right clicking on the existing database (where I want it to be restored) and b) then click Tasks , c) click Restore, and d) click Database, and e) then in the restore database window click 'From device', f) then click '...' to browse and g) click add to browse and add the backup file to be restored.

How can I restore the above backup using SQL Server Managment Studio?

Please help.

Thanks,

Zee

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-15 : 16:40:26

These split backups are done via WinZip or whatever. You'll need to fix that first as RESTORE can't handle that.

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

Subscribe to my blog

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2008-08-15 : 16:44:35

You mean fix it in winzip? How to fix it?
Please suggest.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-15 : 16:47:11

I don't have Winzip installed anymore. I'm sure if you opened the files in Winzip, you'd be able to figure it out.

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

Subscribe to my blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-15 : 16:51:57

Don't you see Extract button on top. Put it in location you desire and unzip it.

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2008-08-18 : 19:02:59

Sodeep,

That's what I did. It worked. Thanks for your help :)

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-18 : 20:40:41

Glad to hear that.