July 24, 2008 at 12:39 pm
We administer over twenty sql servers, and I need to get a management report which we tell me what backups failures have occurred on these servers. I have a piece of T-sql script which allows me to query the master database on one server, but as I need it for twenty, my plan is to create an SSIS package that uploads the information into one database. However I am a bit concerned that querying the master databases on these servers Through SSIS could corrupt the master database (although we do have backups). Has anyone got a view on this ? Urgent replies on this would be great as I have to start work on this asap.
July 24, 2008 at 2:43 pm
I don't see how querying it would hurt anything as long as you don't try to change data in it.
The Redneck DBA
July 24, 2008 at 3:28 pm
Queries against master have no impact on the server other than using resources to execute the query. There is not reason this should corrupt anything.
July 24, 2008 at 7:26 pm
Not only you won't cause any harm by querying master you can't change system tables directly.
* Noel
July 28, 2008 at 6:32 am
on SQL2005 queries that try to update the system catalogs will be rejected anyway 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 6:41 am
if you want to ascertain which backups have failed why are you querying the master database, surely you want to query msdb anyway. (you won't harm that either)
---------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply