Either ask (and hope for correct answers) or investigate yourself:

1) Backup strategy - full, logs, differentials - are they working and have they been tested?

2) Does backup strategy fit user...

I totally agree with Grant and Steve. I restore to a full test environment, log in using the various apps and do a general look around. About twice a year,...

Indexes are good, checked that when all this started (and since). It's amazing, when I run the original, it starts locking/blocking like crazy but when I run the copy of...

Not sure what you mean by "copy of the "good" plan", the script of the proc? If so, I have backups and a good copy of the database (from 4/22)...

I've used it for years as well, without issue. I do check the accuracy of my backups from time to time, just to be sure. I've heard all the stories...

Microsoft has this script as a recommendation for transferring logins:

----- Begin Script, Create sp_help_revlogin procedure -----

USE master

GO

IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL

DROP PROCEDURE sp_hexadecimal

GO

CREATE PROCEDURE sp_hexadecimal

...

Personally, if I am modifying a production database, I ALWAYS take a full backup prior to the execution of the scripts. What is the rational to "I dont want to...

What do you mean that recovering the backups failed miserably? What errors are you receiving or issues are you facing? I agree, I haven't used 6.5 in years but I...

See BOL for great examples, but.....

This will create a local temp table for you:

Select * into #newtables from tablename

That's what I'm thinking too. For months we had a MP running flawlessly, until someone changed the recovery option of a DB from full to simple. All the other DBs...

What does it say in the error log? What recovery mode does this database have (if simple, you cannot backup logs)? What does "and we found that it is because...

Maybe it's in his permanently deleted email and he can't remember how to retrieve it??

It may not simply be disk space. It could also be rights to the share (did not know that!) if it says "error not found". I always looked at error...

Vivien, In S2K, if you right-click on the database from EM, select all tasks, select generate scripts then on the option tab, you can script the db, the database options,...

ahutchens, I believe you are right! - except it says "Date Last Used" under Add/Remove Programs , which I know is the install date of the sp and hotfix (we...