Books Online?

Excluding any transactions that were uncommitted at the end of the backup. (They'll be included in the backup file, but will be rolled back during the restore)

You need to decide what you want to audit. There's no automatic way to do it.

If you want to see all queries executed, that means some form of profiler trace....

Can you post code?

There are a number of constructs within functions that look good and perform terribly. As an example, if you have a scalar udf (user-defined function) that reads...

Have a look at the PIVOT keyword in SQL 2005. It may help with what you're trying to do.

Then what you're trying to do is impossible with backups.

To allow the users to write, the last backups needs to be restored with recovery. That means to apply any more...

Have a look at this:

http://www.sqlskills.com/blogs/paul/2008/01/31/MoreOnHowMuchTransactionLogAFullBackupIncludes.aspx

They did some collisions, but...

Depends what you need the secondary to be doing. Read-only or read-write?

If you can consider an upgrade to 2005, you could use database mirroring with a snapshot on the mirror...

There's not really anything like that, because all of the operators have their places and times when they are optimal.

You could read through Grant Fitchley's book on exec plans. Last...

Because sometimes the SQL Service needs to be able to access resources other than on the local machine. Other SQL Servers, other database servers, file shares, etc.

If you make local...

You can apply the diff with NORECOVERY/STANDBY as well, but it means that the DB will either be completely inaccessible (norecovery) or readonly (standby)

If you want to bring the DB...

mattjk (9/10/2008)

---

Bah, I see you get a mention by name for finding the other places sa is hard-coded, but what do I get for the bug report, diagnosis and work-around......

Are you perhaps trying to restore a 2005 database to SQL 2000?

Unless you have some form of auditing already in place, you won't be able to see what happened. The error log just stored details of errors and informational messages.