Hi there,

Red Gate have two tools which may interest you, the first is Dependecy Tracker which will give you a graphical output of your database (you can filter the...

Winston,

Have a look at RESTORE HEADERONLY and RESTORE FILELISTONLY,

- James

Its more the state of the database once the restore is finshed which I am interested in - I was wondering if you use RECOVERY rather than NORECOVERY if the...

If you run the restore command using RECOVERY rather than NORECOVERY what does the database show once the restore has failed?

- James

yeah sorry I missed that before,

- James

Just as a reference your restore command would like somthing like this:

RESTORE DATABASE cms FROM .... WITH CONTINUE_AFTER_ERROR, MOVE 'CMS_DATA' TO 'c:\CMS_DATA.mdf', MOVE 'CMS_LOG' TO 'c:\CMS_LOG.ldf'

Where CMS_DATA and CMS_LOG...

Are you trying to restore this database to the same server the backup was taken from?

If you dont have a D drive then you will have to run the restore...

The MDF file is not the backup file but the actual data file SQL Server uses - the bak file will be inside the mediaset, however we need the mdf...

OK lets try a slightly different approach,

I first want you to detach the database using sp_detch_db

EXEC sp_detch_db @dbname='cms' 

We will then try and get SQL Server to rebuild the log (I have...

What happens if you run CHECK DB on the resulting database?

- James

What is the extact error if you run

RESTORE DATABASE cms FROM (file) WITH CONTINUE_AFTER_ERROR, NORECOVERY

- James

Can you post the exact commands you have run to get to the state you are in (block out server/database/paths if you want) ?

- James

Ahh the database remains in Restoring... in SSMS?

Give the following command a go once you have done your original restore:

RESTORE DATABASE dbName WITH RECOVERY

- dbName (Restoring...) in...

Marcus,

You can probably use: sp_who2, sp_locks, DBCC INPUTBUFFER, DBCC OUTPUTBUFFER, the system tables/views and some of the SQL TRACE stored procedures (see BOL) to find how to use them..

- James

Have a look here: http://msdn2.microsoft.com/en-us/library/ms190952.aspx and you might also want to have a look at DBCC CHECKDB once you have it going.. http://blogs.neogeo.com/blogs/marchoeppner/archive/2006/01/01/31.aspx.

One other thing to check, which...