How to know when, where, what and who about a database backup set on a backup file.

Problem: How to get information related to database Files, log files from a backup set. Solution: RESTORE FILELISTONLY (Transact-SQL) Sometimes we need to peek into the database backup and find the backup version of a consolidated backup...

Read More

How to retrieve database backup, log backup file information.

Problem: How to see all database Files, log files from a backup set. Solution: RESTORE FILELISTONLY (Transact-SQL) Helps us to retrieve information of all the database, log files inside a backup set. This can be useful to restore when...

Read More

How to create Full, LOG backup of database.

Problem: How to create Full, LOG backup of database. Solution: BACKUP (Transact-SQL) Backs up a complete SQL Server database to create a database backup, or one or more files or filegroups of the database to create a file backup (BACKUP...

Read More

How to get Current Time Zone Information of SQL Server

Problem: How to get Current Time Zone Information of SQL Server. Solution:  Xp_regread Extended Stored procedures for different versions of SQL Server. SQL Server does not store the time zone information by itself, it grabs the...

Read More