automatic restoration

[bharadwaj]

any automated restoration script is available in sql server2000.
I want to do the restoration for 10 databases(full backup,latest differential backup) in other server.

Pls do the needful.

[Vidhura]

any automated restoration script is available in sql server2000.
I want to do the restoration for 10 databases(full backup,latest differential backup) in other server.

Pls do the needful.

Try the following

use master
go
declare @file varchar(200)
select @file = 'c:\dbackup.backup'

declare @mdf varchar(500), @ldf varchar(500)
select @mdf = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\databasename.mdf'
select @ldf = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\databasename_log.ldf'

restore database <databasename>
from disk = @file
with
move 'databasename' to @mdf,
move 'databasename_Log' to @ldf
go

[bharadwaj]

Thanks for ur reply.I will try it and let you know.
Bharat

Try the following

use master
go
declare @file varchar(200)
select @file = 'c:\dbackup.backup'

declare @mdf varchar(500), @ldf varchar(500)
select @mdf = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\databasename.mdf'
select @ldf = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\databasename_log.ldf'

restore database <databasename>
from disk = @file
with
move 'databasename' to @mdf,
move 'databasename_Log' to @ldf
go