In my case I'd just search for any backup set that didn't have CommVault Galaxy% in the backupset_name column and possibly which weren't using a device_type code of 7. So you have to determine with your backup solution which columns tell you when something is being run outside you backup solution. ORDER BY _start_date DESC Ī result set for when using Commvault as your backup solution could look like this: WHEN _type = 105 THEN 'A permanent backup device'ĮLSE 'Unknown backup device code:' + CAST(_type AS VARCHAR(3)) + '!' If you are planning to use OpenRowset queries in order to connet to remote database servers or if you have already implemented OpenRowset queries as a solution to remote connections as an alternative tp linked servers in Microsoft SQL Server 2005, you should first configure the database instance to enable Ad Hoc. You can achieve this with something like this: SELECT How to enable the use of 'Ad Hoc Distributed Queries' by using spconfigure. First you want to retrieve the normal information from your backup history on the relevant SQL Server instance, to find out what you normal backup file location looks like.
0 kommentar(er)
