Implementing Standby SQL Server

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


ADVERTISEMENT

Newbie Query - Replicate To Hot Standby And How To Enable The Hot Standby For Access

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

LS - Recover A Standby Database - Deleted Standby File (.tuf File)

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

Standby Server

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

Help Pls !!! StandBY Server

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

Standby Server

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

Standby SQL Server

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

Standby Server

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

Setup Standby Server

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

Standby Server / Replication Or DTS?

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

Restore Of Log To Standby Server

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

Standby Reporting Server

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

How To Duplicate Standby On The Same Server?

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

Reverting Back To Production Server After Standby

Jul 15, 2001

We need to perform some maintainence on our database server which may take quite some time. We have a standby server which we constantly apply logs to.
We are planning to recover the standby server and use it while the production server is being maintained.

My question is how to I get back to using the original production machine.
The only way I can think of is to do a full backup on the standby machine,
do some transaction log backup and then restore these on the original production machine.

Is there any way to use the full backup from the original production machine and well as logs from the standby machine. When I try this I get the message that the database has not been rolled forward far enough.

In summary:
1. Backup full database on Prod Server
2. Restore full database on Standby Server
3. Backup transaction log (1) from Prod Server
4. Restore transaction log (1) on Standby Server
5. Recover database on Standby Server
6. Make modifications on Standby Server
7. Backup transaction log (2) on Standby Server
8. Restore full database on Prod Server
9. Restore transaction log (1) on Prod Server
10. Attempt to restore transaction log (2) fails.

View 3 Replies View Related

SQL Server - Warm Standby Using Transaction Logs

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

SQL Server 2005 License For Warm Standby

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

Impact On Replication When A Server Goes Into Standby Mode

Sep 1, 2007

We have the following scenario:
Server A replicates Database A to Server B.
Server C has Database A on it as well, but in standby mode. We are applying the transaction logs generated by Database A on Server A to the database on Server C leaving it in standby mode each time.

Let's say we had planned maintenance for Server Aand dumped the last set of transactions on Server A in standby mode to be applied to to Server C. What happens to the replica on Server B? When I start to use Server C, can I backup its transactions and apply them to Server A, and then have those transactions replicated to Server B? And then what do I do when the maintenance is complete so that I can swithc back to Server A and have the replication continue on as before the maintenance to Server B?

Thanls

View 1 Replies View Related

Implementing DB Security In Existing Server

Mar 25, 2008

Dear Colleagues,

How do I install a Microsoft SQL Server 2005 database application in an existing server in an existing database server and still have the control over it and also restrict the new server Admin user from editing or even opening my DB. Any modification of my database or code should be implemented only by me. Is it possible to remove the Builtin Admin from the server role?? As in my case, there is no need for anyone else to open the DB in Management Studio at all as my VB application does all that is required.

Thanks and best regards,

Peter

View 3 Replies View Related

DB Design :: Implementing Hierarchies In Server

Jun 12, 2015

I want to be able to implement infinite levels of Hierarchies in SQL Server (2012), in addition to being able to address issues like same child having more than one parent (eg. An Employee could end up having 2 different managers - eg. Project Manager,  Delivery Manager).

One way is to have self referencing table (where each row has a parent id , referencing to a parent record - but this would not work in cases where a child  has more than 1 parent).

Are there other more efficient ways? What is the best way to implement this?

View 9 Replies View Related

Need Help Implementing Weka Into SQL Server 2005

Jul 29, 2007

Hi!

I'm a student of computer science, and for one of my projects I would need Weka plug-in for SQL Server 2005. I don't know much about plug-ins, so if I'm asking stupid questions, I hope you will forgive me. It was easy to get a library from weka that I can use in Visual Studio, but I just can't figure out, how to get Weka data mining algorithms into plug-ins for MSSQL 2005.

I would appreciate any help given...

AzDHeX

View 8 Replies View Related

Standby Server - Applying Transaction Logs Automatically

Jun 21, 2001

Can anyone direct me to a code that would automatically apply transaction logs to a DB in the standby server? We have a process that dumps the transaction log backup from the primary server into the backup server every hour on the hour, but I need to apply that transaction log as soon as it is in the standby server.

I am sure someone will ask, why not do transactional replication or log shipping? My answer to that is I have yet to learn how to setup replication between servers. I need to get our backup server up and running in the next few days.

Thanks in advance for your help.

Helen

View 1 Replies View Related

Moving A SQL Server 2000 Database That Is In Standby Mode

Jul 20, 2005

SQL Users/DBAs,I'm trying to move data files around for a database that is in standbymode. I can detach/attach the database fine usingSP_DETACH_DB/SP_ATTACH_DB , but when I re-attach the database the logsequence is broken and I can't restore any more logs. Does anyoneknow if there is a way to move around data files and keep the databasein standby mode?Thanks,JB

View 4 Replies View Related

Log Shipping, How To Put The Secondary Server Back Into Standby Mode.

May 12, 2008

We are using MSSQL 2005 and Log Shipping.
After making our secondary SQL server primary, how can we put the secondary SQL server back into standby mode?

View 1 Replies View Related

Implementing Message Queue In SQL Server 2000

Jun 2, 2006

I am implementing a message queue system in SQL Server 2000. My queue table looks something like this:

