Change Database With A Different DB On Server X That Is Being Replicated To Server Y

Nov 16, 2015

I have Transaction Replication setup on a Server X. Server X is publisher and distributor. Server Y is the Subscriber.Everything works perfectly.  But I need to change the Database with a different DB on Server X that is being replicated to Server Y. I have following questions:
  
  1-  Do I create a new distributor on Server X and delete the current distributor?
   2- Create a new Replication Setup on Server X and Y ? 
   3- Delete the subscriber DB on Server Y (Subscriber) ?
   4- Can I just disable the current setup on Server X and Server Y instead of deleting it

View 5 Replies


ADVERTISEMENT

Replicated Database Movement From One Server To Other

Oct 5, 2006

Hi All,

I have SQL server 2005 Database which is having following Replication stuff.

1. 6 merge Subscribers

2. 5 Snapshot Subscribers (Push Susbribers)

3. 3 Transactional Publisher

Due to the Performance Issue, there is need to move SQL server from the Current Server to an Higher End Server.

I want to keep all the Replication settings after movement of the Database. Can anyone tell me how to acheive this requirement?

Is there a possibility to keep the Replication settings ? Even we can have the Same System Name to the New Server.

Awaiting response...

Thanks,

Thams.

View 1 Replies View Related

Access2000 Database(table) Replicated To SQL 2000/2003 Server

Nov 4, 2006

I'm trying to replicate a table(s) in access 2000 to MS SQL server 2000/2005 programatically on a timed instance and then have these tables merged in SQL to create one table.

Any guidance appreciated.

Thank you,

View 1 Replies View Related

Failure To Create First Replicated Database (SQL Mobile/SQL Server 2005) / Err 28627

Jan 8, 2006

Hi,

I'm trying to get my first replication going, and I have set up a database successfully, along with merge replication, however when I attempt to create the first subscriber, I get a permissions issue, regardless of what I do. In the SQLCESA30.LOG file, I get the following entries:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627


I posted the initial thread under the "Replication" forum, but am including this 'pointer' post here due to a lack of replies there, and the relevance of this thread to this forum. Please see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for more details.

 

Thanks.

View 1 Replies View Related

Proper Procedure To Change Servername Of Replicated Environemnts?

Jul 22, 2005

Hi There

View 4 Replies View Related

How To Change The Data Format For A Single Database In A SQL Server Group Of Database

Nov 1, 2001

Hi all,

I have to change the date format for one database in a group of databases in my sql server 2000,Can you please tell me how to change the date format.


thanks in advance

View 1 Replies View Related

How Do I Change The Default Database In Sql Server

Dec 19, 2007

Does anyone know how to change the default database in sql server 2005, I keep getting an error.

View 1 Replies View Related

Can I Change A SQL Server Everywhere Database's Password?

Jun 20, 2006

Hi, I'm using the SQL Server Everywhere CTP on the desktop and haven't used SQL Server Mobile in the past.

I'm having some difficulty determining whether it's possible to change a SQL Server Everywhere database's password. Obviously authentication on a file-based SQL Server Everywhere database differs from that of server-based SQL Server database. Is it possible to change a SQL Server Everywhere database's password?

That said, I feel like I've made a decent search of the to change a SQL Server Everywhere books online. If it's not possible to change the password in place (i.e., without copying all data to a new file with a different password), please count this as a vote to add that functionality. Making a database password "permanent" lessens its effectiveness. Thanks,

Curt

View 4 Replies View Related

Access Database Change To SQL Server

Apr 15, 2006

I designed a database that works well in Access and I want to get it to run in SQL Server. How do I learn how and what to do to change over to SQL Server?

View 1 Replies View Related

Change An Access Database To SQL Server

Apr 15, 2006

I designed a database that works well in Access and I want to get it to run in SQL Server. How do I learn how and what to do to change over to SQL Server?

View 13 Replies View Related

SQL Server 2012 :: Change Database Within A Cursor?

Aug 21, 2015

I like to backup the stored procedures' code used in my databases. So I created this Script:

