How you configure your virtual enviornment is vital to using it for SQL Server. All of our servers are virtual including our production servers and our performance is stellar....

I get a syntax error when I run this.

You would have a problem with table partitioning which is a feature in EE edition. We have a database which is over 20gb and ran into that problem even...

Let's get a clearer understanding of why you wish to create a dts package on 2005 when you can use SSIS. As far as the errors you're getting is the...

There is no reason to backup the log if you want to do a full. I would recommend dumping the log, shrink it and run a full. This will...

Suresh,

Glad you mentioned this, it might be the backup db compatibility might be set to 60.  Here is the article about this:

http://support.microsoft.com/default.aspx/kb/275025

Jules

I think going to transactional replication would be the solution on this if you cannot truncate the tables due to many foreign key constraints.  What do you gurus out there think?

Jules