June 18, 2009 at 3:08 am
Oracle provides Data Guard solution to backup DB Online
Replicatation of SQL Server 2000 is not very compliant, depend on table structures
Is there any way to backup DB online?
Thanks
June 18, 2009 at 3:19 am
All backup operations in sql 2000 are online unless u're using detach/attach,
Backup database mydb to disk ='my path\my file' backs up the db online while other users can make changes to the db concurrently.
June 18, 2009 at 3:28 am
No, I mean "Backup Online" is that DB in backup site is the same in the main site time by time and if main site suddenly downs, we can bring up DB in backup site without loosing any data.
The way likes Oracle Data Guard
June 18, 2009 at 3:28 am
In SQL Server 2000 you can either roll your own backup maintenance plans using stored procedures run at scheduled times using SQL Agent jobs, or you can use maintenance plans to do the same thing. Please take some time to read about BACKUP/RESTORE and Maintenance Plans in Books Online (BOL, the SQL Server Help System).
You will find quite a bit of information there that will help you in this area. If during your reading you have specific questions, there are many people on this site that will be more than willing to help you by answering your questions.
June 18, 2009 at 3:37 am
thang_ngo_2002 (6/18/2009)
No, I mean "Backup Online" is that DB in backup site is the same in the main site time by time and if main site suddenly downs, we can bring up DB in backup site without loosing any data.The way likes Oracle Data Guard
This looks like you're referring to the high availability features in sql server.
you can have an overview of these options (from microsoft's MSDN) and then decide which one to use in ur environment. If you can come up with your exact requirement, ppl here can guide you to best possible option.
1. log shipping
2. mirroring
3. clustering
4. replication.
June 18, 2009 at 3:40 am
ps (6/18/2009)
thang_ngo_2002 (6/18/2009)
No, I mean "Backup Online" is that DB in backup site is the same in the main site time by time and if main site suddenly downs, we can bring up DB in backup site without loosing any data.The way likes Oracle Data Guard
This looks like you're referring to the high availability features in sql server.
you can have an overview of these options (from microsoft's MSDN) and then decide which one to use in ur environment. If you can come up with your exact requirement, ppl here can guide you to best possible option.
1. log shipping
2. mirroring
3. clustering
4. replication.
Database mirroring is not a native option in SQL Server 2000.
June 18, 2009 at 3:44 am
Lynn Pettis (6/18/2009)
Database mirroring is not a native option in SQL Server 2000.
Ahh.. thanks for correcting me Lynn:w00t:. for a moment i thought this post was related to 2005.
June 18, 2009 at 3:48 am
ps (6/18/2009)
thang_ngo_2002 (6/18/2009)
No, I mean "Backup Online" is that DB in backup site is the same in the main site time by time and if main site suddenly downs, we can bring up DB in backup site without loosing any data.The way likes Oracle Data Guard
This looks like you're referring to the high availability features in sql server.
you can have an overview of these options (from microsoft's MSDN) and then decide which one to use in ur environment. If you can come up with your exact requirement, ppl here can guide you to best possible option.
1. log shipping
2. mirroring
3. clustering
4. replication.
Repalication I mentioned above, Clustering seems high cost. I'm finding simple and cheap ways
June 18, 2009 at 4:22 am
Log shipping seems the obvious choice here!! It's easier to implement than others.
What edition of sql server 2000 are you running?
June 18, 2009 at 4:50 am
I use Enterprise edition
June 18, 2009 at 5:29 am
thang_ngo_2002 (6/18/2009)
I use Enterprise edition
2000 Enterprise edition supports log shipping through GUI.
I suggest you go through these URL's to have an understanding of what is log shipping in SQL Server 2000, how it works, failover mechanism etc.
http://msdn.microsoft.com/en-us/library/aa496029(SQL.80).aspx
http://support.microsoft.com/kb/314515
June 18, 2009 at 11:40 am
I use SQL 2000 SP4. I try to create Log Shipping as document but when I use Database Maintenance Plan Wizard in my SQLServer, I don't see option "Ship the transaction logs to other ..." as in the document. Please see my image and explain what I'm wrong?
June 18, 2009 at 11:55 am
That checkbox is visible in enterprise edition. Can u post the result of this?
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
If you are not running enterprise edition, u'll have to setup log shipping manually...
June 18, 2009 at 12:54 pm
you may also want to go through this article.
http://www.sqlservercentral.com/articles/Log+Shipping/62676/%5B/url%5D
This guides u to setup log shipping manually.
June 18, 2009 at 8:00 pm
ps (6/18/2009)
That checkbox is visible in enterprise edition. Can u post the result of this?SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
If you are not running enterprise edition, u'll have to setup log shipping manually...
OK, I see. Does Standby and Monitor servers require Enterprise version also or Primary server only?
Thanks
Viewing 15 posts - 1 through 15 (of 56 total)
You must be logged in to reply to this topic. Login to reply