Database restore from SQL Server 7 ,SQL Server 2000 to SQL Server 2005

it is possible to restore database from sql server 7, sql server 2000 to sql server 2005.
it can be achieved by using restore and with replace command

use master

restore database mydatabase from disk ='c:\mybackup.bak' with replace

1 comment:

Anonymous said...

Thanks, your solution solve my problems of restoring database seom sql server 2000 to 2005