Viewing 15 posts - 14,521 through 14,535 (of 39,936 total)
Grant Fritchey (1/17/2012)
Jeff Moden (1/17/2012)
Grant Fritchey (1/17/2012)
The thing is, some questions lend themselves to that...
January 18, 2012 at 8:51 am
S Hodkinson (1/18/2012)
Now that I am 'semi-retired', I still read the editorials every day and trawl through the forums. Am I sad or just keeping the brain going?
Hopefully I...
January 18, 2012 at 8:48 am
Jack Corbett (1/18/2012)
January 18, 2012 at 8:46 am
Jason is right here. I was asking for clarification to understand if you were talking logs or data.
You should never shrink data files as part of regular maintenance. Ever. It's...
January 17, 2012 at 4:10 pm
OK, I'm confused.
The TRUNCATE ONLY is for the backup of the log, correct?
Do you have a 300GB data file, or database? Are you shrinking the data file somehow?...
January 17, 2012 at 3:12 pm
yes
January 17, 2012 at 3:09 pm
Have you tried something like this to be sure of the contents:
http://www.sqlservercentral.com/scripts/Miscellaneous/30852/
Are you sure the file is growing? Meaning have you detected auto grows, or monitored the actual file size?...
January 17, 2012 at 1:39 pm
P-V, physical to virtual migration. Essentially snapshot the Windows OS as a point in time and recreate as a virtual machine. You can leave the physical, and bring up the...
January 17, 2012 at 1:01 pm
I'd change the db owners to a new account, since it shouldn't affect anything if you make the change. Use "sa" or another real account.
For the other stuff, I...
January 17, 2012 at 12:01 pm
Viewing 15 posts - 14,521 through 14,535 (of 39,936 total)