473,394 Members | 1,371 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Master database

Ray
Once a master database is moved to other location, it becomes a replica.
Can someone advise why it happens and how to change it back to master
database.

Thanks,

Ray
Nov 13 '05 #1
2 2422
On Mon, 17 Oct 2005 20:57:39 +0800, "Ray"
<No****************@GMail.com> wrote:

This happens because you moved it.
Tools/Replication/Recover design master.

-Tom.
Once a master database is moved to other location, it becomes a replica.
Can someone advise why it happens and how to change it back to master
database.

Thanks,

Ray


Nov 13 '05 #2
Ray
Tom,

Many thanks for useful advice.

Ray

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:72********************************@4ax.com...
On Mon, 17 Oct 2005 20:57:39 +0800, "Ray"
<No****************@GMail.com> wrote:

This happens because you moved it.
Tools/Replication/Recover design master.

-Tom.
Once a master database is moved to other location, it becomes a replica.
Can someone advise why it happens and how to change it back to master
database.

Thanks,

Ray

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Moti | last post by:
I have SQL server 2000 which recently crashed. I try to recover it and found out that the Master database is corrupt. I never backup my server using inline sql backup nor any third party backup...
1
by: Karim | last post by:
I installed SQL Server, created a database for a sql server user and noticed that the user has access to the master database even though the checkbox for master database for the user login is not...
2
by: Moti.Ba | last post by:
Hello, I need to restore the Master DB in my SQL 2k server (with sp3). The problem is that i don't have SQL backups of this file I only have general backup of the entire c:\ drive i made using...
3
by: Mark C | last post by:
I have a unbound form with a tab control with four tabs in an Access 97 database. On each tab I have a sub form each form on the sub forms is bound to its own table. Each table has a field that can...
1
by: LilC | last post by:
I'm creating an application that has a standard layout for all pages. The information that is displayed in the layout will be dynamic based on the user that is logged in. Thus when a page is...
0
by: Managed Code | last post by:
Hello All, Here is my issue and thanks in advance for any assistance. I have a base page with a dropdownlist that fires an event with the selected index. The content page catches the event and...
1
by: vonlinkerstain | last post by:
Hi all, I made a horrible thing this week. I have an script that delete all data from all user tables, and I run it in the master database. After this I couldn't access the metadata from the tables...
6
by: brian.j.parker | last post by:
I inherited an application (or two) that run on SQL Server 6.5, which I haven't used in years, and am having a problem. I get the error: ...
1
by: Parasyke | last post by:
I have a dilemma. I have 20 branch offices that need to be able to upload their unique copy of all their backend tables to a master database at a corporate office. I really need only a copy of...
1
by: Parasyke | last post by:
How can I, without using Replication technology, append a table in my master database from data in another database? I have several field offices with sales data that I want, on demand, to append...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.