Backup/restore

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Backup/restore

Backup/restore

Rate Topic

Display Mode

Topic Options

Author

Message

karan457-979314

Posted Wednesday, April 08, 2009 12:47 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, June 11, 2009 4:04 AM
Points: 43, Visits: 269

Hi iam can anybody tell

How to take backup in zip and

How to restore that

i have a zipfile backup
how to restore that .bak file

please suggest me

please tell me the procedure both sql 2000 and 2005

Thanks in advance

Post #692783

Atul DBA

Posted Wednesday, April 08, 2009 3:33 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 11, 2010 5:51 AM
Points: 579, Visits: 337

Hi,

First of all you need to unzip the file using Winzip or other tools and then try to restore the extratced BAK file.

The restore process is same in SQL Server 2000 and 2005. You can also use the SQL Enterprise Manager to restore the database.

Normally you can't take a database backup in zip file. You need to take a backup and then zip the file to save the space. But zipping the file process is high resource eater. So check that also.

Hope this information will help you. Smile

Post #692879

karan457-979314

Posted Wednesday, April 08, 2009 3:51 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, June 11, 2009 4:04 AM
Points: 43, Visits: 269

Thanks for u r reply
i tried with un zip file also

that unzip .bak file i copied n pasted in default folder then
i tried to restore that file
still iam unable to do

pls can u give solution what to do

Post #692894

Atul DBA

Posted Wednesday, April 08, 2009 3:56 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 11, 2010 5:51 AM
Points: 579, Visits: 337

What error message you are getting while trying to restore the file ? Also mention the steps you have followed for restoration.

Post #692896

Krishna Potlakayala

Posted Wednesday, April 08, 2009 5:48 AM

Ten Centuries

Group: General Forum Members
Last Login: Sunday, February 21, 2010 9:10 PM
Points: 1,095, Visits: 2,079

karan457 (4/8/2009)

How are you restoring, as sugegsted could you post the commands and error please?

Post #692962

Grant Fritchey

Posted Wednesday, April 08, 2009 6:34 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:32 PM
Points: 7,395, Visits: 15,202

After you unzip the file you need to run a RESTORE command. If you're getting particular errors with the restore, please post them. If you're really unsure how to use the restore, here's an introductory article on backups & restores that might help.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of SQL Server 2008 Query Performance Tuning Distilled

For better & quicker help read:
How to Post Performance Problems

Post #693004

« Prev Topic | Next Topic »

Permissions