/*
IF OBJECT_ID('[Monitor].[dbo].[Procedurecode]') IS NOT NULL DROP TABLE [Monitor].[dbo].[Procedurecode];
*/
DECLARE
@db nvarchar(50),
@strSQL nvarchar (100)
IF CURSOR_STATUS('global','cur1')>=-1 BEGIN DEALLOCATE cur1 END

[code]....

Problem is (and I seem not to be the only one with tis) described here:

"If the executed string contains a USE statement that changes the database context, the change to the database context only lasts until sp_executesql or the EXECUTE statement has finished running." There is nothing magical in SQL server that knows you intend a series of dynamic sql commands to be part of a single job running in a single context. You have to build the entire string for the job you want to execute."

[URL]

So I only get the SPs of the current database.

View 5 Replies View Related

What Is The Best Way To Dynamically Change Server Or Database Name Inside A Sp?

Jun 8, 2006

To be clear:

You have a store procedure and inside you make Updates or Inserts against another Server. But that name can change and I dont want to change it manually in everyplace.

Per example:

SELECT *
FROM Himalaya.DBName.dbo.tblUserGroup
WHERE fldUserID = 7300

I have several Selects, Updates and Inserts pointing to that server.

What I can do if I want to change from Himalaya server to another server?

The same with the Database Name.

Thank you

View 6 Replies View Related

How To Change From SQL Server Express To Database.mdf Connection

Apr 29, 2006

Hi,

I've created a SQL Server Express Database that is used by an ASP.NET 2.0 application (developed using VWD Express).

I would like to be able to:

Make changes to stored procedures, views and table structures while developing/testing ASP.NET application - which, ideally, needs a SQL Server Manager Studio Express connection and
Upload my application and data to a database on a network - which, ideally, needs a direct Database.mdf connection.

I know that I need to change my connection string - and am able to achieve that with ease - but I'm not sure what the best way of switching between the two ways of attaching on the database side. I keep getting logon type problems etc.

Thanks very much.

Regards

Gary

View 1 Replies View Related

Optins Of Trailing Database Change In Sql Server

Oct 28, 2006

Hi All,

I am in need of some option using which i can trail the changes made to my database. Specially i want to track all the DDL and DMl changes.

I know about the external tools provided by lumigent and some other companies to do this but i was just wondering if we have some option within sql server.

I don't need extensive report as provided by lumigent.

Just getting somethin on DDL and DML will help. 

Even help on some work arounds to do same will be appreciated.

TIA

Prashant

 

View 12 Replies View Related

Change Database From Sql-Server 2000 To 2005

Sep 5, 2007

Hi ,

Currently my application running on Sql-Server 2000 and I want to upgrade with Sql-Server 2005
will It work sql- server 2005?

if no what changed i need to do?
Can anyone help me?

Thanx

View 3 Replies View Related

Move Replicated DB To Different Server?

May 22, 2007

Is it possible to move/migrate a replicated database to a different server without breaking the subscriptions etc?

If so, is there a guide on how to do this?

Many thanks for your help in advance!

best regards, Stefan

View 3 Replies View Related

How Do I Change The Schema Of SQL Server 2005 Database Diagrams

May 23, 2008

Hi all.  I'm mapping FKs in a DataWarehouse and I'm wondering if there is a way to change the schema of a database diagram from dbo.
Thanks,
Charlie

View 2 Replies View Related

SQL Server 2008 :: Unable To Change Database Context

Apr 28, 2015

USE master
Declare @db as nvarchar(258) = quotename (N'tempdb')
EXEC (N'USE' + @db + N'; EXEC(''SELECT DB_NAME();'');');

View 5 Replies View Related

SQL Server 2008 :: Database Collation Change Impact

Aug 5, 2015

Our SQL Server 2008 r2 has collation Latin general.

And my database 'DB1' , 'DB2' has collation set to Japanese unicode.

My sql team has informed they cannot change system collation as it hosts other db's as well.

My Query: What will be the impact of changing collation from JP to Latin.

