Hi Folks,

I am having problems restoring a BAK from one system onto another system.
I am getting "cannot associate files" errors.

But my immediate problem is that my unsuccessful restore attempts have left
my database in a "Loading/suspect" state.  How do I get back to some normal
state?

Then I would appreciate some help with the restoring problems.  Can give
more details later.

Thanks,
Tom

Tom Glasser (TomGlas***@discussions.microsoft.com) writes:
You complete the RESTORE. The database is now in an incomplete state,
and there is no way back to where you started, as apparently one or
more files has been overwritten.

Or drop the database, and start all over.

It would help if you supplied the command you are using, and the
error message.

If you use a GUI to restore (which I recommend against), you can use
the Script button in SQL Server Management Studio to get the command
SSMS uses. If you are on SQL 2000, you will need to use Profiler to
spy on Enterprise Manager.

Square Brackets
Database copy
one-to-one relationships in a database diagram
Last Modified Date of table, queries, views, sprocs
SQLDMO with VB6