Monday, February 20, 2012

Online Restore.

Hi,
Can i take backup(not full db, only one filegroup) of a database in
Server1 and restore it on a same database in another server2 using
Online Restore commands. Note:both database has same schema and data.
Addtional data in few tables in server1 needs to be copied to server2
and those tables are in separate filegroup.
Could you please send me the sequence of steps to do the online
restore?
Thanks in Advance
Regards
Mahesh
Online restore as you said was introduced in sql server 2005 (enterprise
edition ) if i remember well
Why do you need an online restore? Some users are using the database on
server2?
Are you using sql server 2005?
"Mahesh" <nrkmahesh@.gmail.com> wrote in message
news:1160544431.729794.226080@.m7g2000cwm.googlegro ups.com...
> Hi,
> Can i take backup(not full db, only one filegroup) of a database in
> Server1 and restore it on a same database in another server2 using
> Online Restore commands. Note:both database has same schema and data.
> Addtional data in few tables in server1 needs to be copied to server2
> and those tables are in separate filegroup.
> Could you please send me the sequence of steps to do the online
> restore?
> Thanks in Advance
> Regards
> Mahesh
>
|||Yes. we are using sql2005(enterprise Edition). we tried online restore
but the status of the database changed to Restoring... so please send
me the steps to do online restore.
Thanks
Regards
Mahesh
Uri Dimant wrote:
> Online restore as you said was introduced in sql server 2005 (enterprise
> edition ) if i remember well
> Why do you need an online restore? Some users are using the database on
> server2?
> Are you using sql server 2005?
>
|||Hi
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7982a687-980a-4eb8-8e9f-6894148e7d8c.htm
"Mahesh" <nrkmahesh@.gmail.com> wrote in message
news:1160564344.563238.11560@.i42g2000cwa.googlegro ups.com...
> Yes. we are using sql2005(enterprise Edition). we tried online restore
> but the status of the database changed to Restoring... so please send
> me the steps to do online restore.
> Thanks
> Regards
> Mahesh
> Uri Dimant wrote:
>
|||Hi,
i am not able to access the below page. i am getting 'the page cannot
be displayed' error. could you please send me the URL or Please send me
content as doc to my id.
My ID: nrkmahesh@.gmail.com
Thanks a lot
Regards
Mahesh
Uri Dimant wrote:
> Hi
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7982a687-980a-4eb8-8e9f-6894148e7d8c.htm
>
|||The URL Uri posted is a SQL Sever 2005 Books Online reference. Open the SQL
Sever 2005 Books Online (a.k.a. help), view a topic and paste the URL into
the URL address bar.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mahesh" <nrkmahesh@.gmail.com> wrote in message
news:1160566954.263572.187590@.e3g2000cwe.googlegro ups.com...
> Hi,
> i am not able to access the below page. i am getting 'the page cannot
> be displayed' error. could you please send me the URL or Please send me
> content as doc to my id.
> My ID: nrkmahesh@.gmail.com
> Thanks a lot
> Regards
> Mahesh
> Uri Dimant wrote:
>

No comments:

Post a Comment