Here is an handy script which give the details of the list of backup(s) taken of a database and the sequence it was taken.
DECLARE @db_name VARCHAR(100) SELECT @db_name = '<DB Name>' SELECT BS.server_name AS [Server Name] ,BS.database_name AS [Database Name] ,BS.recovery_model AS [Recovery Model] ,BMF.physical_device_name [Location] ,(CAST(BS.backup_size / 1000000 AS INT)) AS [Size of Backup (MB)] ,CASE BS.[type] WHEN 'D' THEN 'Full' WHEN 'I' THEN 'Differential' WHEN 'L' THEN 'Transaction Log' END AS [Type of Backup] ,BS.backup_start_date AS [Backup Date] ,BS.first_lsn AS [First LSN] ,BS.last_lsn AS [Last LSN] FROM msdb.dbo.backupset BS INNER JOIN msdb.dbo.backupmediafamily BMF ON BS.media_set_id = BMF.media_set_id WHERE BS.database_name = @db_name ORDER BY backup_start_date DESC , backup_finish_date
Download the script from https://gallery.technet.microsoft.com/T-SQL-script-to-get-Backup-5a9b029b?redir=0
8 comments:
Hello, I work in Engre.co and we often need to make data backups for clients, when I make a data backup I follow this sequence
To properly make a backup with subsequent recovery you need:
1) make a backup in the opencard admin
2) save all opencard files from the server folder
3) to make dump of base mySQL (it is better through update)
To restore:
1) restore the mySQL database from the dump
2) copy all opencard files to the server folder
3) restore the backup from the opencard admin
4) just in case after recovery from the admin to restore the mySQL database from the dump again
The T-SQL script retrieves backup details of a database and the sequence in which backups were taken. Explore how writers at a law essay writing service discuss the importance of backup strategies and their impact on data management.
La bougie parfumée à la fleur d'oranger emplit l'espace d'un parfum subtilement floral. Elle est idéale pour les soirées relaxantes, créant une christina a partagé bougie parfumée fleur d’oranger avec vous ambiance chaleureuse et sereine, parfaite pour se détendre après une longue journée.
Boat removal services like these are a life-saver! The team was professional, courteous, and handled the job quickly. They took care of all the details, so I didn't have to get rid of boat worry about anything. If you need reliable boat removal services, you can trust this company to get the job done right.
Luxury golf courses are where sport meets serenity. Playing amidst lush fairways and breathtaking vistas is a fantastic way to combine your love of golf with a golf holiday activities relaxing, peaceful environment that allows you to recharge and appreciate the beauty around you.
The messages are perfectly balanced motivational, informative, and to good morning text for him the point. They’ve helped me stay organized and productive, and I look forward to them each day!
Post a Comment