Hi, I have to copy 5 tables from Prod Server A to Prod Server B. I have scripted the table structure and created the tables in Prod B. I moved...
Hi, We have an optimizations job ( reindexing and data integrity check) set up to run every sunday afternoon for a database which is 300GB. And...
Hi, I just check the error log of a server. And one of the database has been showing up as starting constantly from the last 7 hours?? What does it...
HI, We have an application on MSDE 2000 version with SP4. the errog log is filled up with the message "" This SQL Server has been optimized for 8...
Hi I have been asked to give out an architectural review next week. I asked my boss , what do they need in specific. They said they wnat me to list...
Hi, We had a 7 production server's which are commmunicated through linked servers. Prod Server A is the main Hub Sever and the rest of the servers...
We have a task to do ... Our reporting server is divided in to 4 drives. C: and H:(data), I;(index), J:(logs), We are running out of space...
Hi , We are moving some specific databases from an existing server to a new installed server. I am thinking of doing it through detach and attach...
Hi, We had an issue, saying that the application guys are trying to save a record on the database , and they have a message saying ..... " OLE...
I have Table A which has some data yearly. We don't need the data before 2006. we have some data of years 03,04,and 05 which can be archived in to a...
We run a script to check the blocking issuesevery morning. We find a LogBack up job for master db runningeveryday. But the Backup team doesn't see...
I actually tried to run the DBCC showcontig on a table which has huge amount of data. I was waiting for around 5 minutes. SO, I went in to Activity...
Hi , Our company had an Reporting Server which runs very slow. I have put some counters and run System Monitor. And the results are below....
Separate names with a comma.
