Thanks Koen Verbeeck, i am just having a bad day in the office.

The SCCM guys here don't even want to participate in helping out the brother.

SCCM is system center configuration manager, it's a MS product for remote software installation.

It keeps record of all systems with registered software. it's database resides on SQL Server but now...

Third party tools are not an option because of Company policies.

hi,

Thanks for the help, but now how do you create multiple intance connection or multiple datasources. Anyone with a script to do that?

hi,

Thanks for the help, but now how do you create multiple intance connection?

Hi,

i need the same script for multiple restore verifyonly. Isnt there a script for this?

Hi,

This was a very useful script and i intend to run it on weekend.

thanks a lot.

hi,

i am currently trying to get a script which will do that for multiple databases.

My thoughts exactly, Why i was asking this is because im in a new company and most of the Maintanace task have been setup in a very questionable way.

Thanks for...

OK, LET'S exclude db backup and only ral about the rest, butstill which one comes first between DBCC CheckDb and Reindexing?

Thanks,

very helpful.

restore headeronly is a very informative script.

Thanks again.

Hi,

I had to restore an old backup in order to overcome this.

So if you have the same situation, that's pretty it. You need to restore an old backup and run...

Hi,

Is does anyone have a clue what couyld cause this?

I have a similar situation and i cannot find the meaning of error code 50000..

[SQLSTATE 42000] (Error 50000).

Replication would do for you.

yes