As long as you balance the resources between the instances - there shouldn't be any issues.

He ran a shrink on the database - that affected all tables...

Right-click on the database in Object Explorer - select Reports - Select Disk Usage report. If there are still records in the default trace then this report will show...

You will only see value in striping a backup when you have multiple drives available - and separate IO paths to those drives. Striping a backup to the same...

Total WAG...but I have seen things like this where the developers were informed (for whatever reason) that stored procedures require a parameter and therefore they built everything with a parameter...

This indicates that you have a problem with tempdb (database ID 2). This could be related to the SAN dropping the connection, or corruption on the LUN, or some...

You will...

SQL Server 2000 is no longer supported. Your best option is to upgrade to the latest version.

Note that to get there you will need to upgrade to 2008 first.

Michael Valentine Jones (5/8/2013)

---

select

DT,

SecondsSince_19000101 =

-- seconds for whole days as bigint

(datediff(dd,0,a.DT)*000000000086000)+

-- seconds since start of day

datediff(ss,dateadd(dd,datediff(dd,0,a.DT),0),a.DT)

from

( -- test data

select DT = getdate()union all

select DT = '99991231 23:59:59.997'union all

select DT =...

Michael Valentine Jones (5/6/2013)

---

That is the danger of having such a long string of differential backups. A full backup run anytime after the last full will break the string...

What is the version of the 2005 system? If is prior to SP2 with a hotfix you will have issues...

You also need to know what version of the client...

You need to also be aware that any explicit transactions - with explicit rollbacks will also roll back any of these messages that are being logged.

I would recommend the SSIS approach - simply for the fact that you can then control the batch and commit sizes on the OLE DB Destination (using the fast load...

I would verify with the client that they are not backing up to multiple files and that they are actually using native SQL backup. If they are not using...

Steve JP (4/29/2013)

---

When you attach a database file, if the log file cant be found then it will recreate a default sized log file at the correct location. I think...