Looks cool. I'd add a line to step three to make sure the ID being used has db create rights on the SQL server. I never actually finished the change database wizard, just enough to create the database and update the master tables. I didn't have the SRP info handy and was too lazy to look it up. I knew the data was in the MSDE backup anyway.
There are a few different ways to do this. What's important is that BES must create the db on the SQL server. Then either copy or restore the other db.
|