... 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 ...
Scripts can be used to view the backup history from msdb
... 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 ...