Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things to keep in mind to make backup and recovery as smooth as ...

Database backups and restores are key to developing a secure environment for users’ information. A trusted backup plan is a requirement for on-premise and cloud instances. SQL Server database backups ...

The design of a database determines what method is best suited for backing it up, and those methods vary quite a bit. In order to back up a database, you need to know how it’s delivered, but you also ...

For the past several weeks I’ve been doing nothing but complaining about vendors so I thought I’d take a break and write something about SQL Server for a change. So to that end today I’m gonna talk ...

Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we performed ...

You've automated the SQL database backup process; now, let's restore in auto mode. Here's how to do it with PowerShell. In my last post, I demonstrated a script that can execute backups for a server.

I've seen a few posts here and there with people talking about imaging their SQL Servers.<BR><BR>I was wondering what you used to do that and the reasoning behind it.<BR><BR>I assume the general idea ...

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...

This article explains how to repair the MDF file using the native repair methods and how to use a Reliable MDF file Repair ...

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 ...