Warm/hot Standby
May 16, 2000
We are planning to provide a disaster recovery facility for a production system. Clustering has been ruled out for technical reasons so we are considering either transactional replication or Log shipping.
Microsoft suggested the log shipping option but it seems a bit messy to me and only provides a warm standby in that it only copies log backups to the secondary machine.
Any ideas why log shipping was suggested in preference to transactional replication? Anyone have any experience in this area?
TIA Colin.
View 1 Replies
ADVERTISEMENT
Nov 6, 2001
I have inherited a problem that I am hoping someone can help out with. A developer used a perl script to move some backup files from one server to another and then restore the databases on other server (at least we think that is what happened, no one is really sure at this point)
Now I need to take the databases ourt of read only mode and drop them but I get an error 5063 stating that the database is in warm standby and the alter database and sp_dboption statements both fail.
How do I get the databases out of warm standby mode?
Thanks in advance for any help you all can provide.
Brad
View 3 Replies
View Related
May 4, 2004
Hi,
I have one database with read-only status. I tried to change it back to normal by doing this..
EXEC sp_dboption 'test', 'read only', 'FALSE' by doing this i'm getting this
Changes to the state or options of database 'test' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
And when i tried on Enterprise Manager it is saying
Error 5063 database 'test' is in warm Standby.
I cross checked and confirmed that it is not in single-user mode and no one is connected to the database!!
Any help is greately appreciated.
thanks
ss
View 5 Replies
View Related
Aug 3, 1999
I have been asked to implement a Warm Standby using Transaction Logs on our main SQL Database - Version 6.5.
Can anyone give assistance regarding scripts, etc., which control the process.
Any assistance is much appreciated.
Regards,
Ian
View 1 Replies
View Related
May 9, 2007
I have one cluster (two machines) of sql server 2005 active/passive called "ClustA" with one Ent. server edition license and another separate server called "STDA" as warm standby server for "ClustA".
Do I need SQL Server license for server "STDA"?
Thanks
View 1 Replies
View Related
Nov 14, 2007
I've been reading a million and one posts on replication
My scenario is that i have a live SQL 2000 server. In a DR invokation, i'e i've lost my live sever, i want to be able to access the same data at the DR (SQL 2000) site and have it accessable to the users. DR server has a different name to the live box.
Replicate
Master
CRMDatabase
Data changes all the time but can have hourly replication of transaction logs for this example. I've currently researched a sp called update logons but this has to be fed each account name to enable them on the new server. There must be a way to activate all CRMDatabase logons with the new server?
Could someone be kind enough to lead me through a step by step guide on the best solution.
Thanks a lot
David
View 3 Replies
View Related
Nov 19, 2007
Hi,
The standby file (.tuf file) got deleted accidentally on the secondary. How can I recover the database without the standby file?
View 3 Replies
View Related
Aug 15, 2000
Any one know of a good way to automate the warm backup process ...
I currently load the full DB dump from the night before and then load TLogs ...
Just curious if anyone has this automated
View 1 Replies
View Related
Dec 1, 1999
i have two servers Production and Waiting, the waiting is a Fall back server and is in another state but in the same domain, is it possible to to use dump statement to dump database and transaction logs to the waiting server??
View 1 Replies
View Related
Dec 3, 1999
i've disided to use a standby server, i have succeeded in running a schedulled task to dump the transcation log every hour the production server unto the waiting server, my problem is that i cannot run a schedulled task to restore the database on the waiting sever every hour any ideas what i might be doing wrong??
View 2 Replies
View Related
Aug 6, 2001
Can I have warm stand by database on SQL 2000 Server.The source server will be SQL 7.0.
In another words can i shipp transaction logs from SQL 7.0 and make Warm stand by on SQL 2000 with SQL 7.0 full and transaction log backups
Thanks
Mike
View 1 Replies
View Related
Apr 10, 2000
Hello out there.
I am currently testing the transmission rates of sql server 70 backups over an ATM circuit (T3) from tampa, fl to detroit. We are evaluating what we need to do to relocate our warm backup database servers to our Disaster Recovery site in detroit. I have tried several types of transmissions and are not receiving any transfer rates that will reasonably work with a recovery plan. I have tried copying a file from source to target, I have tried backing up from source to target, I have tried FTP'ing files, and never can achieve higher transmission rate then 1 gig per hour.
I am looking to talk to anyone out there that may have implemented a long distance sql servber DR site or anyone who is thinking about it. Or anyone who has any input on how I might be able to achieve a higher transmission rate over a T3. Or anyone who is using SAN's in both their local and DR site and might be using special synchronizing software. I am currently piloting a Metastore SAN and a Compaq SAN to solve some local disk management problems and eventually transmit data from SAN to SAN for DR.
Please, if you are involved with any of these strategies and would like someone to share your knowledge with or if I can be of help to you by sharing our testing knowledge, please write asap.
Thanks.
Gail Wade
Database Administration
Raymond James Financial
gwade@it.rjf.com
View 3 Replies
View Related
Sep 25, 2007
Hello, everyone:
I am making disaster recovery plan and considering technical details. My question is that if I configure log shipping and primary server is failed. I have to bring up secondery server online. As warm standby server, the secondary server is Read-only. How to disable read-only?
Thanks
ZYT
View 3 Replies
View Related
Mar 21, 2007
Because the IIS threads are recycled at night, the first user that calls up Report Manager in the morning has to wait 30 seconds before the page loads, as IIS is creating a thread.
I'd like to set up a job in SQL Agent that will navigate to http://localhost/reports/ every morning before users come in to work, so they won't have to wait.
I think a SAL Agent job of type ActiveX Script would be suitable for this, so I need to write the code to navigate to the reports page in VBScript.
Anyone knows how to navigate to a page in VBScript ?
tia.
View 4 Replies
View Related
Dec 28, 2001
Hi
Could you suggest me some of the ways to have standby database server?
All of a sudden my company is in a need for standby database server in sync upto the 10 minutes. Main production database is about 8 GB. It serves almost 6 main sites for the company. No body in my group has worked with standby server issue before.
Any suggestion would help.
Thanks,
Linea
View 2 Replies
View Related
Oct 23, 2001
Hello !
I need to have a hot backup of my Production db
and i going to set up StandBy server : restore Production's backup
to StandBy
could you help me ?????
View 2 Replies
View Related
Dec 28, 2000
Hello,
I need to create standy server. My production server has SQL Server 7.0 and standby server has SQL Server 6.5. I've sync the data between two servers and is planning to do log shipping every 15 min. But I'm little confused, Can the version of Sql server be problemetic? Pls. anyone guide me.
Thanks.
Sejal
View 1 Replies
View Related
Feb 15, 2000
Can I implement the Standby SQL Server using the SQL Server Standard Edition? What's actually the difference between Standard and Enterprise Edition? As I know the Enterprise edition can be installed for up to 32 CPU while Standard edition can only be installed for up to 4 CPU.
Many Thanks in advance!
View 2 Replies
View Related
Feb 9, 2007
I'm confused how the undo works when you restore WITH STANDBY
Suppose I restore WITH STANDBY
FULL
DIFF
LOG A
LOG B
LOG C
How do I undo LOG C? Do I restore LOG B again?
View 2 Replies
View Related
Jul 20, 2005
Hi:Anyone has a detailed procedure description about how to setup a standbyserver? Microsoft makes it sounds very easy which are more complicated.How to handle system databases, does standby server need to be exacthardware as the primary one?Thanks in advance,Xiaodong*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Nov 25, 2007
Hi everybody,
Consider this scenario: I have a production 2005 database and wanna have another one on the same system that contains just the same everything. What is the best way to do this?
Besides, pls give me usefull links to all HA concepts in SQL Server 2005.
Thank you!
Parastou
View 15 Replies
View Related
Jun 12, 2006
I'm setting up log shipping and am running into an issue with applying the transactions logs.
This is my 5th server that I'm setting up and I take a backup of the source database, restore it with replace on the standby server. Then I take a log backup, copy it over and try and restore on the standby server, but the LSN#'s are off. It tells me it's too late for the log and try an earlier..
The timestamp on my backup is 11:43 and my translog was at noon...
I ran a checkpoint on the source database, but that didn't seem to do anything.
What am I missing?
Thanks
Susan
View 4 Replies
View Related
Feb 15, 2000
Can I implement the Standby SQL Server using the SQL Server Standard Edition? What's actually the difference between Standard and Enterprise Edition? As I know the Enterprise edition can be installed for up to 32 CPU while Standard edition can only be installed for up to 4 CPU.
Many Thanks in advance!
View 1 Replies
View Related
Oct 13, 2000
Does sql server have hot standby database? what are the pros and cons of using replication vs hot standby database? Thanks for helping me.
View 1 Replies
View Related
Aug 20, 1999
Where can I find a document that describes how to setup and configure a standby server?
I'm new to SQL Server 7 (I like it). We have a NT 4.0 server with SQL Srvr 7. We just bought another Box that will have the same thing on it with the idea if the 1st goes down, the new box is a 'hot' standby...of course a 'cold' standby will be ok too... I'm not fussy at this point. If you have info on both great.
I'm the SQL Srvr 7.0 DBA (my background is Oracle DBA). I've been doing alot of reading!!!
Can some provide the information I need or point me to someone I can contact?
Thanks
Ron Nixon (650) 940-6419
View 3 Replies
View Related
Feb 28, 2002
I hope to create a 'Standby' server for a critical web application. I am tempted to set up replication, but realize this task could also be done by a scheduled DTS job, which may be much simpler. I have read up on replication and have some reservations about it. A little about our environment: Data does not change very rapidly. Some days maybe no edits, some days maybe changes to 100 rows. The environment is stable, there are few DDL changes....development is essentially over. This system has 10 databases which it uses. Hence, all would need either replication or DTS Transfers. Intended publishing & subscribing servers are on same domain. Both are production servers. I Believe either Snapshot or Transactional would meet our needs if we replicate. There is no user need for replicated data. This is SOLELY a Disaster Recovery motivated situation. Reservations about replication include the hassles with identity columns, the hassles with Subscriber Databases being left in 'Read Only' mode (thereby slowing & complicating the recovery process), the difficulty in cleaning up a server after replication is halted if we abandon replication. My gut feeling is DTS might be best. There are 10 Databases. Sizes (inaccurately) reported are 5 at less than 5 MB, others at the following sizes: 10 mb, 24 mb, 26 mb, 39 mb and one big one: 3000 mb (3 gb). Latency is not a big issue. If these were DTS'd nightly that would be fine. Transactional Replication would be slightly better, but the amount of data change is not high. I would solicit anybody's input on this. Thanks,
View 3 Replies
View Related
Jan 14, 2004
We are maintaining a stand-by database server by doing a daily manual restore of logs. On weekends we do Reindexing of the tables for performance boost. some of these reindexing jobs take upto 10 Hrs
We have found that the restore of the logs taken in the source server after the reindexing job takes as much time it took to do the reindexing.
Typically 15 transaction log sessions for a day takes 40 minutes to restore. However the restore of the tranlog that was taken after a 10 Hr long reindexing job takes as much time(10 hrs) to do the restore also.
The size of the tranlog does not justify this time frame. ( Size of tran logs after reindex is more than other logs but is less than 3 GB)
I would like to know what exactly is happening during the restore of the tran log. Is it doing the reindexing in the destination system as well?
The destination server (standby) is in non recovered mode all the time.
The interesting thing is that I would only take 8 Hrs to do a full restore of the database. We are using ArcServ software for backup and restore.
We are on SQLServer Enterprise 7.0 sp4 on NT 4 Enterprise on source and destination.
We run SAP R/3 on a MSCS Clustered env.
The source database size is 260 GB
Any Comments?
Appreciate your replies
Cyriac
A
View 1 Replies
View Related
Mar 12, 2008
May I know any reason why my Transaction Log Backup job keeps failing while the particular database set to "Standby /Read-Only"?
Kindly help. Thank You.
Regards,
Jimmy Liew
View 7 Replies
View Related
Jul 23, 2005
hi all, I am considering what should be the best way of implementingthe following requirement.I've got a SQL2K production server. Now I've got another machine as thestandby machine for this serverso I'm thinking what method should I be using for this.Should I be using log shipping or Replication? Or if it's replication,what kind of replicationsshould it be?I am thinking maybe snapshot replication can be just fine, right?
View 4 Replies
View Related
Dec 15, 2006
We have a process wherein the production DB is replicated to a server.subscriberA nightly and then a job processes the database for reporting services. Whenever the job fails we have to redo the process all over again. By the time we are finished it is already late in the day and our customers dont like it. Our solution for a standby server is as follows:
1. create another server.subscriberB and start same process from server.subscriberA. So, both servers are replicated from the Production server but SubscriberB is set to run half an hour delayed than subscriberA. The purpose is that should subscriberA process fails, we still have subscriberB. Then we could just change the datasource of the reports to subscriberB
2. replicate subscriberA.ReportServerTempDB to subscriberB.ReportServerTempDB
3. replicate subscriberA.ReportServer to subscriberB.ReportServer
Any insights highly appreciated...
View 2 Replies
View Related
Oct 29, 2007
I have some doubts on standby.
I will explain my environment.
I have two servers A and B both with Win2003 SP1
In the server A, i have a database sql server 2005 in compatibility mode -> 8.0.
In server B have SQL server 2005 and one database in standby / read-only mode. This base is getting to the transactional hour of the server A and applying in standby database. This works fine.
The problem I have is: I need to get the standby server B and create another database for test using yours files. I can get the files of server A because i have 512kpbs link and would be impractical.
Putting in the standby offline mode, i copying the files to another directory on the same machine, but when I try to create another database using the duplicate files of standby receive the following message:
Msg 1824, Level 16, State 1, Line 2 Can not attach a database that was being restored.
What is the command that I need to execute to attach the new bank without message Msg 1824. The command that executing is below:
USE master CREATE DATABASE ON homo (FILENAME = N'F:MSSQLDATAhomohomo_prd_homo.mdf '), (FILENAME = N'F:MSSQLloghomohomo_prd_log_homo.ldf ') FOR ATTACH
As a newcomer I do not know which command I run before attach to conclude restore.
I execute restore database with homo recovery but the database does not yet exist. If I run the restore standby database with recovery, I lose standby and need to download backup copy the entire database in server A to B using link.
If someone has any idea is welcome.
Gustavo
View 3 Replies
View Related
Jan 22, 2001
I have recently implemented a backup solution that keeps our standby server up-to-date with nightly database backup and restores. Ironed out all the problems with syslogins and orphan users. It's been working very well over the past few weeks.
On the production server we do hourly tran log dumps every hour between 8am and 10pm. I would like to implement some form of "log shipping" to bring the window of vulnerability down to 1 hour. By making some alterations to my current process I been able to incorporate the hourly log dumps in the same process.
However, when I try to restore the log on the standby servre I get the following message,
Server: Msg 4305, Level 16, State 1, Line 1
Specified file 'HODB1SQLBACKUPRace_Prd_T_dump.200101231513' is out of sequence. Current time stamp is Jan 23 2001 2:01PM while dump was from Jan 23 2001 3:01PM.
After a bit of investigation I found the dumptrdate field in the sysdatabases table and it was set to Jan 23 2001 14:01. After updating this field to Jan 23 2001 14:01, I ran the load command again but received the same error message.
Is there something else that needs updating on the standby server? Is what I'm trying to do possible in 6.5? Any help or ideas would be greatly appreciated.
Thanks
Phill
View 2 Replies
View Related
Jul 20, 2005
Hi,Currently we have logshipping setup with one production db serversending the logs to one standby database server.we would like to have setup where there will be two standby dbservers. Second server will be located in different country.Kindly let me know if we can have the setup wherethere is one primary server and two standby db servers.When I tried to configure the same I am not able to complete themaintenance plan.It gives error that logshipping monitor already exists.Please help me. tks in advance.RegardsKamal
View 1 Replies
View Related
