SQL recovery qurestion

[hmdeassis]

I have to rebuild my SQL server(sql7). Somebody told me that I should be able to just copy the DB from the old server into the new one. I planning to have the same server name and IP address and copy the DB to the exact same location.

Is there anything else I need to to in the enterprise manager in order to have the db loaded and working.

Please....any additional info is greatly appreciated.

H

 

[mrdenny]

You'll need to attach the database to the SQL Server. I don't think that the SQL 7 Enterprise Manager has a GUI option to attach the database. You'll probably need to use the sp_attach_db system procedure to attach the database.

EXEC sp_attach_db @dbname='YourDatabase',
        @filename1='D:\Path\To\Your\Database.mdf',
        @filename2='D:\Path\To\Your\Log.ldf'

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog