That sounds somewhat difficult, is there a script out there that would give me a good basis?

-Kyle

D:\MSSQL\MSSQL.1\Scripts\Test1.sql

D:\MSSQL\MSSQL.1\Scripts\Test2.sql

I keep getting the error Incorrect syntax near 'i'. The label 'D' has already been declared. Label names must be unique within a query batch or stored procedure.

Thank you very much.

-Kyle

Dave, I am still getting the incorrect size when compared to the actual database properties. Is there a reason for this difference or is there a way to correct...

Thank you so much.

-Kyle

Would the registry location be findable with regedit? If not, how did you find where the registry location was?

-Kyle

What does this mean when unknown is queried?

-Kyle

Thanks for your quick response, I am looking for reasons for or against it and that seems like a pretty good reason against TSM.

I'll look into HyperBac, hopefully I can schedule a demo for my company.

-Kyle

Both of the SQLSERVER* work under a domain account. However, Microsoft Shadow copy Provider is running under Local System, could that be what is causing the error?

-Kyle

Is there some sort of script I use to figure this out?

-Kyle

Is that needed for TSM or any other critical functions? Also...

Around that time there are multiple failed logins for "Login failed for user 'NT AUTHORITY\SYSTEM'.". I remove the...

Thank you much.

-Kyle

Beautiful, the script works great. The final one looks like this...

DECLARE DBName_Cursor CURSOR FOR

select name

from master.dbo.sysdatabases

where name not in ('mssecurity','tempdb','master','model','msdb') and databasepropertyex(name,'Status') = 'ONLINE'

Order by name

The only change being...