Yes, please..

I have created a text file with list of servers (I am using powershell for the same list).

I could see only single column in result set, converted to CSV...

Thanks for your fast response and help.

I used the PS script and ran today. I received only a single column results with numbers. Might be I missed something.

Is there any...

Just a try..

connect using : instancename,XXXX (1433, port number)

Restore latest Full backup first and Transaction Log backup with RESTORE WITH NORECOVERY option (db should be in restoring mode).

Then, start configuring DB Mirroring again.

Hope this helps..!

check > DBCC SHOWCONTIG

And also check if any applications are accessing the tables, any transactions running.

And I would suggest maintenance activities should be done in non peak hours...

Third party tool, NetBackup client etc..

Thanks Patrick for your time.

Adding 800+ servers to "Central Management Servers" is a big problem and in manual.

Any automation for this to register.

yes we are using Powershell already for all the machines.

But I am to trying to get this done by SQL Queries.

Is there any way to add all the servers to...

I think we should check 'Setup Bootstrap' folder with the KB article number for SP install.

EXAMPLE:

'C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Update Cache\KB2674319\ServicePack\x64\

Appreciate if anyone can help.

---- ONe more add on.

I have SQL 2000, 2005, 2008, R2 & 2012 in place, of 800+ servers.

Restore full, then differential. Thats enough to have as per your backups.

Perfect.

Thanks

Hope it helps...

--- Executable scripts to change table owner

SELECT 'EXEC sp_changeobjectowner '''+ SCHEMA_NAME(schema_id) + '.' + OBJECT_NAME(object_Id) + ''', ''dbo'''FROM sys.tables

Results :

EXEC sp_changeobjectowner 'dbo.Transactions_Entry', 'dbo'

EXEC sp_changeobjectowner 'dbo.Transactions_Login', 'dbo'

EXEC sp_changeobjectowner 'dbo.Transactions_Entry_0222',...

any help is appreciated..

the below script gives report to only one machine twice when it is ran through VM.

List of servers are not getting used for checking.

why script not trying...

Found something, but only for one and it is also not accurate.. Any help is appreciated.

$servers=get-content "D:\instances.txt"

foreach($server in $servers)

{ get-wmiobject win32_service -computername $server |

select name,state |...