Hello, I have an account on a SQL 2005 server that consultants created 2 years ago. I don't seem to have the password for this account. I need to...
UPDATE: The AVG. DISK QUEUE LENGTH is 100% each time I run any queries.
The size of the DB is ~3GB I am only running running rebuild indexes and update stats on the both servers at this time and the time is almost double....
No. The application performace was horrible and the vendor said it was due to 64-bit. But we just built the 32 bit environment and have the same...
Thanks Atul and Luis. We decided to reinstall the app and migrate the data on the 32-bit version of the DB just to be safe.
Hello, I just built a server with following configuration: WIN 2008 64-bit SQL 2008 64-bit I need to move a DB that was created on the above server...
Preethi, Thanks. This is the information I was looking for. I have already checked for data corruption and no corruption. I will look through these...
Hello, I have a SQL 2005 SP2 server on Windows 2003 SP2 server. I have a backup job that seems to be running at 12AM every night but I do not see...
Thanks for the explanation. This makes sense now. Appreciate the quick response.
Thanks Rohit and moh_hassan20. I appreciate all your help and quick responses. Our expectable DR policy is to go back to previous night backup and...
Due to HD space constraints. I have increased it to 2GB as it grows about 1.5GB per day. I have also added a nightly job to backup tlogs. Thanks...
The files are set for autogrowth by 10% restricted to 1GB MAX. The issue is that the .MDF file only gets updated once a day while .LDF gets udpated...
I have an issue that I have not seen before. I am a beginner with SQL server so I have tried what I know but no success. I have SQL 2005 SP3...
Separate names with a comma.
