to specify locations for user databases go into SSMS and right click the registered\connected SQL instance and select properties.

Under database settings you specify the default folder for data files and...

this is the MS description

http://technet2.microsoft.com/windowsserver/en/library/e72dcdf6-fe17-49dd-a382-02baad31a1371033.mspx?mfr=true

this explains it too

http://technet.microsoft.com/en-us/library/ms190730.aspx

basically without it set memory can be paged to disk which will cause huge problems for the running SQL instance. Its important to...

clustering is a windows server feature and not windows xp. However, using Microsoft VirtualServer you can on a laptop that is powerful enough set up a virtual 2 node MSCS...

using terminal services in application mode would ideal for remote users, the processing is all done on the terminal server which would be on the same LAN as the database....

Jason Shadonix (7/23/2008)

---

Interesting. I get the following message when I run that:

Msg 3101, Level 16, State 1, Line 2

Exclusive access could not be obtained because the database is in...

sorry my bad!!

restore database DBNAME with recovery

re run the SQL installer it should pick up any instances already on the pc, then run repair

when the database is in the restoring state try the following command and see if the database comes back online

alter database mydata with recovery

no need to shutdown sql instance,

just set the database offline. Once this is done you can then move the disk file.

After you copied the file to its new...

Max Databases per instance of SQL Server = 32,767

what are the preceding errors?

open up the plan and double check it

you do need to assign the user account sql runs as to the local policy "lock pages in memory"

how much RAM does the server have?

did you format using the 64k switch?

was it successful?

your welcome m8tey