This afternoon I'm going to changed the linked server security to what that does. The security context doesn't matter much to us as long as...
I decided to look at the windows user inside SQL that the services run under. The user is of course an SA, but under the user mapping it shows that...
Thank you, but yes I have already checked those. The owner of the job is the same user (the default windows login for the server and host). The...
While somewhat complex to explain we are running a custom program that was designed with 2 physical sql servers in mind via a linked server. This...
Hi, I have a SQL Server that has a linked server to itself. Two databases. I have a SQL job that runs a stored procedure that moves data between...
I would tend to agree with you, but I have tested from several 2003 and 2008 servers, and I think it is safe to rule out most of these items,...
Okay I did this test repeatedly again. I have attached two images. One is from a 2003 server and notice the total query time was 22 seconds. The...
I'm not really sure what else to say except this appears to be a problem with Windows 2008 R2. It isn't SQL Server and it doesn't happen with...
Well the remote machines of course are all different, but all the 2008 remote machines are slow, even the physical machine itself. The 2003 machine...
I have noticed a strange problem with SQL 2008 R2 that I can't account for. When I run a specific query on the physical sql server in question it...
I run it in the early Sunday AM hours as I always have and it takes about 4 hours to complete, I'm on a Raid 10 array with 28 fiber drive spindles,...
Thanks, I have already read this, but this doesn't help me. I have plenty of disk space and memory. I shouldn't have to run dbcc in an...
Hi, I have a large database, 2.7 TB. I have been running DBCC Checkdb on this database for years without issue. Suddenly the last few weeks, my...
Thanks for your reply. I'm probably not being very clear. I do not want a snapshot ever. My current db is about 2.5 terabytes. The new db I want...
I want to replicate all tables but without the data. There are around 75 tables. How do you start transactional replication without the initial...
I have a large database several terabytes in size. I would like to replicate only the new data that is being inserted or updated and not the whole...
What I mean by live servers is they are already in production with databases on them. I can't afford a lot of downtime to turn on clustering...
Hi, I need to implement an active/active cluster on two live servers. I am very reluctant to do this on live servers. How large of a risk is it...
Okay thank you. If the disk fails and I lose the log file, I will just have to re-create it.
Hi,I just realized today that I mistakingly put my SQL Server Transaction log on a raid 0 partition. I am not in a position to move the...
Separate names with a comma.
