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

I was wondering about backups on SQL Server 05. <BR><BR>You’ll have to bear with me on this as I’m suffering from the “*$&#*# it Jim, I’m a developer not a database server administrator!” but, I can’t ...

I'm hosting a handful of websites on a windows shared host. They all use the webhost's SQL Server which is housed on a seperate box from the web server.<BR><BR>I want to automate backups of the ...

This article is a revised version of the original published January 3, 2005. See Editor’s Note for details. Two major factors drive database backups these days: compliance and disk space. Some ...

There was an error while loading. Please reload this page. -- Auto Backup for SQL Server - Fixed Version -- Replace MyDB with your database name and ensure C:\DB ...

Idera, a provider of Microsoft SQL Server management and administration tools, has announced the latest version of its SQL Server backup and recovery solution, SQL safe 6.5. According to Idera, SQL ...

If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able to execute RESTORE. If the database exists, RESTORE permissions default to members of the ...