I would like to know if there is any tool or code that can notify SQL DBA. I am looking for in particular as mentioned below. a> If Server is...
i have 5 database that got corrupted & error message is Torn page. after doing Hard Disk(HD) diagonistic there are some bad sector & finally decided...
How i can check/know what is the setting of my server Isolation Level.i have already used "DBCC USEROPTIONS" & see no information about isolation...
I have script that shrink the Transaction log on SUN & MON, but this i have to do for atleast 4-5 database on each server. instead of creating each...
I need help to write Transaction Log BACKUP JOB with the help of xp_sqlmaint. i try to gather require information, but some how it is not working. i...
SQL Server stops working by it self & it happened 3 times in this week. Asfter looking into the sql logs i am seeing this error message "SQL Server...
My transaction Log space is 32GB used. my total disk space 10MB. so how i can reclaim 32GB, as i cannot do any backup. CHECKPOINT is not helping me....
As default Isolation level is "Read Commited", but how to know whether default is changed or not.If it is changed then how i can see or get...
Can you please help me to see if my script is wrong, as i am scheduling my Database RESTORE Job. This Job will run once in every month. My schedule...
2 days back my Tr.Log file size was 200MB & now it is 14GB. So i did the backup of Tr. log & it as went back down to 50MB but my free space is almost...
I am going to install SQL SP-4 & i am curious to know if some how something goes wrong, then what is the backout plan. like can i un-install SP-4 or...
i am getting this error "The subscription has been marked inactive and must be reinitialized at the Publisher Error 21074" So i tried every thing &...
I need help to take best approach to resolve my log file. should i backup my log & then truncate LOG or there is better way. checkpoint is not...
In SQL SERVER 2000 i have 2(two) database at Drive D: & i want to move to Drive E:. How i can move from ISQLW.
[?]In my SQL SERVER 2000, my Database(DB) say for e.g. XYZ got corrupted getting message SUSPECT. So i created new DB with initial size of 5GB to...
My Application updates/insert Data on two different SQL Server (Server 1 & Server 2) with same table name. so if Server-1 table A as 25 transaction...
my sa password is "=C0DccNice1;="<br />when try to change it didn't change atall.<br />but when i took (<img src='/community/emoticons/emotion-5.gif'...
I have SQL SERVER 2000 name as ABC & i ahve another server which is name as XYZ. This XYZ is not SQL 2000 & as 250GB SPace. I want to Map drive to...
Separate names with a comma.
