Viewing 15 posts - 1,891 through 1,905 (of 4,745 total)
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...
March 9, 2011 at 3:04 pm
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....
March 7, 2011 at 12:56 pm
Jeff Moden (3/6/2011)
Derrick Smith (11/15/2010)
That said...Isn't SP4 still in CTP? I wouldn't use that...
March 6, 2011 at 5:45 am
SQL Server Configuration manager --> SQL Server services --> SQL server browser --> right click --> properties --> service tab --> start mode --> change to manual or automatic
March 5, 2011 at 10:58 am
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...
March 5, 2011 at 10:37 am
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.
March 3, 2011 at 4:30 pm
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...
March 3, 2011 at 5:38 am
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...
March 1, 2011 at 11:42 am
server cannot connect to domain server to verify the windows login.
Plug the cable back in! 😀
March 1, 2011 at 11:21 am
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...
March 1, 2011 at 11:06 am
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...
March 1, 2011 at 10:53 am
in the CUs themselves MS say only apply if you have experienced one of the problems it resolves, so thats the rule to follow.
March 1, 2011 at 6:45 am
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...
February 28, 2011 at 4:00 pm
nope.
what you are hoping for cannot be done, whichever way you cut it.
February 22, 2011 at 3:47 pm
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...
February 22, 2011 at 2:51 pm
Viewing 15 posts - 1,891 through 1,905 (of 4,745 total)