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...
In your reply you mentioned about "Replication or any open transactions" what happens DBCC SHRINKFILE issued on Database involved in Replication or...
Thanks for your reply, do i have to run any kind of login scripts.
Thank you for your all replies, i appreciate that. i missed to note earlier in my earlier question. that my system DB are on Drive C: & only User...
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...
i have gone thru that but as this server as only 26 Database & i see that -g switch used above 1000 Database for SQL SERVER 2000. So you meant to say...
Above link is not helpfull as my server is on latest Service packs 4 & OS 2003 SP1
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....
Correct me if i am wrong. DBCC USEROPTIONS doesn't show default or current Isolation Level. Set Option Value...
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...
Full recovery model
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...
Thanks it helped. but the issue is on SQL SERVER 2000 & reinitializing is not helping. thats why i am planning to drop & re-create Subscription. but...
the link you posted is not helpfull, as it is taking no where. quote:Originally posted by LuisMartin Check:...
Separate names with a comma.
