Re: Restore for the transaction files
From: Uri Dimant (urid_at_iscar.co.il)
Date: 01/30/05
- Next message: Mike L.: "Re: EXEC Permission"
- Previous message: Uri Dimant: "Re: EXEC Permission"
- In reply to: Sharad: "Restore for the transaction files"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 Jan 2005 11:56:27 +0200
Sharad
I don't thing that nowadays 1 gb database is big.
Anyway, restore the database on 'off-line' server then perform backup log
files for active database and apply them to analysis database
Look up stanby servers article in the BOL.
"Sharad" <Niitmalad@yahoo.co.in> wrote in message
news:119801c506ad$25c5b530$a501280a@phx.gbl...
> Dear Friends
>
> We have two location where in one location the database
> is active and in the other location we only use the
> dabase for the analysis.
>
> There is no possiblity of replciation as we do not have
> the secured connection. So i need a solution which can
> temp work.
>
> The bakup file is very big say almost one GB and there is
> no point to do the transfer of this big file and restore
> to the analysis Sql server so that it will remain
> updated. But If i can restore the transaction TRN files
> it would solve my purpose as they are small in size and
> it would keep my database updated.
>
> Please suggest how i can do the restore of the
> transaction files.
>
> YOur ealire reply would be a great help.
>
> Best regards
> Sharad
- Next message: Mike L.: "Re: EXEC Permission"
- Previous message: Uri Dimant: "Re: EXEC Permission"
- In reply to: Sharad: "Restore for the transaction files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
