Jeff - I think your mistaken. Isn't it one of those new reality shows? :laugh:

I've started at a new company (We do NOT have Spotlight) but I'll bet the boys at my last employer would be interested in the fix. If they spring for...

w.johnson is absolutely correct. I found this out when my log backups started failing and I received emails telling me that the database was not in "Full" mode. Took awhile...

Some seemingly simple advice (although not useful for you right now): Do AT LEAST a weekly full backup up of your dev/test environments, more often if there are a lot...

My fault. I need to pay more attention to the forum I'm in!:blush:

I copy/pasted this directly into QA (SQL2000 sp3) and it will not compile. Errors as follows:

Server: Msg 170, Level 15, State 1, Procedure sp_who5, Line 38

Line 38: Incorrect syntax near...

Karl is absolutely correct. The compression size and speed of the backup (and restores) using third-party tools can be huge. We had a 250Gb database that compressed to around 32Gb...

I am in a similar position, at a new company, and we are attempting to consolidate servers. I have identified that (from asking) 3 databases on a particular server are...

I've used Lightspeed for years and recently SqlSafe (due to overall costs). Both worked well for compression and SQLSafe for encryption (didn't use that feature in Lightspeed). Backup and restore...

Gary, found this in another post. It describes the best ways to post questions/issues that you may be having. It's a good read and lays out what people need to...

Didn't think about the hardware side of this but you may be right. It's a new virtual server and late yesterday I was told by infrastructure that they were having...

Ran it when I got to work today, prior to doing anything to the indexes. Still no error. Also did a checktable, nothing. I did a DBCC DBREINDEX on the...

It's all bundled into one maintenance plan. The CheckDB for this particular database ran at 12:00:59am until 12:03:26am, reporting zero errors. The index build ran at 01:03:22am and failed at...

Actually, about a dozen databases on one server have the same logical name. I had never messed with the names before, always accepting the defaults on create. And I was...

jbarkan - Just a suggestion - You've changed your topic focus. You may want to post your new request in a different forum, with an apporpriate topic heading as this...