Re: recover SQL Server 2005 database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Copy the .mdf and ldf and then Attach:

Enterprise Manager ->Databases->All Tasks->Attach

or search BOL for sp_attach_db or sp_attach_single_file_db

"justin" <justin.creasy@xxxxxxxxx> wrote in message
news:1187275664.474757.161340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello, I recently had what I believe is a hardware problem on a
server. I have been able to pull the hard-drives and copy all of the
information from them to a backup.

My problem is there was a SQL Server database that I had never backed
up. Is there a way that I can copy files over to another computer
running SQL Server and still see this database? The actual data in it
is not as important as the tables and stored procedures are. Any help
will be greatly appreciated.



.

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)