are we talking 1 instance of sql server??

what are min and max memory set to on instance properties?

on SQL2005 queries that try to update the system catalogs will be rejected anyway 😉

if your using win 2003 enterprise it should address all the RAM straight off without editing the boot.ini

alimcitp (7/28/2008)

---

Gilla Monster, I dont know why you are trying to change the subject of my post. Actually what I requested is that " IF SOME ONE CAN LOOK AND...

ensure you configure the "lock pages in memory" local security policy for the account SQL runs under. Generally its not recommended to use the /3GB switch for machines with 16GB...

just found the MS kb article, it seems 32 bit SQL2005 std can lock pages its just the 64bit that is an issue

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...