Viewing 15 posts - 14,506 through 14,520 (of 39,919 total)
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
Interesting link, but that talks more about the organization and benefits. This guy was having trouble understanding the concept of the entire machine being emulated. If they can't get that...
January 17, 2012 at 10:31 am
Is this account the owner of the databases or is it mapped to "sa"?
The installation shouldn't matter. It's the access and perhaps ownership of this account. The SID should stay...
January 17, 2012 at 10:28 am
Viewing 15 posts - 14,506 through 14,520 (of 39,919 total)