In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

For backups of Microsoft SQL Server databases, DBAs would be well served ... LiteSpeed doesn’t offer an “at all cost” compression option, such as that found in Idera SQLsafe.

I created a copy of the database on the remote server and generated a SQL script to TRUNCATE all the tables in the copy database as shown in Listing 1. After a quick backup of the newly cleaned ...

I have my SQL Server 2000 maintenance plan for my databases set to delete any transaction log backups older than 5 days. <BR><BR>For most of my databases this is working, but for 2 databases this ...

With SQL Server 2000, there are myriad choices ... sure you don’t forget crucial steps during your weekly database backups. All of this information remains in the transaction log until the ...

Kumar also noted that with Synapse Link, SQL Server users can now run real-time analytics over their database without having to set up a complex infrastructure. “All you need to do is check a ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that ... I needed to empty all the data from a copy of a large database on a remote server, in ...