All, We currently have a SQL 2008 server running as a VM. We backup nightly using Veeam and my consultant also advise we backup on top of that via BackupExec. Lately, our Backupexec jobs have been ...

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

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

As I have recently discovered though, you can use a PowerShell script to back up a SQL Server Express database. Before I show you how to perform such a backup, there are a few things that you ...

These backup files have names ending with the ".bak" file extension, and you use them to restore database backups through Microsoft SQL Server. by navigating to the backup utility and loading the ...

SQL Server instances, even if equipped with provisions like automatic backup and recovery, are not sufficiently protected against sudden, disastrous situations like multi-site database failure, ...

I needed to copy the SQL Server database, with its most recent schema changes, down to my laptop for a client demonstration at a location where Internet connectivity might not be available. Even ...

This excerpt from the upcoming book, SQL Server 2008 Administration in Action, introduces the role of service-level agreements (SLAs) as part of a DBA's overall strategy to maintaining reliable ...

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