How to add a SQL database to sql server

[balajee]

Hi<br><br>Hi <br>I added a new table to the sample database &quot;northwind&quot; and later I did something wrong and I had to reinstall SQL Server 7.0 again. But then my modified &quot;northwind&quot; was overwitten with the original sample database. I had copied the modified &quot;northwind&quot; in other directory. Now how do I add this to the SQL Server. When I try to just copy and paste I am denied. I tried renaming it and then pasted it in the subdirectory &quot;data&quot; but when I open Enterprise Manager I do not see it under databases tab. How do add an existing SQL database to the server?<br><br>Can somebody help me?<br><br>Thanks

 

[phoward]

Copy the backup file to the MSSQL7 &gt; BACKUP folder.&nbsp;&nbsp;Start Enterprise Manager, select your server from the Sql Server Group.&nbsp;&nbsp;<br><br>To restore database, right click onto the Databases folder icon and choose All Tasks &gt; Restore Database.&nbsp;&nbsp;Type in the name of your database, and choose to restore from device.&nbsp;&nbsp;Click on select devices, Add and the … box to browse.&nbsp;&nbsp;Select your database file and ok, ok again, and ok once more.&nbsp;&nbsp;Under the options tab, click onto “Force restore over existing database.&nbsp;&nbsp;Make sure that the Move to physical file name is listed as c:\whatever.&nbsp;&nbsp;Mine always comes up as d:\whatever.<br><br>Clck onto Ok and stand back.<br><br><br>