InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 07:09:31 GMT20http://www.sqlservercentral.com/Forums/Topic692783-357-1.aspxAfter 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 [url=http://www.simple-talk.com/sql/backup-and-recovery/sql-server-2005-backups]introductory article [/url]on backups & restores that might help.Wed, 08 Apr 2009 06:34:57 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic692783-357-1.aspx[quote][b]karan457 (4/8/2009)[/b][hr]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[/quote]How are you restoring, as sugegsted could you post the commands and error please?Wed, 08 Apr 2009 05:48:08 GMTmaechismo_8514http://www.sqlservercentral.com/Forums/Topic692783-357-1.aspxWhat error message you are getting while trying to restore the file ? Also mention the steps you have followed for restoration.Wed, 08 Apr 2009 03:56:54 GMTAtul DBAhttp://www.sqlservercentral.com/Forums/Topic692783-357-1.aspxThanks 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 doWed, 08 Apr 2009 03:51:03 GMTkaran457-979314http://www.sqlservercentral.com/Forums/Topic692783-357-1.aspxHi,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.:-)Wed, 08 Apr 2009 03:33:38 GMTAtul DBAhttp://www.sqlservercentral.com/Forums/Topic692783-357-1.aspxHi 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 meplease tell me the procedure both sql 2000 and 2005Thanks in advanceWed, 08 Apr 2009 00:47:18 GMTkaran457-979314