Re: Setting up Test database using back/restore part 2

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 21:00:52 +0530

Hi,

NORECOVERY option - This options set the database to loading status and it
allows you to restiore the transaction log backup. If you do not have any
transaction logs to restore then it is not required to give NORECOVERY.

How to change the database to active status:- (execute below comamnd from
books online)

Restore database <dbname> with recovery

Thnks
Hari
MCDBA

"Monty" <montysl@nospam.hotmail.com> wrote in message
news:#FDe88WeEHA.3148@TK2MSFTNGP10.phx.gbl...
> Followed instructions as posted by MS and suggested by Andrew J. Kelly.
Used
> Restore Query with the MOVE option as required after first getting
filelist.
> All seemed to go very well but DB now shows up in Enterprise Manager with
a
> (Loading) suffix and seems to be doing so interminably. There are no items
> under the DB showing in the tree and multiple refreshes and stopping and
> starting the service have no effect.
> My newbie self has probably left out something but cannot figure out what.
> My Query was as follows:
>
> use master
> go
> RESTORE DATABASE MYDB
> FROM disk = 'G:\MYDB.bak'
> WITH NORECOVERY,
> MOVE 'InventorySQL_dat' TO 'C:\SQL_DATA\MYDB.mdf',
> MOVE 'InventorySQL_log' TO 'C:\SQL_DATA\MYDB_log.ldf'
> GO
>
> No errors, all seemed to be done correctly according to T-SQL. Data is
> there.What am I missing? TLogs? To further clarify, I was copying a SQL7
> user DB from a W2K server to a SQL2000 install on new hardware and W2K3
for
> testing only at this point. Needed to keep the SQL7 DB live without
> interruption.
>
> Thanks in advance.
>
>

Relevant Pages

  • Re: Another Mirroring Question
    ... Backup transaction log ... restore database on mirror server - make sure to set NO RECOVERY option, ... restore database transaction logs -- make sure again to set NO RECOVERY ... My mirror server db changes from "restoring.." ...
    (microsoft.public.sqlserver.clustering)
  • Re: Transaction Log ??
    ... RESTORE DATABASE IERP52Test ... WITH NORECOVERY ... RESTORE LOG IERP52Test ... > Transaction Log backups are stored with the name DB_tlog_200207221030 (for ...
    (microsoft.public.sqlserver.security)
  • Re: Restore transaction log
    ... > So i checked some messages on the newsserver and tried to restore the ... > database with NORECOVERY but then the database remains loading and the ... > step to restore the transaction log doesn't work. ...
    (microsoft.public.sqlserver.programming)
  • Re: Transaction log problems
    ... IF you have to shrink a database or file it ... sure that you get that database backup on tape or to another machine. ... > We are using SQL Server 2000 on Windows Server 2003 Standard Edition, ... > One of the databases has recently begun showing large growth of the> transaction log and it is causing us some problems. ...
    (microsoft.public.sqlserver.server)
  • RE: Backup in maintenance plan
    ... I selected "Back up the transaction log of the database as part of the ... To ensure an efficient and effective backup and recovery strategy for your ... The transaction log should not be backed up if the truncate log on ...
    (microsoft.public.sqlserver.programming)