February 15, 2006 at 3:52 pm
Ok I have to reinstall SQL Server on one of my servers and I am trying to open an existing Database file. and it won't let me.
February 15, 2006 at 4:13 pm
Hello John,
Can you elaborate your scenario?
Lucky
February 15, 2006 at 4:17 pm
i saved my database files and logs and then reinstalled SQL Server on a different drive still on the same server and put the files back in the data folder but enterprise manager don't find them and they don't show up in the databse folder on enterprise manager
February 15, 2006 at 4:31 pm
When you saved your files, what do you mean by saved?
My guess is you have to re attache the mdf, and ldf files.
use enterprise manager to attach, or use sp_attach in query analyzer
February 15, 2006 at 4:57 pm
do you know what top put after the @ statement before the = ?
February 15, 2006 at 5:11 pm
If I wanted to attach a database name Chicken what would be the statement
sp_attach_db @Chicken = N' <Chicken, Server Name, Chicken Data>,
@Chicken_Data = N'<Chicken_Data, nvarchar (260), Path Name
thats what i have now but its not working it says Chicken is not a parameter for procedure sp_attach_db.
February 15, 2006 at 5:20 pm
Refer to BOl for sp_attach_db syntax..
http://msdn2.microsoft.com/en-us/library/ms179877.aspx
-Krishnan
February 15, 2006 at 7:14 pm
Here is an example of the sp_attach_db syntax from the SQL BOL.
EXEC sp_attach_db @dbname = N'pubs', @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'February 15, 2006 at 9:43 pm
Thanks everyone i got it
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply