Mirroring Devices And Databases???

Oct 21, 1998

Hi all
I have a raid 5 NT server 4.0 with SQL 6.5 running.
I perform backups on tranlogs every hour and db`s every night.
I also have another 16G Nt server not raid 5.
Can someone tell me if it is possible to mirror a device or a database
into the regular 16G NT server from raid 5 server?
HOW???

HOw about database mirroring??

And also whats the best solution when it comes to mirrorring in NT server?

View 1 Replies


ADVERTISEMENT

Mirroring The Databases Without Witness Server?

Jul 10, 2013

I need to start mirroring the databases without witness server.

View 3 Replies View Related

Mirroring Large Amounts Of Databases

Mar 6, 2008

I have been looking into mirroring a large amount of small databases approx 150 databases.



As I understand this won't be feasible because of the way mirroring threading works, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=441900&SiteID=1



As I understand it for every database being mirrored sql will ping the mirror second, causing a network bottleneck?.

Also that the amount of threads generated for each mirrored database will cause also cause a bottleneck?



At the moment our database servers are under very little pressure and as an estimate use about 10% of the resources allocated to them such as CPU utilization, memory, disk IO and network. Our server hardware is Dual Quad core Xeons with 4 - 8 gig of memory and variety of 10k SCSCI raid configurations from raid 5 or 1,0 and sql 2005 32bit.



Ive done some calculations on the log file generation rate compared to network bandwidth there is more than enough network bandwidth.



Has anybody had any luck in mirroring many small databases?



My concerns is how much traffic is caused by the pinging of the mirror for each database?,

How many threads will the mirroring cause and what is the max amount of threads sql can handle?

How much memory will be consumed by each one of these mirroring threads?

View 1 Replies View Related

Mirroring Databases Connected Through A View

Oct 12, 2006

I have two databases db_A_primary and db_B_primary, both databases are on one Primary server.

db_B_primary has a View into db_A_primary.

Scenario: db_A_primary goes down and failsover to db_A_mirror on the Mirror server.

In this scenario when the View in db_B_primary is accessed will it automatically be redirected to look at the db_A_mirror database on the Mirror server?

Barry.

View 3 Replies View Related

Mirroring Multiple Databases On A Single Instance

Jul 7, 2007

Can someone explain what does this mean? This is from http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx



<quote>However, all these techniques for coordinating client redirection with a database mirroring have an important limitation. Database mirroring occurs only at the database level, not the server level. Be careful if your application relies on querying several databases on a server, or uses multi-part object names to query across several databases. When several databases reside on one server, and they are mirrored to a standby server, it is possible that one of several databases might fail over to the standby but the others remain on the original server. In that case, you might need one connection per database that you are querying, so that you do not attempt cross-database queries on a standby server where only one database is a principal and the remaining are mirrors.</quote>

Also I read somewhere that if one mirrored DB fails, all other mirrored DB should also be transferred to the mirror.

For example: Let's say Srv1 (principle) and Srv2 (mirror) and Srv3(witness) are SQL servers with only default instances. The SQL instance has 4 DBs (DB1, DB2, DB3, DB4) and all of them are mirrored to Srv2.

An ASP.NET application has four seperate connection strings like:
objConn1 --> Data Source=Srv1;Failover Partner=Srv2;Initial Catalog=DB1;Integrated Security=True;
objConn1.connect();

objConn2 --> Data Source=Srv1;Failover Partner=Srv2;Initial Catalog=DB2;Integrated Security=True;
objConn2.connect();

objConn3 --> Data Source=Srv1;Failover Partner=Srv2;Initial Catalog=DB3;Integrated Security=True;
objConn3.connect();

objConn4 --> Data Source=Srv1;Failover Partner=Srv2;Initial Catalog=DB4;Integrated Security=True;
objConn4.connect();

If DB2 failsover to Srv2 (mirror), why should all other DBs be failedover?

Thanks

View 10 Replies View Related

SQL 2012 :: Mirroring Multiple Databases On Single Instance?

Jun 10, 2014

I have to mirror 3 DBs on my sql server instance . I have restored there full backups and log backups on mirror.I have also created endpoints on principal and mirror using default ports 5022 and 5023.

know if i can use the same endpoint for the databases on principal instance ?

View 3 Replies View Related

My Structure Contains Mutli Databases In One Server, Will That Affect Mirroring ?

Mar 19, 2008



With the Synonym, I was encouraged to separate my db to several smaller dbs, like base,dynamic,static and security. Now I am trying to use mirroring, I see it may cause problem, I think I need mirror all them to another server. My question is when the server is down, will all db switch to mirror server in the same time? And one can manually set which db is the principal db, but in my case, it will not work if principal server of all four dbs are not the same.

Any thought?
thanks

View 3 Replies View Related

SQL SERVER 2005 Database Mirroring For Large Number Of Databases

May 30, 2006

I am trying to enable database mirroring for 100 database.
It goes error free till 59 databases (some times 60 databases) with the
status (principal, synchronized) on principal. on the 60th or 61st database
it gave the status (principal, disconnected). Also mirror starts acting
abnormal. connection to mirror starts to give connection timeout and it is
not enabling database mirroring on any more databases. I have SQL SERVER
2005 Enterprise with SP1 on the servers. witness is not included yet.

this are my test servers... i have more than 500 databases on my production
servers.

principal and mirror both are using port 5022 for ENDPOINT communication.

View 1 Replies View Related

SQL SERVER 2005 DATABASE MIRRORING For Large Number Of Databases

Jun 1, 2006

I am trying to enable database mirroring for 100 database.
It goes error free till 59 databases (some times 60 databases) with the
status (principal, synchronized) on principal. on the 60th or 61st database
it gave the status (principal, disconnected). Also mirror starts acting
abnormal. connection to mirror starts to give connection timeout and it is
not enabling database mirroring on any more databases. I have SQL SERVER
2005 Enterprise with SP1 on the servers. witness is not included yet.

these are my test servers... i have more than 500 databases on my production
servers.

principal and mirror both are using port 5022 for ENDPOINT communication.

All of the databases are critical and all must be included in the Database Mirroring.
so, after that I tried to implement database mirroring again......
System has 3 GB of RAM, SQL SERVER (Mirror) using 85 MB of RAM but still
giving this error while trying to enable database mirroring for 37th
Database.....

"There is insufficient system Memory to run this query"

WHY?

View 19 Replies View Related

Mirroring :: Async Mirror Setup For High Number Of Databases

Oct 27, 2015

I have a 2 node cluster having 4 cores each wherein having 3 instances of SQL 2008 R2 enterprise comprising of 60 databases, 20 on each instance. I need to setup mirroring for each of the databases to a secondary server having 4 cores and 3 instances.

What i understand is that in this case the mirror server will be providing max of 512 worker threads and the 60 mirror databases would consume 240 threads.

What all needs to be checked for looking into the feasibility of going ahead with a async mirror setup as mentioned above.

View 4 Replies View Related

SQL Server Admin 2014 :: Database Mirroring For Large Number Of Databases

Oct 27, 2015

I have a 2 node cluster having 4 cores each wherein having 3 instances of SQL 2008 R2 enterprise comprising of 60 databases, 20 on each instance. I need to setup mirroring for each of the databases to a secondary server having 4 cores and 3 instances. What i understand is that in this case the mirror server will be providing max of 512 worker threads and the 60 mirror databases would consume 240 threads.what all needs to be checked for looking into the feasabilty of going ahead with a async mirror setup as mentioned above.

View 0 Replies View Related

Database Mirroring | Can Witness Live On Mirroring Server?

May 3, 2008



Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)

For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?

View 7 Replies View Related

SQL Server With NAS Devices

Nov 30, 2001

Does anyone out there use a NAS device to place there database and corresponding images on?

View 2 Replies View Related

Backup Devices

Nov 4, 2000

hi, I usually back up the database to a file within the sql server box. then use a tape backup to back up the whole directory of the sql server in the d: drive.

Is this right way to do or there is a better way ?

Ahmed

View 1 Replies View Related

Backups And Devices For 6.5 And 7.0

Oct 20, 2000

I know that you need to create a device in 6.5 to do backups, but in 7.0, it seems to take care of this for you. However, there is still a device folder in the Management folder of version 7.0's console tree. Why would it be better to back up to devices, rather than anywhere else on the hard drive. Is there any way to easily schedule the deletion of backups on these devices? I know that with 7.0's Maintenance plans, you can schedule old backups to be deleted. But how do you do that for devices?

joe

View 2 Replies View Related

How Do I Create More Than 10 Devices In 4.2

Oct 31, 2001

How do I create more than 10 devices in sql server 4.2?

View 2 Replies View Related

No ResultSetGenerator On Devices?

Aug 14, 2007

Hello

I just tried to make a typed resultset from a SSCE v3.5 database, and recieved this message from Visual Studio:

"Typed ResultSets cannot be generated for tables on Microsoft SQL Server Compact 3.5 databases present on devices."

On the device, speed and low memory consumption is important. So it seems to me that this should be present ONLY on devices, because on the desktop we can just use the DataSet generator and not care about the overhead.
Anyway, ripped from what would have been a nice feature, the alternatives that comes to mind are:

1. Making my own resultset generator
2. Use typed DataSets
3. Derive from SqlCeResultSet and store the Field names in it, to build my own typed resultset class.

Any suggestions on what to do?

View 6 Replies View Related

Deployment On Devices

Jul 2, 2007

I asked about this a few mos ago over in the CF forum, but I'm hoping there's a better solution someone (Erik?) knows about here.



Is there a "standard" deploy script for SQL Server CE on devices? There doesn't even seem to be one in the d/l from Microsoft. During development, Visual Studio handles the installation of SQL Server CE on the device but deploying it on a device that isn't partnered to a dev box seems to be a matter of "just copy the cab file over".



While I'm willing to do that if I have to, it raises some other questions. How do I know if it's already there? How do I know if what's there is a newer version or not (and if it is, how do I abort this step)? How do I make sure some other application hasn't installed it already? Do I really even need to worry this?

I can just have my installer tell ActiveSync to put it on the device, but without knowing the above I'm kind of nervous about it.

View 4 Replies View Related

How Can I Get A List Of Back Devices

Apr 17, 2004

Hi All,,

I want to get a list of backup devices for a selected database
ex :
Northwind Database i need to get the list of back devices for this db
any one know how the query could be written

best regards

Wafi Mohtaseb

View 1 Replies View Related

Moving Backup Devices

Jul 28, 2000

I have taken backups and the backup devices are stored in C: drive and now i want them to be moved onto the other drive.So how can i do it without creating new devices and scheduling them again.

Any help would be appreciated.

Thanks,
Kris

View 2 Replies View Related

Initialising Backup Devices

Aug 11, 2000

i need to initialise the backup devices as the the backup files have grown so big thats its occupy hard drive space , each device is for @ day for all databse we use , what do i do

thanks


safac

View 1 Replies View Related

VLDB Across Multiple Devices

Sep 14, 1998

Hello

Does anyone have experience/advice with large databases (5-10 Gig)? If so, I was wondering about
performance/other benefits of spanning a large database across multiple devices (different disks). Would anyone
vote for or against doing this?

Suggestions...

Thanks
Tim

View 1 Replies View Related

Database On Multiple Devices

Jun 9, 1999

Hello All,

I want to know if it's possible for a database on multiple devices to put specific tables on specific devices?? and if this is possible how to do it??
Thanks for help

Mohamed hani

View 1 Replies View Related

Help Scripting Backup Devices

Jun 11, 2004

Hi guys

I am relatively new to SQL Server admin and I have been handed a task of creating backup devices for a particular SQL Server which has 204 databases.

Rather than go through and create Full, Incramental and Transaction Log backup devices for each database is ther anyway of doing the following

Create a script to go through and for each database name in 'sysdatabases'

create a folder e.g sqldataackup\%databasename%

and within each folder create a backup device called

%databasename%_full
%databasename%_inc
%databasename%_log

Also all these databases are running in 'Simple' recovery mode so obviously I need to change this to 'Full' to enable incramental and log backups - is this possible using the same script.

Hope someone can help as the thought of doing all of this individually for each database scares me silly!!! :)

Thanks in advance for any help

Hanley

View 5 Replies View Related

Backup / Restore Devices

Sep 28, 2006

Hi,

I am using EMS SQL Manager for SQL Server (www.sqlmanager.net). I am trying to learn how to do backups of my database.

I am up to this step -> http://www.sqlmanager.net/products/mssql/manager/documentation/hs21640.html

I don't think I actually understand what a device is, how it's created, where it resides, etc. I would like to backup my remote datasource to my local computer's harddrive.

Can someone please explain how this 'device' works and how I should set up?

Thank you so much for any help :-)

jo

View 9 Replies View Related

How To Display Reports In PDA Devices

Nov 6, 2007



Hi all,

Can somebody tell me how to display reports created in SSRS 2005 in PDA/mobile devices? How to connect to the PDA device?

View 7 Replies View Related

System Database Log And Data On Different Devices

Sep 17, 2001

I am new to SS7. We are planning to rearrange our system databases so that the logs are on one drive
and the data files are on a different drive. I found a really good white paper on this but just want to
verify that there is not a problem with doing this. In sybase there were some restrictions on doing this.
Any info you have would be appreciated.

View 3 Replies View Related

Resizing/ Shrinking Database Devices

May 3, 1999

Is there a way to shrink database devices in SQL Server 6.5 Other than dropping and restoring?

View 1 Replies View Related

EM Backup Devices Not Showing History..

Jan 12, 2000

Hello,
I am using EM to administer SQL 6.5 SP5a and have a few dBs that do not show backup history by expanding the backup device. The server is regestered as SA and MSDB does contain the the correct data in the sysbackuphistory table. MSDB DBCCs OK and other dBs show history. I manage multiple SQL 6.5 servers but this is the first time I've seen this and can find no info in the various KBs or NGs..
Anyone have any clues?
Thanks,
Jack

View 3 Replies View Related

Specifying Drive Letter For Data And Log Devices

Sep 25, 1999

Hi am new to this, I am doing some asp development and wanted to know if there is a way of specifying the drive to place log and data devices through sql statments or stored procedures.

--Tito

View 1 Replies View Related

Backup Devices Vs Files In SQL7

Jun 16, 2001

If I'm not mistaken, we can create a backup device OR backup files in SQL7. Can someone tell me which one is better?

View 1 Replies View Related

Multiple Devices For A Database - Advantages?

Nov 6, 1999

Just wondering - on a straight RAID 5 system is there any advantage, performance or otherwise, to splitting a SQL 6.5 database over multiple database devices? Or for simplicity's sake am I just further off creating a single device and manually extending it as the database grows?

Thanks
RM

View 1 Replies View Related

Backup Striping To Multiple Devices

Mar 29, 2004

Hello--

I am trying to backup a VLDB (800+gig) to multiple devices. I am using 4 disk drives. Assuming all devices have the same performance, should the 4 devices fill equally? (IE 200gig per drive) If so, what would might happen if one of the 4 drives only has 100 gig free with the other 3 having 300 gig free each?

Thanks for the help--
Jeff

View 2 Replies View Related







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