Restore BAK Help

[excalibur78]

We had some issues that lead to the need to restore from backup. The .bak file is 5megs. When I try to restore it's making a huge 35gig+ log file and basically hangs. It never restores the db.

Is there anyway I can restore the db without the log file?

Why would the .bak file be 5megs but the restored log file be in access of 35gig's? This was after an hour of letting it restore. I'd imagine the log file is 2-3 times that size even tho it's a 5mrg .bak file.

 

[JayKusch]

If the backup was done properly, there is not a way, not that I know of, to restore just the MDF, database file and not the LDF, the transaction.

Try running this query in Query Analyzer to see some info on the backup file ...

If backup is on tape ... use this:

RESTORE FILELISTONLY
FROM TAPE = '\\.\TAPE0'

If backup is on disc ... use this:

RESTORE FILELISTONLY
FROM TAPE = 'C:\MyDir\5mrg.bak'

of course change the path to the one that matches your server.




Thanks

J. Kusch

 

[JBaileys]

Running the restore fileonly gave me this error...

Server: Msg 3230, Level 16, State 1, Line 1
Operation on device 'c:\backup\dbname.mdf' exceeded retry count.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.

dbname.mdf is the name of our database.

 

[JayKusch]

Sounds like a bad tape or tape backup unit. Try running a cleaning tape thru it, check all of your cables on the back of the TBU as well as the server.

Thanks

J. Kusch

 

[camy123]

what i would do is delete the MDf and restore from the transaction log providing you have a full backup to hand on disk.