Is it OK to Copy Database Backups to Tape Using Compression?

Hi, I back up SQL Server 2000 and SQL server 2005 databases to hard disk using the SQL Server Backup Wizard and maintenance plans. Then, I copy the resulting backups to tape using third party tape backup software and compression by the backup software and hardware. I do not use the SQL Server Agent available for the third party backup software. Is this acceptable, or does the compression performed by the third party backup system introduce opportunities for database corruption or other negative effects?

Thanks

Hello,

This is completely acceptable - provided of course that the software you are using is reputable and that you have tested restoration succesfully.

Cheers
Rob

Is it even possible to Import a flat file into SQL 2005?

Is it possible to import a flat file in 2005? It was simple in 2000. The DTS wizard pops-up when I dragged a file into the enterprise Manager. Nothing like that happens in 2005. HELP!
I'm hoping someone knows of a wizard
I am by no means an expert in SQL or T-SQL.
Thanks is advance
Does the import/export wizard not do what you want?

-Jamie|||Thanks for the reply. Where can I find the import/export wizard in 2005?
|||http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/10/15785.aspx
K|||

Sweet.

Thanks