ansaurus

Question

Sql 2008 Restoring a backed up DB fails - what else can i do?

Answer 1

A:

We do the same thing every morning.

RESTORE DATABASE Accounts FROM DISK = '\\server\F$\SQL_BACKUP\DB.bak' WITH REPLACE

This works fine for us. I'm not sure if the x64 > x32 will have an impact, I wasn't aware that data was stored differently between those kinds of platforms. We basically dump our live database every night, a process on our SQL server then picks them up, and another process sends them to be backed up to disk.

The command above will create you a new database and import the data, it's worth a shot.

Kezzer 2009-02-06 08:14:21

Answer 2

A:

Sounds like your production database has some corruption. Run DBCC CHECKDB on your production database and see what is returned.

mrdenny 2009-02-06 08:14:41

yep - just did this and it failed. running the DBCC CheckDB right now.

Pure.Krome 2009-02-08 23:31:33

Updated inital post with more info.

Pure.Krome 2009-02-08 23:49:24

Did checkdb tell you anything when you ran it? (If you still happen to have the output).

mrdenny 2009-02-14 07:31:54

Answer 3

A:

Does a restore on the live machine (to a different db) fail? If so, try running DBCC CHECKDB.

devio 2009-02-06 08:16:36

It failed on the Live machine also. What i did => task->backup live. Create new db. Restore back to this new (dummy) db. Same failure message. I'm running a DBCC CHECKDB('LiveDB') now....

Pure.Krome 2009-02-08 23:30:54

Updated inital post with more info.

Pure.Krome 2009-02-08 23:51:23

Answer 4

+1 A:

Hi,

This is IMPORTANT, you may potentially have an issue with the live database.

Have you performed DBCC CHECKDB on your production server recently? If not, do so at the next possible maintenance window.

You should ideally be performing CHECKDB before you take your full backups (although not always practical) in order to validate that the backups you are generating, are of a database that has been confirmed to be without issue.

Please feel free to pose further questions. You can contact me directly if you require additional assistance.

Cheers, John

John Sansom 2009-02-06 09:20:14

Just running the command ( DBCC CHECKDB('LiveDB') )on the live db (after i did a manual copy of the mdb and log files with the service stopped) .. hope this works!

Pure.Krome 2009-02-08 23:32:55

Updated inital post with more info.

Pure.Krome 2009-02-08 23:51:57

John, after i ran DBCC CHECKDB('LiveDB') and then tried a restore .. it worked. Does DBCC CHECKDB do anything, regardless of finding errors or not? or is it purely a thing that CHECKS for problems?

Pure.Krome 2009-02-09 04:21:35

Given that DBCC CheckDB has not produced any error messages, it would appear that your production database is in working order. The source of your issue is likely elsewhere. See my latest comment added to your question.

John Sansom 2009-02-09 09:05:19

ansaurus

tags:

views:

answers:

Sql 2008 Restoring a backed up DB fails - what else can i do?

related questions