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.
| Author |
Topic |
|
abs
Starting Member
1 Post |
 Posted - 2005-11-03 : 18:29:26
|
| Hi guys,i am new to the forum. i got sql server 2000 and i wanted to install it on my home pc. i am able to do that.But when i create a database out of it and then take it out of the SQl folder and put it in some other folder in my C: drive and then if i try to link it to my program it gives me a error stating that it is not accessible. MY QUESTION : Am i doing something wrong ? Do i have to set some properties on the database i create?if yes how to do it?Plz replyThanks |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-03 : 21:45:31
|
| You can't just move the database file. You have to detach the database, move the file, then reattach the database. Look up attach database and detach database in Books Online. It's included free with SQL Server. If you go to Program Files, All Programs, Microsoft SQL Server, there's a link to Books Online. Go to the index tab when you open it and explore.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Installation