... sp by inserting correct path insteat of (Backup Path)
2. Create a new job ...
... some useful details like:-
1. backed up page count
2. compression ratio ... KB/sec
4. Device where the backup was taken.
... N'c:\work\data',--folder for store backup file
@onlyFUllbakup = N'N',
@ServerName = N'ServerA',--for server which backup file come from, it is for step 3 ...
... know wich databases have not been backed up within the last X days. You ... wich databases have never been backed up.
You must run like:
EXEC msdb.dbo.get_backup_info -X
where X are the days ...
... path and output path
Change the location of the backup folders as per your requirement
Copy the script in SSMS to any of the SQL Servers
Use the results based ...
Execute the entire script using SQL Server Management Studio.
Do not remove ...
procedure will check the last full backups and report databases that have not been backed in a certain amount of days.
The prodedure will also ... also report on databases that have not been backed up at all.
Please feel free to make ...
DBA's often monitor Backups, Replication e.t.c manually or through some ... sp_TestLinkedServer) to test linked servers in SQL 2005 will say pass even the Access ... you to monitor Linked servers from SQL 2000 and i have posted another SQL 2005 version of this script.
Also fine ...