Viewing 15 posts - 3,766 through 3,780 (of 4,745 total)
do litespeed or sql backup provide a complete logshipping solution, or do you have to write your own?
April 3, 2009 at 3:08 am
unless the large inserts are one transaction more frequent backups will reduce the size of the transaction log backups
another alternative is to set up an alert so that the log...
April 2, 2009 at 4:11 pm
fn_virtualfilestats is cumulative since the last SQL restart
April 2, 2009 at 6:52 am
net is an Os command like cd or dir. So will run from any directory location
have you tried putting the commands in a.bat file with replies to prompts and running...
March 31, 2009 at 3:44 pm
net stop and net start?
March 31, 2009 at 2:39 pm
we go for 'sa' here as well unless an application requires something else, but, see this thread....
http://www.sqlservercentral.com/Forums/Topic455325-146-1.aspx
March 31, 2009 at 10:08 am
steve jones maintains a build list on this site:
http://www.sqlservercentral.com/articles/Administration/2960/
or do a search on 'build' in the search bar top right
March 31, 2009 at 3:22 am
IMHO, no you don't. Your current version equates to CU9 for SP2, this was the last CU contained in SP3. If you had been at CU10 or 11 you would...
March 30, 2009 at 1:52 pm
yes it will. The database will be as it was when the backup was taken. If you have tran log backups as well you can roll it up to just...
March 30, 2009 at 10:54 am
tosscrosby (3/30/2009)
george sibbald (3/28/2009)
Hi.............
and then awaits my reply.
I know they just want me to do something for...
March 30, 2009 at 6:40 am
people who send me messages on the companies internal instant messenger system that say:
Hi.............
and then awaits my reply.
I know they just want me to do something for them. I have...
March 28, 2009 at 12:02 pm
its probably got loads of data to move so could easily take that long, probably caused blocks, been blocked as well.
You can kill a shrink job, the work it has...
March 26, 2009 at 10:52 am
Cheers for the input everybody, appreciate it
It's sad that SQL still requires a C drive for some things.
and in 2008 the resource database goes on the C as well I...
March 26, 2009 at 10:15 am
Steve Jones - Editor (3/25/2009)
What is on the C drive you're worried about? Should be a base instance, which should be minimal to recover for you.
cheers for the insight steve.
Its...
March 26, 2009 at 8:04 am
Michael Valentine Jones (3/25/2009)
george sibbald (3/25/2009)
...Michael, I like the boot from SAN idea, do you do that?. Our intel guys don't seem keen, saying there are performance problems. Seems to...
March 26, 2009 at 7:53 am
Viewing 15 posts - 3,766 through 3,780 (of 4,745 total)