Restore database sql server 2000 using enterprise manager
If for some reason, your restore operation doesn t work, rebuild the enterprise master database and attach all of your databases that reside in the enterprise data directory.
restore Stop the using SQL server Server service using the SQL Server Enterprise Manager.Apply server Changes to Master Database Go to the SQL Server Manager and right-click the SQL server instance.If the database device is server dropped, Yosemite Server Backup will automatically recreate the device when a database contained on the device is restored.Step Rebuild the Master Database At a command prompt, enter the following command to switch the directory: Program FilesMicrosoft SQL Server80ToolsBinn Run: Rebuildm.In the Rebuild Master dialog box, click Rebuild to start the process.In the right pane, locate the Yosemite Server Backup service, right-click the service, and then click Stop.Select Properties to open the SQL Server Properties window. In the serial source field if you don't see the file where you backed up your db choose add.
Method Windows Command allpdf Line At a command prompt, change to the following directory: C:Program FilesBarracudaYosemite Server Backup Type the following command at the command prompt: ytwinsvc -x The Yosemite Server Backup service stops on the local machine.An example of an error might be damage caused by media failure in the area in which master database is stored.If you are recovering from converter a disaster where you have lost a database device file, the master database you have just restored still contains a reference.If you want to look at the actual queries which are fired in the background by Enterprise Manager while performing the restore task you can run a profiler trace.It is strongly recommended that the master database be backed up each time it is changed.This includes such converter things as the tasks that you schedule from the Task Scheduling window, the automatic backups you schedule from the Database editor Backup/Restore window and all replication tasks, which are automatically created editor by the system if the server is configured as a replication distributor.In the Browse for Folder dialog box, select the Data photo folder on the SQL Server 2000 compact disc or in the shared network directory from which SQL Server 2000 was installed, and then click.