do litespeed or sql backup provide a complete logshipping solution, or do you have to write your own?

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...

fn_virtualfilestats is cumulative since the last SQL restart

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...

net stop and net start?

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

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

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...

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...

tosscrosby (3/30/2009)

---

george sibbald (3/28/2009)

---

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...

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...

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...

Cheers for the input everybody, appreciate it

and in 2008 the resource database goes on the C as well I...

cheers for the insight steve.

Its...

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...