
Originally Posted by
TheJaZZMan
Great way to backup database manually
1. go into enterprise, to your databases, right click on MuOnline db
-->All Tasks -->Export Data
Wizard pops up, click [NEXT]
in the bottom box, MuOnline is selected
click [NEXT]
now click the dropdown button where it says <default> and choose <new>
type in something like MuOnlineBU082607
click [OK] then click [NEXT]
top selection (copy tables and views from the source database)
click [NEXT] click [SELECT ALL]
click [NEXT]
Run immediately is checked ---> click [NEXT]
zoom zoom zoom, it backs it up to a database that is not hooked to anything.
To restore with this method, you "RESTORE" the MuOnline DB the same way you did when you first installed.
Then, just like when you backed it up, but in reverse -- choose the database MuOnlineBU082607, right click, export data,
SOURCE Database MuOnlineBU082607
DESTINATION Database MuOnline