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...
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...
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...
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...
Anyone seen a published security best practices for SQL2005? I am looking for something simular...
I have heard somewhere that you can improve query performance by not allowing nulls at the column level if it can be avoided. It involved something...
I have a client with 7 databases that range from 300M to 15G in size. These databases do very little transactions (less than 100M total in...
I had log shipping running for a couple days secussfully. It runs every 5 minutes. Between 9pm and about 11pm, we update the DB with significant...
I was reading up on how to transfer SQL logins for log shipping at http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx. I...
I have been testing log shipping and everything appears to be working well. I plan to monitor shipping with a 3rd party agent that will check SQL...
I have a client that would like a Disaster Recovery site (East coast and West Coast facilities with good connectivity). They would like to have less...
I am trying to alter large numbers of databases and I wanted to insert a variable into the alter database command. I keep getting errors. ---...
When I attempt to run the extended stored procedure xp_msver, I get the following error: Msg 50001, Level 1, State 50001 xp_msver: Unable to...
I have a SQL7 server running on NT4 (ick, I know). It is a fairly busy server with ~30 users normally. The CPU has been spiked around 100% and the...
I have a 500G data warehouse on SQL2000. It is made up of 4 data files on separate arrays and the TL on a 5th array. The application running...
I am migrating from a SQL2000 stand-alone server to a SQL2000 cluster. The current SQL stand-alone has the following: 150+ Databases 10 backup...
I am looking for a catch all SQL job to ensure all my user databases are being backed up. I have multiple SQL servers to monitor this way and can...
Sorry if this isn't the correct forum, but I have seen a very high bluescreen rate when applying the MS04-011KB835732 patch on cluster nodes with...
So I have read that Windows 2003 Enterprise Edition supports up to 32G of memory using AWE. I also read that for over 16G, you cannot use the 3G...
Separate names with a comma.
