Back to local groups vs domain groups.

When granting file level security it is better to grant to local groups then add domain groups. This is because re-orgs and other...

I suggest that you never truncate the transaction log, always back it up.. Database backups are fine for restoring the state of a database, but the transaction log preserves...

Regardless of how often, or how you do your backups, if you have never tried to restore the data to a different machine you are at serious risk.

You should always...

The transaction log dump cannot occur while a database backup is in progress. The failed dump you are experiencing does not break the chain of TL dumps because it...

Back to the original question. We have a database (55GB) that is primarly one table that our custom CAD package uses to store its data. The data is...

I have to agree with David.

Most programmers I have worked with, given free reign, would never finish a project. They would spend their time evaluating new toys...

To reply to the original question:

1) There is a bug in the FTP task in DTS. If the file is greater than a certain size, it will be deleted...

The reason that you can roll back a truncate is because the actual data changes made during a truncate are logged.

The difference between 'truncate' and 'delete from' is that delete...

We have a Hitachi SAN with 10TB of disk. The SAN performance is signifigantly greater than any of the local disk arrays. It has also simplified our lives as...

Be sure that you are NOT using named pipes from your web sserver to your database server. You want to be using TCP/IP. With TCP/IP, all you need...

If you use the 'permanent' temporary table with the SPID column, you will want to clear it at the start of your procedure, not at the end. If you...

Interesting. We also use IBM's Tivoli backup solution. Have you ever considered using their TDP backup client for SQL Server? We use it so that we do...

We were having the same problem with large files. Finally gave up and just call a batch file that starts FTP with the -s parameter. This allows the...

We do the same thing with a DTS package that uses an ActiveX script to log into each of our 41 servers and query msdb. The results are written...

I really did find this code in an application. You are all right in that it was not coded to produce the desired results (i.e. delete the records from...