[MessageId] [uniqueidentifier] NOT NULL,
[MessageType] [uniqueidentifier] NOT NULL,
[Status] [tinyint] NOT NULL,
[SubmittedTime] [datetime] NOT NULL,
[StartTime] [datetime] NOT NULL,
[DispatchedTime] [datetime] NULL,
[CompletedTime] [datetime] NULL,
[MessageData] [image] NULL

This is how I retrieve the next message for processing:

SELECT TOP 1 *
FROM [Queue].[MessageQueue] WITH (ROWLOCK, UPDLOCK, READPAST)
WHERE [StartTime]=@pStartTime AND [MessageType]=@pMessageType AND [Status]=@pStatus
ORDER BY [StartTime]

and mark it as being processed:

UPDATE [Queue].[MessageQueue] SET [Status]=1 WHERE [MessageId]=@pMessageId

After message has been processed I delete it from the queue:

DELETE FROM [Queue].[MessageQueue] WHERE [MessageId]=@pMessageId

All database accesses are transactional with default READ COMMITTED. The problems start when there are a few concurrent accesses: I get deadlocks when retrieving next message. If I do not delete message after processing then there is no deadlock. But this is not what I need.

I played with different isolation levels and locking hints and was able to avoid deadlock using TABLOCKX:

SELECT .... FROM [Queue].[MessageQueue] WITH (TABLOCKX)

But in this case you cannot concurrently retrieve messages which was my goal from the beginning. How do I achieve this?

Thank you,
Alex

View 18 Replies View Related

Implementing Membership And Role Management On SQL Server 2005?

Feb 22, 2006

How can I implementing Membership and Role Management on SQL Server 2005 (not Express)? Anyone have any documentation? Are there any scripts to run that will basically set up the same Database schema on SQL Server 2005 that Express uses?
Thanks.

View 3 Replies View Related

Implementing A Lookup Field In SQL Server 2005 Via VWD Express

Feb 27, 2006

Hello Folks
I am a total new boy to Visual Web Developer and am struggling to implement a lookup field in the SQL Server Express that ships with it.
I am trying to find the equivelent of using the lookup wizard in MS Access. So in Access I can select the lookup wizard from the drop down list of datatypes and refer to another table of standing data. Once configured the tables contents appear as a drop down list in the field of the master table.
So how do I create a table in SQL Server 2005 that uses another table to give a drop down list in one of its fields?
I have found some excellent tutorials and books but none of them seem to drill down to this level of table design, can anyone recommend any books that do?
Thanks
Bradley

View 8 Replies View Related

Implementing Sql Server Express Within A Strict Domain Environment...

Nov 5, 2006

I am looking for some assistance from the grand knowledgebase out there concerning the implementation of Sql Server Express 2005 on a client's strict domain environment.

I am designing and implementing a pos software that resides on registers and a server within a number of stores. The registers are running WePos and the server is running Server 2003.  I run an instance of sql server express on all devices. The registers read the server when it can see it but when it cannot it reads the local instance. I am seeing a number of performance issues and I am trying to tweek the installation and coding of SSE on all devices.

Any words of wisdom for me out there???

Thank you,

Sir Robert

 

View 3 Replies View Related

Standby Server In SQL Server 6.5 And Differential Backup

Mar 29, 1999

Hi

Is there anyway I can implement a standby server in SQL Server 6.5 ? In addition are there any tools in the market which I can use to perform a differential backup ?


I believe SQL Server 7.0 can do this, will I be able to use ARCserverIT or seagates's backup exec to perform these functions ?


Vijay

View 1 Replies View Related

Microsoft Best Practices For Implementing Windows Authentication For Sql Server 2005

Nov 10, 2005

Microsoft recommends using Windows authentication instead of SQL Server authentication in SQL Server 2005 for improved security. What are the Microsoft best practices for implementing this? Will be helpful if someone also provides some links that talks about this.... 

View 5 Replies View Related

Standby Server Running SQL Server 2000 And 2005 Side By Side

Sep 27, 2006

I have one standby server that I use for multiple production DB SQL Server 2000 servers. We are upgrading one of the production SQL Servers to 2005. I will install 2005 on my standby and run 2000 and 2005 side by side.

Is this okay? Are there any caveats specific to running 2000 and 2005 on the same standby server?

Thanks!
JL

View 1 Replies View Related

Could Not Find Standby In Sysservers. Run Sp_addlinkedserver To Add The Server To Sysservers

Apr 23, 2007

a different scenario leads to the same problem, the error message:
Could not find "Standby" in sysservers. Run "sp_addlinkedserver" to add the server to sysservers"

I browsed the thread for the same error message and the solution doesn't applies to me. Here is my system settings. we have a kind of backup system. a primary server is set up to copy the database files to a standby server. when the primary is off, the standby server will take over primary's name and ip. and our application runs on the standby as if in the primary. in both machine the odbc connection are set to point the primary server.

this setup works well in SQL server 2000 for both primary and standby servers, but it gives the error message on SQL 2005 in the standby server. I noticed that this is because the application opens an empty table. after inserting a record by hand, the error has gone away.

I know it doesn't make too much sense, but it 's what I observed. Could anyone give me some input how could this happens and what' s the solution?

View 6 Replies View Related

SQL Server Standby Server - Help

Dec 6, 1999

We are planning on setting up a Standby server for our Production SQL Server7.0 for the sake of Redundancy. Does anyone know of a way (script) to automate the trans. log process to the standby server?

TIA
-SG

View 1 Replies View Related

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 View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved