Make a database in stand by

Hi All,
I have a server with a database size is about 180Gb, I am going to make this
database as a standby database as a part of Log shipping.
My question is : how to make this database as standby as it without
restoring from backup which mean leaving its files and changing the status
to able to process log shipping to it.
Thanks,You can't do that, I'm afraid. Log shipping is depending of the appropriate log records being
available and has been applied (REDO and UNDO) and this is controlled by the restore process.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mahmoud Amin" <mm.amin@.gmail.com> wrote in message news:uFi5$9F9HHA.1900@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> I have a server with a database size is about 180Gb, I am going to make this database as a standby
> database as a part of Log shipping.
> My question is : how to make this database as standby as it without restoring from backup which
> mean leaving its files and changing the status to able to process log shipping to it.
> Thanks,
>|||so how to restore from existing files , then able to use it as a standby ?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u7el6JG9HHA.4736@.TK2MSFTNGP06.phx.gbl...
> You can't do that, I'm afraid. Log shipping is depending of the
> appropriate log records being available and has been applied (REDO and
> UNDO) and this is controlled by the restore process.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Mahmoud Amin" <mm.amin@.gmail.com> wrote in message
> news:uFi5$9F9HHA.1900@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a server with a database size is about 180Gb, I am going to make
>> this database as a standby database as a part of Log shipping.
>> My question is : how to make this database as standby as it without
>> restoring from backup which mean leaving its files and changing the
>> status to able to process log shipping to it.
>> Thanks,
>|||What do you mean by "existing files"? If you refer to the mdf and ldf files, then no. If you refer
to a database backup file, then yes. Do the restore using NORECOVERY. And you now need an unbroken
chain of log backups to restore, since that database backup was created.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mahmoud Amin" <mm.amin@.gmail.com> wrote in message news:eooVKPG9HHA.4880@.TK2MSFTNGP03.phx.gbl...
> so how to restore from existing files , then able to use it as a standby ?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:u7el6JG9HHA.4736@.TK2MSFTNGP06.phx.gbl...
>> You can't do that, I'm afraid. Log shipping is depending of the appropriate log records being
>> available and has been applied (REDO and UNDO) and this is controlled by the restore process.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Mahmoud Amin" <mm.amin@.gmail.com> wrote in message news:uFi5$9F9HHA.1900@.TK2MSFTNGP02.phx.gbl...
>> Hi All,
>> I have a server with a database size is about 180Gb, I am going to make this database as a
>> standby database as a part of Log shipping.
>> My question is : how to make this database as standby as it without restoring from backup which
>> mean leaving its files and changing the status to able to process log shipping to it.
>> Thanks,
>>
>