Don't listen to anyone who is not a DBA about database backups. They won't be responsible for recovery, you will. I would agree the tools you should be wary of...

personally I would not leave applying service packs up to wsus. What about closing down apps before the install and backing up the system databases so you have a backout?

As...

cheers for posting that.

post the actual error from the SQL error log when login fails, we need the state value. This could be something like incorrect default database if userid is not orphaned.

see

http://msdn.microsoft.com/en-us/library/ms151799.aspx

would not surprise me if replication latency is higher on a mirrored database.

remember if you do this any updates done in DR will be carried back to the live site, so be sure that is what you want to happen.

there is a configuration option in SQL for network packet size, this has a maximum of 32K.

change this at your peril. I did once and it broke part of an...

User is most likely orphaned from its login

run this command in the database

sp_change_users_login 'report'

if the appsa user is listed in the results set run this

sp_change_users_login 'update_one','appsa','appsa'

I don't know of any flag but the system databases always have the same name so you could use that to identify them (master,model,msdb,tempdb,distribution). anything else is a user database.

You can change it if it is not already in mixed mode. just select mixed mode in SSMS property window, OK out of it, and restart SQL (don't forget to...

sounds like a good case for the 'queryout' option in the command line utility BCP. If it is a lot of data it will be faster than SSIS.

cjgilson (10/22/2009)

---

We don't have Cursor Close on Commit enabled on the DB in question. What effect would that have (other than what can be guessed from reading the name...

This query will tell you when stats were last updated for a table:

select 'index name' = i.name,

'stats date' = stats_date(i.id,i.indid)

from sysobjects o, sysindexes i

where o.name = 'g_batch_audit' and o.id =...

are the stats up to date? indexes fragmented.?do the queries return the same amount of data?

check to see if the query plans are the same on the two databases.

If you can get the differential backup taken, copied and restored in a time that gives an acceptable outage, stick with it. If you want to reduce outage even more,...