quote:

---

Originally posted by RickD

You got last nights backup? If so, then what changes would have occured?

Restore that as a different name and just make sure that the .MDF file is really your primary.

---

quote:

---

Originally posted by jhermiz

I'm not a db admin...so bare with me :).
Came in this morning...db is gone...I dont see it in EM / Query Analzyer. Tried to reattach it and SQL Server 2k complained...
So I tried doing the following:

EXEC sp_attach_single_file_db @dbname = 'JTESv1',
@physname = 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\JTESv1_Data.MDF'

And I get:

Server: Msg 5173, Level 16, State 1, Line 1
Cannot associate files with different databases.
Server: Msg 1813, Level 16, State 1, Line 1
Could not open new database 'JTESv1'. CREATE DATABASE is aborted.
Log file 'd:\Progra~1\Micros~1\MSSQL\data\JTESv1_log.LDF' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.


I know its got something to do with the log file....but not sure how to fix it. I also tried renaming the db and recreating a new one and then tried reattaching the old one back and no luck.

Any db admins have any recommendations on getting this sucker back up?

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

---

quote:

---

Originally posted by jhermiz

I'm not a db admin...so bare with me :).

---

quote:

---

Originally posted by jhermiz

I ended up restoring from 4am..thank god!

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

---