yes it is

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

BTW, if you are in high safety mode the mirroring is synchronous.

then as this is a one-off task you may as well keep it simple and use windows explorer to move the files.

don't use a cursor, use dynamic SQL to create your commands as shown above

Are all the files moving from the same place to the same new location? If not how...

I think you have found your problem, blkby does mean 'blocked by', your backup is waiting for the other one to complete. Only one full db backup can run at...

suspended means at the time you ran sp_who2 the query was waiting on some resource, not necessarily a problem unless it continues to wait.

To see what it is waiting on...

Run that script via SSMS and see what the result is.

When you run it via your package run a sp_who2 to see whats going on with the backup task.

Fragmentation will...

post the spec of your server.

you already seem to know which processes are causing the high cpu, so investigate the SQL behind them, and check out the health of the...

Is that data and log? Is the log on the same drive? This might be a case where you can shrink the log down to the maximum size it actually...

If you leave auto create statistics on for the database these will be re-created over time. If you believe you require some of them urgently to maintain performance you could...

SPIDS <= 50 are reserved

this seems like a good place to thank paul and steve for doing this....

yea, I got my name back!

😀

Hey Paul, I heard from steve, the wheels are in motion. Thanks a lot mate 😀

dreamthebest (11/13/2009)

---

Isn't there any way to create DDL triggers in system databases.

The idea of changing the default database is good but there are lots of logins and it...

If you go for the alter database..modify file method, (which I recommend) you will need to offline the database first and bring it back online once you have moved the...