View 1 Replies View Related

SQL Server 2008 :: Data Is Not Getting Replicated

Jun 24, 2015

We are using push subscription using transactional replication. Is there a recommended value for retention period on distributionDb? We are using default value of 72 hrs and recently we saw an issue where data was not replicated with an error that subscription was inactive. When I searched, I fid that it is related to the retention period setting on distribution DB.

View 0 Replies View Related

How To Change The Value Of A Column In Sql Server 2005 Database When A Button Is Clicked In Asp.net 2.0?

Nov 22, 2007

hi all,
I have created a table in sql server 2005 as follows:
table name --> sampletest
1.id -->int ,identity,primary key
2. student_name --> varchar(50),not null
2. active --> bit, default value=1
Using vb.net 2005 , i entered names into sampletest. And when i check the table in the sql server 2005 the names are inserted and the active value is 1.
In another page i added a drop down list which bind all the student_name from sampletest and a delete button.
Now when i select a name and click the delete button that respective item's active column should be changed to 0. if any one who knows how to do this please help me..
thanks
swapna.
When i enter names into the student_name it's active state is "true".I do this programmatically using vb.net 2005.  

View 2 Replies View Related

Moving Replicated Databases To A Replacement SQL Server

May 23, 2006

Any advice that can be offered on this subject would be much appreciated.

We are debating whether to backup/restore the replicated databases or simply copy the mdf and ldf files accross and Attach them. The question is whether the replication information is retained for the publshed objects when the files are copied across? Alernatively, must we use backup/restore with KEEP_REPLICATION set for the restore?

We also plan to back up and restore the distribution, publication, master, msdb etc databases as well as rename the SQL Server to have the same name as the original.

Do these things need to happen in any particular order?

Does the timing of the renaming of the SQL Server matter?

At least some of the these operations (restoring the master database and renaming the SQL Server) need to be done in single user mode. Is is best to restore all the system databases in single user mode?

Lastly, is it necsssary (from a SQL Server point of viewpoint) to rename the computer to have the same name as the SQL Server?



Thanks,



Dick Campbell

View 1 Replies View Related

SQL Server 2014 :: Capture Each Change In Database Without Updating Earlier Status

Jan 22, 2015

I have a matrix table. These status can be changed by the user and I want to capture each change in database with out updating the earlier status

Pending
Activated
In PROGRESS
Submitted
Completed

Pending can be changed to submitted or completed. For one form there can be different status at different time. And each status must be saved in the database table. How can I design a table...

View 2 Replies View Related

SQL Server 2008 :: Database In Single-user Mode / How To Change It Programmatically

Mar 10, 2015

Recently we had multiple production failures because one database was in single-user mode. I am trying to recreate this scenario to write a script that will kick out that connection that was holding database in single-user.In SSMS window 1 I run the following code:

use master
go
alter database test
set single_user
with rollback immediate

[code]....

Yes, it shows one record, but the database name is master, not test. And indeed, I run it from the context of master. Also tried sp_who, sp_who2, sys.dm_exec_requests - nothing works. For dm_exec_requests it shows nothing because it does not run at the current moment.Any other solutions to catch this SPID with a script?

View 5 Replies View Related

SQL 2012 :: Indexed View On Replicated Server Is Very Slow

Sep 10, 2014

So we got ServerA.dbA and ServerB.dbB and looks like nobody thought about that MVew. IT works thru linked server now, so surely enough it sucks..

Then even more: we got piece of DW on ServerRep with replcicated pieces of ServerA and ServerB, how it works I asked: "Don't worry man, we took care of everything, go directly to ServerRep for everything..."

And I see that our MView sucks even deeper, practically 0 performance, I think what going on it's still hit that linked server between ServerA.dbA and ServerB.dbB on background.I still can use it on ServerRep WITH NOEXPAND hint, which means it was properly defined...

Can we have that scenario at all? Or we can replicate all Tables on ServerRep and then define/redefine this view directly on replicated server ?

View 4 Replies View Related

