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...
Thanks for the information. But that was for SQL 2005. I am on SQL 2000.rahul
Yes, we are re-indexing all the tables. As per the maintainance plan, it selects the database. So i Think it means its reindexing all the...
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, R U sure,, DO I have to use the upgrade advisor?? I am updrading it to SQL 2000 enterprise or standard version and not SQL 2005.
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...
HI, we are actuaally moving the indexes from one drive to another....So, is the same as creating them in to a file group and moving them to new...
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...
Thanks... They are in same sub network And what about the sys databases?? In what case,, do we move the system databases?? Do we have to do it in...
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,,,Actually it had a different error now.... " OLE IDispatch exception code 0 from Microsoft OLE DB Provider for SQL Server :[OLE DB Provider...
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...
Hi Adrian, Thanks for your help... Rahul
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...
Hi, In the proces info, It shows the database as master....does it mean the log backup for master or the back up job is run by master?? Becasue,...
Thanks for the information . Rahul
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...
Separate names with a comma.
