Disk IO? How they confirm this. Do they have any IO related error in event log ? .

select * from sys.dm_io_virtual_file_stats (Null,null)

Run the query to see any IO stalls...

Not sure we can achive this. Better name your temptable with SPIDs.

sys.dm_db_session_space_usage will give you some details about temp tables' usage.

anthony.green (2/14/2013)

---

Highly risky move, should be backing up to individual files not one big file, as should anything happen to that 1 file you cannot restore to any of the...

Saber_Talas,

Snapshot is available in Enterprise edition only. If You have it, you can go ahead with snapshot.

Log shipping (with Standby mode) will you give more convenience than snapshot....

Sync will take time depending on the number of transactions to be replayed in mirror database, network latency between principal/mirror and disk latency in mirror server.

Monitor it for some...

Rebuild index should be done on Fragementation level not on day basis.

Better check fragmentation level daily and go rebuid/reorganize according to fragementation %.. You can get good script in...

Have a look at this.

http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418

DELETE WITH (TABLOCK) will immediatly release space to database. If you want it to OS, then you need to shrink the database/file.

If your backup is good, you should be able to restore them. Post the error you got while restore.

First try to restore master database.

Look at this url.

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

Can't believe Backup operation will block insert process. It could be other issue.

???

Mirrored server seems running out of memory which could force it to be unavailable to principal.

As per...

Mirrored server might be inaccessbile at that time. It could be network or some other issue in partner.You need to check your mirrord server's error log and event viewer as...

WangcChiKaBastar (12/26/2012)

---

when I run the proc tomorrow it again takes forever to complete...and the applications time out on the front end...

to resolve the time out I have to manually go...

Is it due to planned activity or because of any errors?. If not planned activity, you need to check sql log for more information which caused suspended mirroring sessions.

Did you...