Backup/restore

SQLServerCentral is supported by Red Gate Software Ltd.

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

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 12:43 PM
Points: 806, Visits: 412

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

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 12:43 PM
Points: 806, Visits: 412

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

Post #692896

maechismo_8514

Posted Wednesday, April 08, 2009 5:48 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157

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

SSChampion

Group: General Forum Members
Last Login: Today @ 3:40 PM
Points: 13,380, Visits: 25,164

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #693004

« Prev Topic | Next Topic »

Permissions