SQL Server 2005 Mirroring – Client Redirection

I thought I had posted an article on this issue and have been saying so at my events, but no one has emailed me to tell me I haven’t!!!!!  Here’s what i thought I posted….sorry if anyone got frustrated looking for this (again i got this from the SQL 2005 Online books): To connect to…

0

Schema Separation in SQL Server 2005

I had some interesting discussion at my event in Elizabeth, NJ regarding how applications would work after the SQL2000 Server was upgraded to SQL Server 2005.  I had explained that applications would still work, based on the fact that the object owner name in SQL 2000 becomes the Schema Name in SQL Server 2005.  From…

0

Windows Server 2003 R2 Webcast Series

Windows Server 2003 R2 Webcast Series – Extend Connectivity and Control in Your Environment Did you know that there is a new version of Windows Server 2003 coming?  Did you know there are new features coming in Windows Server 2003 that will help you extend your connectivity and control your management costs?  Windows Server 2003…

0

SQL 2005 Index Size

Q:  In MS SQL 2000, there is a limitation of maximum length of index key to be 900 bytes. Would this limitation be revised to have it larger than 900 bytes in coming MS SQL 2005 release? A:  From the SQL 2005 CTP Books Online:  “SQL Server 2005 retains the 900-byte limit for the maximum…

0

Can I have more than 6 Archive logs in SQL 2005?

I was asked this at the Providence, RI event and didn’t think it could be, but I did find this that works for SQL 70 and SQL 2000.  I haven’t really verified it but I’m sure it would work with SQL 2005 either as is or with some minor modification. http://www.sqljunkies.com/HowTo/0DE35937-5475-4DC7-8490-C54A02143B24.scuk

0

How do I change the backup retention period in SQL 2005?

I was unable to answer this question at my Providence, RI event this week regarding changing the backup dataretention period.  Here’s the answer I got from where else but the SQL2005 Online Books: To set the backup retention duration In Object Explorer, right-click a server and select Properties. Click the Database settings node. Under Backup/Restore,…

0

Renaming SA in SQL 2005

I had been asked last week if you could rename the SA account.  I replied “No you can not, it’s protected.”  Oh how wrong can I be?  Apparently very wrong.  My illustrious colleague Matt Hester pointed me to a blog that has the exact procedure you need to follow to do this and improve your…

0

How to: Rename a Stand-Alone Instance of SQL Server 2005

One of the questions I was asked at an event last week was about doing a side-by-side migration to a new SQL Server 2005 machine from an old SQL Server 2000 machine.    Q:  Can i rename the new machine to have the same name as the old machine once I remove the old machine…

1

SQL Server 2005 Mirroring – "I lost my witness your Honor!"

Question 1: Does the Witness only monitor the SQL servers or does it handle any transactions? Answer 1: From the link below: “The witness server assists the principal or mirror in forming a quorum. If a witness server is present, a loss of either the principal database or the mirror database leaves two servers to…

1

SQL TechNet Events in NC, AL and GA this month…

I’ve done several events this month, Raleigh, Charlotte and Birmingham, AL and will be doing Atlanta on Thursday.  If you attended and had any questions that I was unable to answer at the event, please post them here so that everyone can see the answers. One question I was asked, which I wasnt sure of,…

0