Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 resore database

Author  Topic 

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-30 : 04:37:51
Hi

how to restore database from the file type 'filename.bak.gz'
when i tried to restore the database from the 'filename.bak.gz'
the errior is
'error: 3242 the file on device 'C:\Documents and Settings\sd\'filename.bak.gz' is not a vaild microsoft type backup set restore filelistonly is terminating abnormally'

please give me your suggestions

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-01-30 : 05:26:23
successfully i RESTORED the database just I UNZIPPED THE FILE .

Thank you
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-30 : 05:59:00
Great!
I guess that is what the file extension said.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -