LiteSpeed is good, you could toggle different levels of compression, so to increase\decrease backup time and to decrease\increase space utilized for that.

try to apply logs thru QA, apply one before, proper one and the following tran log. And check for the messages appeared in the results pane. It should give...

Check (I think) HP site. They used to have free 8 hrs on-line class?!

I dont have scripts handy, it was over a year ago on a different job,

but can't you do smth like that: ( quick and dirty)

you go thru your list of...

Well,

So you could get whatever output you want from the perm table on you local server...

I would make them as linked servers, dump the output ( of sp_help)into temp table. Run everything in the loop, move the results of each iteration from temp table on...

It has been awhile, but backup took about 1.5hr on 1.3TB Database. Copy another few hours and restore a bit longer. Secondary server was not required right away, so once...

At my prior job, on the wknds we were running the following on Saturday night:

Stop Logshipping;

Set Recovery mode to Simple;

Reindex;

Update Stats for some indexes;

Flip Recovery mode to Full;

Backup;

Copy and Restore...

It happened to me few times few years ago. Dont remember exactly what I did, but the way I would start troubleshooting this: check SQL Error Log. Any particular issues...

How about getting into Sybase\Unix. At my current work ( where most of the servers are Sybase on Unix) I am 'forced' to learn Sybase\Unix at the expense of SS2005\SS2008....

Once in a while I used to get that because of huge IN Clause....

another way is to try to understand and answer interview questions, what will be your first steps when you come to work in morning...

Or:

Backup

LOG tempdb WITH NO_LOG

GO

DBCC

SHRINKFILE ('templog',TRUNCATEONLY)

GO...

To cmille19 : Did you have a chance to work with Idera SQL Diag? How would you compare them ?

DBA and LAN personel were involved in that, while LAN got adequate training, we, DBA` were not.

We were using that for replacing of Log Shipping,...