6
votes
1answer
59 views

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data ...
2
votes
2answers
646 views

Simplest way to shrink transaction log files on a mirrored production database

What's the simplest way to shrink transaction log file on a mirrored production database? I have to, as my disk space is running out. I will make a full database backup before I do this, so I don't ...
0
votes
1answer
84 views

MS SQL Hardware Configuration

About to order a replacement mirrored database pair to drive our multi-user web applications and looking for some guidance on some aspects. I have read various feedback on other posts but finding it ...
0
votes
1answer
51 views

Two principals in a SQL Server 2005 Mirroring setup

We've recently changed our mirror setup to include a witness so we support automatic failovers, yesterday in our datacenter they had some planned maintenance to some of the network supplies (i believe ...
2
votes
1answer
224 views

How do you setup mirroring in SQL 2005 with IP addresses for server names? (EC2 / no AD)

I am setting up a mirror in Amazon EC2 and I have all servers with dedicated IPs. When i try to connect my mirror to my principal with the following command alter database DB_NAME set partner = ...
0
votes
1answer
108 views

Unusual CPU usage on SQL 2005 Mirror

We are running a mirror on SQL Server 2005 SP2 Enterprise edition for a few databases. These are running on VMWare with Server 2008 R2. On the mirror server, I see the CPU go up to 50% for about a ...
3
votes
1answer
90 views

Script to mirror MS SQL Server databases between 2 servers

I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others) One server is production and the other is primarily there as a backup. We're rebuilding all of ...
0
votes
2answers
890 views

Index rebuilding on mirrored database sql server 2008

I have a mirrored database in full safety mode on sql server 2008 R2 Standard Edition. I want to create a maintenance plan to rebuild and reorganize the indexes on a weekly basis. Maintenance plans ...
0
votes
0answers
398 views

sql mirroring error SQL Server 2005

I have 2 db's that have been happily mirroring each other for months. Today both DB entered the state (principle, disconnected). I am unable to stop the principle(db1) from mirroring. Error Msg ...
2
votes
1answer
64 views

Installing two versions of MSSQL on a production server?

We've just provisioned a second dedicated server so we can use database mirroring for high availability. The existing server uses MSSQL Express 2005. We have MSSQL Web 2008 and want to minimise the ...
3
votes
2answers
2k views

When successfully configured SQL Server for database mirroring, got an error saying it's not configured for database mirroring

I need to replace the old database in our test environment with a fresh copy of the production database. The test environment is actually comprised of two instances of the test database, on 2 ...
1
vote
3answers
104 views

Back-end SQL Server 2005 databases for website

We're migrating an existing IIS website + MS SQL 2005 database (on the same server) to a new test set-up. The existing set-up is too slow. I want one ISS server and 2 X MS SQL server 2005. One live ...
2
votes
1answer
407 views

Database Mirroring of SQL server

I have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now the production server is having principal ...
1
vote
4answers
1k views

SQL Server 2005 mirror database still in (restoring…) state

I just successfully mirrored the same database on two of our servers. The principal database state in Management Studio is: (databasename, Principal, Syncronized). The mirror database state is ...
3
votes
5answers
253 views

SQL Server 2005 dropping objects from DB on recovery?

SQL Server 2005 dropped a user from one of our mirrored databases after we recovered from a simple Windows-update induced restart of the machine. I checked and the login is not in the mirror server ...
3
votes
2answers
310 views

How long can a mirrored fail-over partner be offline before a full backup is required to re-synchronize?

Running a db mirroring in sql server 2005 sp2. There is SAN maintenance that needs to occur and i want to know if I stop SQL Server on the fail-over partner (mirror) and the principal keeps doing ...
0
votes
2answers
2k views

How can I improve SQL server mirroring performance

(reposted from stackoverflow) I've setup SQL server mirroring, using 2 SQL server 2005 standard editions. When the application is being stressed, response times increase 10-fold. I've pinpointed this ...
3
votes
5answers
826 views

Licensing a SQL DR box [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I'm tempted to use a DR server which holds a mirrored copy of a database to also perform test restores and integrity ...
2
votes
1answer
285 views

Database Mirroring Questions

I recently set up SQL 2005 database mirroring (synchronous with witness) on a couple of environments and enjoyed the experience but have a few questions: Does the transaction log chain get broken ...
1
vote
2answers
254 views

Programmatically Monitoring SQL Server 2005 mirror

Does SQL Server 2005 provide an interface that can be programmatically addressed to determine the health of a mirrored database? If so, does anyone have examples of how to do so?
3
votes
2answers
2k views

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...
0
votes
4answers
244 views

Slow loss of connectivity to SQL Server 2005

Client has a dangerously open instance of SQL Server 2005. VB.NET 1.1 connects to this from another server without problem. Turning on Windows firewall with port 1433 open to subnets only seems like ...