April 8, 2009 at 12:47 am
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
April 8, 2009 at 3:33 am
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.:-)
April 8, 2009 at 3:51 am
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
April 8, 2009 at 3:56 am
What error message you are getting while trying to restore the file ? Also mention the steps you have followed for restoration.
April 8, 2009 at 5:48 am
karan457 (4/8/2009)
Thanks for u r replyi 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?
April 8, 2009 at 6:34 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply