Viewing 15 posts - 166 through 180 (of 501 total)
Glad to help and good luck on your deployment.
April 27, 2011 at 4:10 pm
You should keep the witness server in the same site as the principal database. So in your situation a witness for server A in NY and a witness for server...
April 26, 2011 at 3:39 pm
Not a bad idea to pause before the reboot but it shouldn't be necessary if you are not using a witness.
From BOL:
http://msdn.microsoft.com/en-us/library/ms179344.aspx
When the partners are connected and the database is...
March 23, 2011 at 4:42 pm
If you are using a witness server it will cause a failover of the databases. You can prevent this by pausing mirroring before the reboot and then resuming mirroring after...
March 23, 2011 at 4:30 pm
Sounds like there might be a firewall between the remote PC and the SQL 2005 machine. Can you telnet from the remote PC to the SQL 2005 machine on port...
March 17, 2011 at 3:35 pm
OLAP - 32 cores 128GB Windows 2008R2/SQL 2008 12TB of page compressed data
OLTP - 24 cores 128GB Windows 2008R2/SQL 2008R2 1TB of page compressed data
March 11, 2011 at 4:22 pm
Not sure about finding the login without additional traces already running but from the SQL Server logs you can tell which host killed a SPID. If you can trace the...
February 23, 2011 at 3:49 pm
Are they a member of a server role such as sysadmin?
February 14, 2011 at 3:56 pm
I use backup compression for log shipping between 2 SQL 2008R2 servers. I don't see any downside to it.
Faster/smaller backups, copies and restores. I suppose there is slight CPU overhead...
February 4, 2011 at 2:43 pm
Did you add the network path to the backup folder?
January 28, 2011 at 4:08 pm
From the SQL 2008R2 Security Best Practices white paper under "Authentication" :
Authentication, both Windows accounts and SQL Server-specific accounts (known as SQL logins) are permitted. When SQL logins are used,...
January 28, 2011 at 3:55 pm
I would recommend testing it out on a development or test system. A side by side migration is fairly straight forward and provides a quick rollback plan. The article below...
January 28, 2011 at 3:00 pm
Elliott Whitlow (1/7/2011)
As far a sproc restore, I'm taking the position that if you have to go to the backup to get source code, that code control is likely an...
January 7, 2011 at 4:39 pm
A big win for Litespeed is the ability to do object level restores. Restoring a single table or proc is much easier than restoring an entire TB sized database and...
January 7, 2011 at 4:20 pm
Viewing 15 posts - 166 through 180 (of 501 total)