If it is final full backup and no subsequent differential or log restores, you can run below code and skip the step #5 and step #6 If you want to restore a database to a certain point, restore the ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Kenneth Harris, a NASA veteran who worked on ...

Written by Sudarshan Roy, Senior Database Specialist Architect, AWS & Saleh Ghasemi, Senior Database Specialist Architect, AWS Data is one of the most valuable assets your company owns. Database ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Each Octopus Server node stores project, environment, and deployment-related data in a shared Microsoft SQL Server Database. Since this database is shared, it's important that the database server is ...

Database backups and restores are a fundamental (and critical) skill-set of any MS SQL Server DBA. A solid backup plan is a requirement for most on-premise instances and things are no different in the ...

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...