I've got a new SQL 2005 box that I need to backup via backup exec. The user I am using to backup the data is a local admin on the SQL box, however when I ...

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

For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...

How to back up and restore MySQL/MariaDB data for a website Your email has been sent If you've never backed up your MySQL or MariaDB databases, now's the time. Jack Wallen shows you how to back up ...

Listen to a group of database professionals talk for awhile and someone will eventually bring up the topic of data deduplication. Data deduplication is a means to eliminate redundant data, either ...

The death of SQL has been greatly exaggerated. With all apologies to Mark Twain, the demise of Structured Query Language (SQL), having been forecasted for a while, is far from a done deal. In fact, ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...