Interesting. I know the SQL 7 and 2000 diagrams are not compatible with SQL 2005. If you deleted the diagrams and then tried to recreate them in...
Some quick thoughts... You can cluster SQL 2005 Standard Edition up to 2 nodes. Microsoft SQL Server does not load balance. You can do things in...
Interesting thread all! Just some additional things I thought I would share. I have frequently seen problems with the /3GB switch and large file...
I haven't done this myself, but this would seem to indicate that you can switch....
I wonder what effect it would have on things if I just added a compression step into the transaction log backup job and an uncompress step in the...
I have a small network pipe between the two servers and want to setup shipping. I do TLog dumps every 15 minutes. Overnight, I also do imports...
To provide further information on this, you can have a maintenance plan in addition to the shipping plan as long as it does not backup the...
Also, there are some FREE Microsoft E-learning training courses you can attend. See...
I think there may be more to this question. It is not difficult to add the new node to the windows cluster, but is there anything you need to do to...
oops, I did sp_addserver 'servername', local for step 2.
Thanks everyone for the information. I changed the port in the config manager. I also tried to rename the server (this is a lab environment and I...
I am thinking of doing a 1 box upgrade of SQL 2000 to SQL 2005. Instead of "upgrading" the SQL 2000 instance, I was going to install SQL 2005 on the...
It would be a good idea to run the SQL 2005 Upgrade Advisor against your existing SQL 2000 server. You can specify SQL scripts and SQL traces to...
Here is some scripting I did to help in automating the process... --Run this portion first. It is used to disconnect all users from the database...
Anyone seen this? http://www.microsoft.com/sql/howtobuy/faq.mspx Q. Do I need a separate license to run the SQL Server tools and analysis services?...
So I have a newly created maintenance plan that I would like to deploy accross multiple SQL servers. Anyone know of a way to export the plan (like I...
I did open a bug with MS and they did notice that the maintenance plan may report that it had completed while it was still executing. I assume this...
Very interesting. I suppose one thing not in many of the documents is to backup your Service Master Encryption Key after you install SQL. I would...
I was shipping one database (from a primary server with many databases) and decided to add some automation to the login transfer. Here are the steps...
Anyone play with manually creating Maintenance Plans? I am running the SQL 2005 Ent. Edition of the Sept CTP. I have done a couple test and have...
Separate names with a comma.
