Restore from MDF/LDF files
Posted on 2007-11-26
I have root access to my W2K3 server with SQL Server 2005 installed on it. An unrelated melt-down caused me to use the hosting control panel to delete a domain. Deleting the domain also deleted the SQL Server database. I run Backup For Workgroups (with the open file add-on designed for SQL Server) and make nightly backups.
I can restore these files: foo.mdf, foo.ldf
Here is what I have done.
1) Stopped SQL Server
2) Copied the mdf and ldf files to the SQL directory
3) Restarted SQL Server
Q1) How can I confirm that the data is now restored? Do I run a query? If so, how do I go about it?
A web app is now giving me the error: "Cannot open database "foo" requested by the login. The login failed.
Login failed for user 'tester'."
I have created/deleted/re-created the tester user several times but it doesn't resolve the issue.
Q3) How do I resolve this issue?