its the problem of disk configuration in cluster.

Add your failover sql instance as possible owner for the the required disk drives.

As long your table not filling much pages in database and stats are up-to-date, there shouldnt be major performance issues. Also performance not depepnds on only these factors. There...

not too sure but two tihngs in my mind which might help,

1) go to option--add-in/Macros Security in SSIS project window.

2) go to component services--dcom config--open properties window of msdtsserver/msdtsserver100--security...

I think this becomes bit difficult if we have 100 instances or more 🙂 ..

Thank You,

Best...

The easiest way for me is, go to...

why not change the schema of the table to the one which you want.

If your table T1 is bound with schema S1 and table T2 with S2, then even after...

you said they will not be sending any more full backup so does that mean you have restored the database in norecovery/standby mode. Without this you will not be able...

try linked server with your excel file. After then you can query your excel linked server like database objects. Store the record from excel to temp table and then do...

As much I am aware about denali, you cant upgrade sql 2000 database to denali directly. You...

this is definitely not the well designed requirement. As you mentioned the database size and numbers, you definitely need a spacious lab to host these report database.

Having said that, I...

as mentioned earlier, the database is gone. Look for some backup if they have, if not then they can learn from this disaster.

with LogShipping, you cant write to database.

So the report is required from all database or some specific database? How big are the reporting database?

use print command for your sql query which will print the query with result.

In addition to what Jim said, configure datafile autogrowth in MB and logfile growth in %.

login to your bank account and see the functionality of reports there.