Now that you have moved data out and have free space within the database, do you actually need to shrink the file?

If you do, try 'truncateonly' first, see if...

dev_maniac (3/7/2011)

---

George, it's 64 bit, only running SQL Server, nothing in the error log about memory. I set the min memory at 21504 MB, and the max at 29696....

Jeff Moden (3/6/2011)

---

Derrick Smith (11/15/2010)

---

All service packs for microsoft products are cumulative - you only need to install the latest one.

That said...Isn't SP4 still in CTP? I wouldn't use that...

SQL Server Configuration manager --> SQL Server services --> SQL server browser --> right click --> properties --> service tab --> start mode --> change to manual or automatic

Lots of factors could be in play here.

Is this 32bit or 64bit? What did you change min and max memory to? Anything else on the server?

If everything is set up...

I think the answer is in your question.

the service has been disabled, it needs to be set to manual or automatic before you can start it. Check under properties.

thanks for the interest guys and sorry i have not come back but it has a madhouse here (I should be working now rather than replying to this :-)).

The databases...

the data directory is where the system databases will be installed, On that tab you also specify the default USER database directories and backup directory.

when you enter your location into...

server cannot connect to domain server to verify the windows login.

Plug the cable back in! 😀

nice article Perry and very useful info.

I think the lesson to take away though is to set your live and failover servers up with exactly the same drive\directory structures in...

MS say they are not fully tested so don't give a cast iron guarantee and say not to install if you don't need to. Thats good enough for me. Whos...

in the CUs themselves MS say only apply if you have experienced one of the problems it resolves, so thats the rule to follow.

Just to add to the reassurance this is perfectly normally behavior and I have seen it many times, especially if the application runs as a service.

Sql is just not ready...

nope.

what you are hoping for cannot be done, whichever way you cut it.

slight problem, what you describe is exactly the same as logshipping. As soon as you bring the database online (with recovery option) you won't be able to restore any more...