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

Joey on SQL Server The Right Approach to Database Backups Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things ...

These backups are commonly used to migrate databases between different SQL Server instances running on-premises or in the cloud. They can be used for data ingestion, disaster recovery, and so forth.

To manage both issues, DBAs turn to products that crunch down the size of databases for speedier backup and protect data with strong encryption. For backups of Microsoft SQL Server databases, DBAs ...

SQL Server lets you disconnect a database from the main server program, allowing you to make safe backup copies or send data to branch offices.

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

Key-value A key-value database is one of many not-only SQL (NoSQL) databases with a single schema consisting of keys and values, where you can look up the value if you know the key.

That’s it. That’s all the powershell code it takes to query for your last backup times. Now, there are tons of other properties you can query at the DB level that are just as easy.

If you have accidently deleted data from database tables in MS SQL Server, you can restore the deleted data (tables) using Log Sequence Number (LSN). But for this, you need the transaction backup file ...

SQL Server database backups in Azure, in either an IaaS or PaaS implementation, introduce several distinct features which may help optimize a backup plan. Of course, there are also a few drawbacks to ...