If a production system, please don't forget to take a full backup prior to shrinking your log file. I would hate for you to need to do a point...

Amu

You are correct. Diffs are only what's changed since the last full backup. The size of the diff backup will grow each day until the next full backup....

You are definately on the right track. The first step would be to take the full and restore it at the new datacenter. I then recommend taking as...

Hopefully you are running your database is full mode, because that is the only way you can recover from the accidental delete now. If not, there is no way...

I agree. That is how I accomplish my backup of the backup procedures. Of course the next step is to ensure you have a copy of the backup...

I would use two loops to solve this issue. The first loop is the mastr and contains the information for table 1. the second would loop around table b...

Peter

I agree with you about the convert function, that was a hack of some other code that I have that actually reads data stored in the SQL Server. I...

You can also use what is calledl the poor man's cursor to loop through the recordset as well. It's a little bit more code but is almost as efficient...

Have you looked into using the Script task? I have used it to loop through records. May not be the most efficient, but you have great control there.

Marvin

Mike

Thanks for the clarification.

Also remember, there is a difference between the 32bit and 64bit environment. Since my database is 64bit and my ETL box is in a 32bit environment, I store them...

Jan

try creating a global variable for the file name and then set the file name in the file. In my packages I run an SQL task of the following

SELECT...

Have you thought of partitioning the tables?  you can place the partitions in certain filegroups and then backup those filegroups.

Make sure to check the connection string to the SQL Server 2005 database.  The 2000 server may not have the latest MDAC and therefore can not access the 2005 server. ...

The advantage of clustered indexes is that the data is physically ordered where as other indexes are pointers.  When used, you should try to place the clustered index on the...