Re: change status for standby database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 13:41:28 +0100

Oops, should have been:

" The RESTORE process will apply the UNDO... " 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in message 
news:%234UaCli%23EHA.1400@TK2MSFTNGP11.phx.gbl...
> Not possible. The recovery process will apply the UNDO logic based on the transaction log, and 
> once that is done, you cannot restore any further backups.
>
> -- 
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Hassan" <fatima_ja@hotmail.com> wrote in message news:OFfF1of%23EHA.3368@TK2MSFTNGP15.phx.gbl...
>> Yes I am aware of this.. Just wanted to know if theres any other way by
>> internally hacking a system table that would make the database available..
>> i.e. assuming I do not wish to change anything on this standby database. I
>> would like to make this database available by updating some system table
>> values and then putting it back in standby state by resetting that system
>> table value.
>>
>>
>> "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
>> news:%23EwGLRe%23EHA.2032@tk2msftngp13.phx.gbl...
>>> You don't need to execute the enture restore again to change the status.
>>> You can issue a RESTORE from Query Analyzer with only the RECOVERY option
>>> (omitting the FROM clause).
>>>
>>>     RESTORE DATABASE MyDatabase
>>>     WITH RECOVERY
>>>
>>> -- 
>>> Hope this helps.
>>>
>>> Dan Guzman
>>> SQL Server MVP
>>>
>>> "Hassan" <fatima_ja@hotmail.com> wrote in message
>>> news:u3Zamya%23EHA.2192@TK2MSFTNGP14.phx.gbl...
>>> >I know i can recover a standby database by restoring the same with
>> recovery
>>> > option
>>> >
>>> > I want to try out something and want to know which system table all this
>>> > gets recorded so that instead of restoring the database  with recovery
>>> > option, can I just update a column in a system table to have it
>> recovered.
>>> > I
>>> > tried to change the status column in sysdatabases but that didnt seem to
>>> > do
>>> > it. It just took the status away from within EM that states its a read
>>> > only
>>> > to have nothing displayed and make it look like its available but upon
>>> > modifying tables it still gave me an error message that the database is
>> in
>>> > load state or something of that sort.
>>> >
>>> > Does anyone know what else I need to update ?
>>> >
>>> >
>>>
>>>
>>
>>
>
>

Relevant Pages