Below is the script to get information about the each type of the successful backups for each databases.
USEmsdbSELECTname, user_name, first_lsn, last_lsn, database_backup_lsn,backup_start_date, backup_finish_date, type, database_name,server_name, machine_name, compressed_backup_sizeFROMbackupset
SQL Table Row Count
There are couple ways to count row of a...
Read more»
SQL Server Version From Backup File
We can easily find out the database...
Read more»- SQL Database Backup History
Below is the script to get information...
Read more» - SQL Server TRUNCATE TABLE
We can use the TRUNCATE TABLE statement...
Read more» - SQL Check Database Replication Status
A database can not be dropped if there...
Read more»
No comments:
Post a Comment