Issue: Index creation is taking longer time than the usual timing, there were no changes on the SQL server and the server. All of the sudden on most...
Hi, I use the below script to take litespeed backup and restore. Even though if i mention the STATS parameter i dont see the status during the backup...
I ran a rebuild index on 4GB size databases, after the rebuild index the database has grown upto 24GB. Only the data file has grown bigger. when i...
Can some one provide me the script for xp_servicecontrol undocumented storeprocedure. Or do we have any procedure to verify the status of SQL...
I have a share drive mapped as F to one of the servers using a specific login account. I am able to access the mapped drive in command prompt using...
On one of my SQL server 2005, tempdb has grown upto 35GB and its still growing up. tempdb has 34GB as unallocated free space, so i tried to shrink...
Is it possible to restore a SQL server 2005 database on SQL server ? I took the backup 2005 database by changing the compatability level to 80 and...
I have SQL server 2005 with SP1 running on windows 2003 server with 32GB of RAM. Right now my SQL server is using 30.5GB of RAM. I want to restrict...
Hi, Below is my SQL server configuration. Windows 2003 enterprise. Two SQL server instance are running on it. Physical Ram is 34 GB The memory...
I am facing the below error in Event viewer. Please find below the one of the error message from EventViewer on this server. Event Type:...
Separate names with a comma.
