Note: For the purposes of today’s article, I will assume that you’re using SQL Server 2005 or later. Every SQL Server database has at least two files; a data file and a transaction log file.

Search titles only By: Search Advanced search… ...

I'm having to robocopy SQL 2005 dbs to another server for backup, and the other server is running SQL 2000. What is the T-SQL I need to use in order to delete files older than 'x' days?

SUNNYVALE, USA: Novixys Software, Inc. has released Exult for SQL Server v. 1.1, an easy to use Windows application that helps database administrators to import XML files into a Microsoft SQL ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.