Viewing 15 posts - 46 through 60 (of 83 total)
You can also use database mirroring to move the data to another server, then run an hourly database snapshot to report off of.
March 28, 2011 at 6:16 am
FYI - Compression is now available in Standard Edition in R2 - yay!
One thing that annoys me is that SSRS consumes a whole license if you put it on it's...
March 25, 2011 at 5:50 am
I think that's a reasonable approach. That's typically how we have done it in the past.
March 24, 2011 at 7:38 am
Make sure that the same account that you were using to connect to SQL Server to do the detach is the same account you use when you log on to...
March 24, 2011 at 7:30 am
What is the best way to copy the backup file from the Live server to the Test server? We do not want to copy it across the network if possible.
Thanks,
George
If...
March 23, 2011 at 6:40 am
jimmy.liew (3/23/2011)
May need your advice on the correct to failover a database mirroring in SQL Server 2005/2008.
Kindly advice which is the correct method as below:
Method 1:
--Run on principal
USE master
GO
ALTER...
March 23, 2011 at 6:26 am
Hello,
If you are running SQL Server as a domain account, you must grant login access to both servers.
ServerA <--> ServerB (mutually authenticate)
Next, you must grant connect on the...
March 22, 2011 at 5:45 am
Ralph Thomas (3/16/2011)
From:http://msdn.microsoft.com/en-us/library/ms366349(v=sql.90).aspx
On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because...
March 16, 2011 at 11:58 am
I suspect your problem is your network - because you mention that it randomly works. What is the latency between the Principal and the Mirror? Try using ping -l 65000...
March 15, 2011 at 6:04 am
After shifting to a domain service account, you should also register the SPN in Active Directory using the setspn utility so that SQL uses Kerberos. Here is an article that...
March 14, 2011 at 5:57 am
Yes, you can do this.
CREATE ENDPOINT [mirroring]
....AS TCP (LISTENER_PORT = 5022, LISTENER_IP = (XX.XX.XX.XX))....
This is a good idea for 2 reasons: 1. Mirroring traffic does not compete for bandwidth...
March 11, 2011 at 6:17 am
Yes, we have used mirroring for disaster recovery purposes for many years. It works great even over a WAN.
March 9, 2011 at 5:48 am
If you are on 64 bit, you should be ok mirroring 50 databases. The limit we found on 32 bit was around 40.
March 8, 2011 at 6:09 am
We monitor and send alerts on errors with Severity level 17 and higher, plus 823/824 IO Failure and 825 and 832. In addition to Buffer Cache hit ratio, another one...
March 8, 2011 at 5:50 am
There are several ways to monitor mirroring.
1. Use Database mirroring monitor (right click on the database > launch database mirroring monitor)
2. Look at the Windows perfmon counters. If you...
February 23, 2011 at 6:24 am
Viewing 15 posts - 46 through 60 (of 83 total)