Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup/restore Expand / Collapse
Author
Message
Posted Wednesday, April 08, 2009 12:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Wednesday, April 08, 2009 3:33 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 6:00 AM
Points: 806, Visits: 413
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.
Post #692879
Posted Wednesday, April 08, 2009 3:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Wednesday, April 08, 2009 3:56 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 6:00 AM
Points: 806, Visits: 413
What error message you are getting while trying to restore the file ? Also mention the steps you have followed for restoration.
Post #692896
Posted Wednesday, April 08, 2009 5:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
karan457 (4/8/2009)
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


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

Post #692962
Posted Wednesday, April 08, 2009 6:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:42 PM
Points: 14,840, Visits: 27,315
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 »

Add to briefcase

Permissions Expand / Collapse