... 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 ...
... path and output path
Change the location of the backup folders as per your requirement
... 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 ...
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 ...
... myself as I need to take full backup along with transaction log backup using single job and I found ... hourly basis.
Thanks, Nitin Gupta (SQL DBA - 2000/2005/2008)