can i restore sql 2000 from veritas under sql 2005?

While ago my SBS 2003 which had SQL 2000 crashed so I had to rebuild everything and this time I used SBS 2003 R2. My SQL 2000 databases were backed up under Veritas 10 and now I'm trying to restore them under SQL 2005. Is this possible?

Please advice.

Thanks,

Mike

If you mean that you are using Veritas 10 to restore backups taken from a SQL 2000 database to a SQL 2005 instance, then yes this will work just fine.

If you are trying to use the native SQL utilities to restore a backup taken using Veritas, then this will not work.

|||

This is great. Thx for the quick reply. Since on my prior server I had databases on drive E and now they are all on drive C, is this going to be any problem?

|||RESTORE WITH MOVE is your friend. You can look up details on Books Online.