Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Is there a way.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-01-09 : 08:25:05
Chris writes "Does SQL need to have the server running in order to access the database? I uploaded the two files, AZWD.MDF and AZWD.LDF to a root directory in a website. Is there a way to connect to them without them having to be in a directory: C:\Program Files\Microsoft SQL Server\MSSQL\Data?

Thanks,

Chris"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-09 : 08:55:20
Instead of copying those file, did you try Restoring the database
Also look for sp_attach_db in SQL Server help file BOL

Also refer these
http://sqlteam.com/forums/topic.asp?TOPIC_ID=59414
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Norwich
Posting Yak Master

158 Posts

Posted - 2006-01-10 : 01:05:22
The database engine of the instance has to be running for you to acces the contents of the Server.
The MDF and LDF don't have to be in the "C:\Program Files\..." folder they can be anywhere but they must be attached to that instance.
quote:
Also look for sp_attach_db in SQL Server help file BOL



BOL is always a good place to start...

Regards
N

If you want your computer to be faster then throw it out of the window.
Go to Top of Page
   

- Advertisement -