It does not matter whether the backup is done using sql studio or the be sql agent. In the browse for folder dialog box, select the \data folder on the sql server 2000 compact. With move 'installprov40data' to 'c:\program files\microsoft sql server\mssql.1\mssql\data\psych_test_data.mdf', move 'installprov40log' to. One common situation where you would use this method is for restoring a database from a backup file recovered from tape or one that has been copied from. In the rebuild master dialog box, click browse. About press copyright contact us creators advertise developers terms privacy policy & safety how youtube works test new features press copyright contact us creators. Hello friend, i need to restore the sql 2000 database to sql 2008. The backup is the same. Do you have a specific error? U got a dialog ,set the location for the.
Make sure that you do not have database with the same name of the database you want to restore. One common situation where you would use this method is for restoring a database from a backup file recovered from tape or one that has been copied from. It does not matter whether the backup is done using sql studio or the be sql agent. In the rebuild master dialog box, click browse. To restore to a different machine than the one where the. In the browse for folder dialog box, select the \data folder on the sql server 2000 compact. Hello friend, i need to restore the sql 2000 database to sql 2008. The backup is the same. How can i restore it? With move 'installprov40data' to 'c:\program files\microsoft sql server\mssql.1\mssql\data\psych_test_data.mdf', move 'installprov40log' to.
Make sure that you do not have database with the same name of the database you want to restore. It does not matter whether the backup is done using sql studio or the be sql agent. The be sql agent invokes the. To restore to a different machine than the one where the. Hello friend, i need to restore the sql 2000 database to sql 2008. U got a dialog ,set the location for the. One common situation where you would use this method is for restoring a database from a backup file recovered from tape or one that has been copied from. Actually i have database which is working on sql 2000 now i want to use sql. In the browse for folder dialog box, select the \data folder on the sql server 2000 compact. You need to select what database or session you want to restore, select a destination and then run the job.
Actually i have database which is working on sql 2000 now i want to use sql. It does not matter whether the backup is done using sql studio or the be sql agent. In the browse for folder dialog box, select the \data folder on the sql server 2000 compact. The be sql agent invokes the. Hello friend, i need to restore the sql 2000 database to sql 2008. To restore to a different machine than the one where the. With move 'installprov40data' to 'c:\program files\microsoft sql server\mssql.1\mssql\data\psych_test_data.mdf', move 'installprov40log' to. Right now your only hope is the file is actually okay, but you aren't using the right syntax or what have you to restore it. Do you have a specific error? Launch enterprise manager and connect to server.
In the browse for folder dialog box, select the \data folder on the sql server 2000 compact. Do you have a specific error? To restore to a different machine than the one where the. Make sure that you do not have database with the same name of the database you want to restore. Right now your only hope is the file is actually okay, but you aren't using the right syntax or what have you to restore it. How can i restore it? Launch enterprise manager and connect to server. One common situation where you would use this method is for restoring a database from a backup file recovered from tape or one that has been copied from. The backup is the same. Hello friend, i need to restore the sql 2000 database to sql 2008.