SORT_IN_TEMPDB option will use tempdb while reindexing, due to this your tempdb will grow. Also reindexing may have blocking depending on the database activity. Other option is if fregmentation is...

Pl. find any other error in windows error log.

One more good question on new technology, did some research. Thanks!

It clearly mention about running multiple task like reindexing or shrinkfile. Try to find what exactly was running at that time for further investigation.

Limited SAN space could be culprit. However let us know the detail error message for further investigation.

What permission you do have on server/database?

You can run following command to find specific tables:

sp_helpindex...

Good One, Thanks!

You can generate the script for the required Stored procedures. Now you do have script ready for all required procedures. Create ALLPROC procedure which include all this code to create...

It is advisable to involve the storage guy to investigate further.

You can create the ISCSI drive on VM which shares the drive similar to SAN and proceed further. Also you can create two identical hardware for cluster and try always...

Interesting one. Thanks.

Great Eirikur, is it possible to send this OUTPUT to excel using this T-sql?

There are two ways you can achieve this.

1st Create a table(tblToBeDeleted) for records to be deleted. Insert the data into tblToBeDeleted and once insert is done you can delete...

Yes in realtime scenarios we can use P2P replication and usually used for production, marketing, sales etc. to keep the data upto date.

Refer following MS link for further detail...

http://technet.microsoft.com/en-us/library/ms151196.aspx

Yes, you can create a job for RESTORE to execute it on demand.