Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...

With SQL Server 2000, there are myriad choices for backing up your database. Whether your database is small and changes infrequently or very large and changes rapidly, there is a backup strategy to ...

Do you have a BackupExec SQL Agent CAL?<BR><BR>You can't (well, shouldn't) back up the MDF/LDF files directly. If you have the CAL, BackupExec will use VSS to do a snapshot and backup a consistent ...

Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use. This service is used to backup SQL ...

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...

Microsoft Corp. last week began letting SQL Server users who have Software Assurance contracts set up fail-over databases at no extra cost, a new policy that some customers said could give Microsoft ...

In the innocent days of the very late 20th century there was The Family Computer. This single computer sat in a home’s communal space and was shared by each of that home’s residents. For many of us, ...

DIY local backup solution shows a compact Proxmox and TrueNAS backup server using mirrored 24TB Seagate Exos drives for ...

I'm backing up SQL databases directly to a UNC path. Smaller (e.g. <5GB) work just fine, larger databases (this particular one is ~27GB) fails. Here is the log file ...

Click to viewBacking up your data on a regular basis is important, and turning a spare computer into a backup server is often the best way to make sure it gets done. But most methods require either a ...