automatic restoration

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bharadwaj
    New Member
    • Jun 2007
    • 22

    #1

    automatic restoration

    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
    New Member
    • May 2007
    • 99

    #2
    Originally posted by 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.

    Try the following

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

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

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

    Comment

    • bharadwaj
      New Member
      • Jun 2007
      • 22

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

      Originally posted by Vidhura
      Try the following

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

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

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

      Comment

      Working...