At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient.
Multiple Backup Copies Stripped – SQL in Sixty Seconds #156
Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.
SQL SERVER – Creating Multiple Backup Files – Stripped
One of my long-term clients (Comprehensive Database Performance Health Check) recently asked me question if I know a way of creating multiple backup files.
SQL SERVER – Check Backup Reliability
Recently I was asked by one of my clients of Comprehensive Database Performance Health Check recently asked if there is any way to Check Backup Reliability.
SQL SERVER – Attach an In-Memory Database with T-SQL
My client of Health Check sent me an email asking if there is any other method when we have to attach an In-Memory Database with T-SQL.
SQL SERVER – Attach a Database with T-SQL
One of my clients reached out to me asking for help in attaching the database files to the server. Let us see today we can attach a database with T-SQL.
SQL SERVER – Simple Recovery Model and Restrictions
I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?