Greetings,
This is a novice with sql server 2000 here. We developed several sites driven by sql 2000 for a client; this client would like to eventually move to a new ISP and wants a backup of the existing databases.
My first basic "approach" question would be: if you needed to "hand over" a sql db, what would you be handing over?
My first answer to this question is to generate the ddl scripts to recreate the objects, but this doesn't take care of the data. So, after copying the ISP db(s) down to my development server using Enterprise Manager, I backed up to a file.
Is such a backup file useful on a different server? In other words, can they just point to this file and blammo, there's the db? I played with the restore in EM a bit, and it seemed like you could only restore a db that had been previously backed up on that server (it gave you fixed choices of databases to choose from). Would our client need to create a blank db of the same name first?
So, what I'm handing over as of right now is 1) the script to create the schema and 2) a backup of each database. Obviously if #2 works you don't need #1...
Most of the stuff I've found online and in my books does not really cover a situation like this, but I'll keep researching. In the meantime, any info is highly appreciated.
Rick