SQL Server Admin 2014 :: Certain Rows Not Replicated Yet Replication Was Not Broken

Oct 24, 2013

We had an issue recently where a (transactional) replicated table was replicating data as expected.

Then about 30 or so rows in the source table were not in the destination table, but other rows created after those 30 rows were replicated.

We have pretty much confirmed that users did not delete those rows.

Unfortunately we had to resolve the issue quickly and so blew away & recreated the subscription so a lot of evidence is probably gone from the crime scene.

We cant figure out what could cause 30 rows not to be replicated, yet leave replication operational.

View 1 Replies View Related

SQL Server 2008 :: Adding Column To Existing Replicated Table

Feb 9, 2015

I have a scenario where I need to add a blank column to a table that is a publisher. This table contains over 100 million records. What is the best way to add the column? In the past where I had to make an update, it breaks replication because the update would take forever as jobs are continuously updating the table so replication can't catch up.

If I alter a table and add a column, would this column automatically get picked up in replication?

View 0 Replies View Related

SQL Server 2008 :: Identify Which Indices Are Replicated - Transactional Replication

Feb 20, 2015

Is there a script to find which non-clustered indices are replicated? I know i can do this easily through GUI , having a script will make my life much easier ....

View 0 Replies View Related

Move Replicated Database

Sep 2, 2005

Hi,
We have to move two of our servers in US hosting SQL Server 2000 database to different location. These servers are clustered using MSCS and uses SAN to store database data. The database on this cluster hosts publisher and distributor. The other two sites in Europe host updateable subscribers. We are using transactional replication. The downtime will be around 24 hours during which servers will be physically moved from one location to other. During this time we will keep the two subscribers running and let the changes queued on subscribers. I have listed following steps based on my limited knowledge of SQL Server. Could somebody please advise if this approach is valid and if I have missed any steps?

1. Make sure no users are accessing database
2. Backup database (In case of emergency need)
3. Stop snapshot, Log Reader, Queue Reader and Distributor Agents
4. Stop SQL Server Service and SQL Agent
5. Take OS backup
5. Shutdown the server
6. Ship the servers and OS backup to new location
7. Setup servers at new location and restore OS backup
8. Start SQL Server Service and SQL Agent
9. Start agents listed in step 3

Regards,
Nilesh

View 6 Replies View Related

How To Move Replicated Database?

May 8, 2006

I got Server A with 30 Databases and I was asked to move 30 databases to Server B…
But server A is having 2 databases as Publication and Distribution to two different servers….. and Server A is a subscription for 6 Databases from other servers….

Once I move the databases from Server A to Server B…… what is the best way to get the Replications too…. I mean Server B should have 2 Db’s as Pub & Distr and 6 Db’s as Subscription…

Is there any way I can script it out in Server A and run the same script in Server B with some modification…. so that the Replication work…..??

I have Jobs and Maintenance plans…. Which should also move from Server A to Server B…. I know using DTS...... is there any better way..??

Please some one give me ur suggestion on this…

Thanks
Bob

View 6 Replies View Related

Resotring A Replicated Database

Mar 3, 2004

I have a database A on server_1 that is being merge replicated to database B on server_2 which is production a box

NOW

I want to restore database A on server_3 that is being merge replicated to database B on Server_4 which is test box.

How about do I do that with replication being involved?

Thanx

View 2 Replies View Related

Alter Table In Replicated Database

Apr 26, 2003

How can I do an alter table in some table that replicated database ?
I got the error message when I try !

View 3 Replies View Related

Backup/Restore For Replicated Database

Jul 5, 2006

Hi, I have setup a merged replication on two server. Server A contains the Publisher and the Distributor database and Server B contains Subscriber.

If the database at the Subscriber got corrupted. I am thinking maybe i can 'restore' the subscriber database by resynchronising the data from the publisher to subscriber.

But what happen if the Publisher database failed? How should one restore the publisher database and then restore the replication setup?

What will be a good backup/restore strategy for such a setup?

View 1 Replies View Related







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