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
MaheshOnline 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.googlegroups.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.googlegroups.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:
>> 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,
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.googlegroups.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:
>> Hi
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7982a687-980a-4eb8-8e9f-6894148e7d8c.htm
>>
>
Showing posts with label backup. Show all posts
Showing posts with label backup. Show all posts
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:
>
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:
>
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
MaheshOnline 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.googlegroups.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-6894
148e7d8c.htm
"Mahesh" <nrkmahesh@.gmail.com> wrote in message
news:1160564344.563238.11560@.i42g2000cwa.googlegroups.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-68
94148e7d8c.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.googlegroups.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:
>
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
MaheshOnline 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.googlegroups.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-6894
148e7d8c.htm
"Mahesh" <nrkmahesh@.gmail.com> wrote in message
news:1160564344.563238.11560@.i42g2000cwa.googlegroups.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-68
94148e7d8c.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.googlegroups.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:
>
Online Backup
Hello There Does anyone know how can i make an online backup with taking the
database offline
thank yousorry i mean without taking the database in offline mode
"Amir Fahmy" wrote:
> Hello There Does anyone know how can i make an online backup with taking the
> database offline
> thank you
>|||Hello,
You could always perform the database backup online. All the below backups
types in SQL Server are online.
1. FULL DATABASE Backup
2. Transaction Log Backup
3. Differential Backup
Take a look into BACKUP DATABASE, BACKUP LOG and Recovery Models topic in
SQL Server books online.
Thanks
Hari
"Amir Fahmy" <AmirFahmy@.discussions.microsoft.com> wrote in message
news:55EB6BB3-ACA4-4CDC-8E1F-09D1DD3CD122@.microsoft.com...
> Hello There Does anyone know how can i make an online backup with taking
> the
> database offline
> thank you
>
database offline
thank yousorry i mean without taking the database in offline mode
"Amir Fahmy" wrote:
> Hello There Does anyone know how can i make an online backup with taking the
> database offline
> thank you
>|||Hello,
You could always perform the database backup online. All the below backups
types in SQL Server are online.
1. FULL DATABASE Backup
2. Transaction Log Backup
3. Differential Backup
Take a look into BACKUP DATABASE, BACKUP LOG and Recovery Models topic in
SQL Server books online.
Thanks
Hari
"Amir Fahmy" <AmirFahmy@.discussions.microsoft.com> wrote in message
news:55EB6BB3-ACA4-4CDC-8E1F-09D1DD3CD122@.microsoft.com...
> Hello There Does anyone know how can i make an online backup with taking
> the
> database offline
> thank you
>
online backup
Sir,
Is it possible to create an online system for taking backup of SQL Server Database from browser.
One option for all the tables with all Primary Keys, etc. and Other one for Saving Data in all the database.
Thanks in Advance,
Vishwa VivekHi Vishwa
SQL database backups always contain full table definitions, keys, data etc..
It's literally a copy of the entire database. These are always "online" from
the point of view that other uses can continue using the database whilst the
backup is going on but not "online" from the internet point of view.
It's possible to create a system that backs up the tables, keys etc
separately from the data, but the application you build to do this is
probably not going to be "online" in that it will hold up other users from
using the system whilst your data backups are going on. It can be done
though - the SQL Enterprise Manager has features (script database for
scripting tables, keys etc & Export / Import wizard for backing up pure data
to various formats). The Enterprise Manager can access remote SQL Servers
over the internet, but it's not really an online application from the
internet sense.
To build such an app, you could produce .asp or .aspx code (or even .php or
other) that allows you to issue the correct commands to support either
database backups or your own custom table, key /. data backups but this
would be rolling your own code.
There are some web based management tools that have already been produced.
Here are a couple:
http://www.aspenterprisemanager.com
http://microsoft.com/downloads/details.aspx?FamilyId=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en
HTH
Regards,
Greg Linwood
SQL Server MVP
"vishwavivek" <vishwavivek@.rediffmail.com> wrote in message
news:DF150DE7-3506-48D1-9F9B-571D3AFC9CA2@.microsoft.com...
> Sir,
> Is it possible to create an online system for taking backup of SQL Server
Database from browser.
> One option for all the tables with all Primary Keys, etc. and Other one
for Saving Data in all the database.
> Thanks in Advance,
> Vishwa Vivek
Is it possible to create an online system for taking backup of SQL Server Database from browser.
One option for all the tables with all Primary Keys, etc. and Other one for Saving Data in all the database.
Thanks in Advance,
Vishwa VivekHi Vishwa
SQL database backups always contain full table definitions, keys, data etc..
It's literally a copy of the entire database. These are always "online" from
the point of view that other uses can continue using the database whilst the
backup is going on but not "online" from the internet point of view.
It's possible to create a system that backs up the tables, keys etc
separately from the data, but the application you build to do this is
probably not going to be "online" in that it will hold up other users from
using the system whilst your data backups are going on. It can be done
though - the SQL Enterprise Manager has features (script database for
scripting tables, keys etc & Export / Import wizard for backing up pure data
to various formats). The Enterprise Manager can access remote SQL Servers
over the internet, but it's not really an online application from the
internet sense.
To build such an app, you could produce .asp or .aspx code (or even .php or
other) that allows you to issue the correct commands to support either
database backups or your own custom table, key /. data backups but this
would be rolling your own code.
There are some web based management tools that have already been produced.
Here are a couple:
http://www.aspenterprisemanager.com
http://microsoft.com/downloads/details.aspx?FamilyId=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en
HTH
Regards,
Greg Linwood
SQL Server MVP
"vishwavivek" <vishwavivek@.rediffmail.com> wrote in message
news:DF150DE7-3506-48D1-9F9B-571D3AFC9CA2@.microsoft.com...
> Sir,
> Is it possible to create an online system for taking backup of SQL Server
Database from browser.
> One option for all the tables with all Primary Keys, etc. and Other one
for Saving Data in all the database.
> Thanks in Advance,
> Vishwa Vivek
Subscribe to:
Posts (Atom)