If you kill a process (from Management studio or using t-sql KILL ) system has to rollback the transaction to get the database into a consistant stage. There...
Dear Deepak, we also faced the same issue on sql 2000 and solved by restarting sql agent. Best Regards Sunil John ... From: Madhu K Nair <madhuotp@...> ...
Dear all, We have database on one machine, unfortunately the C:\ drive of the machine got corrupted and the admin formated the drive, the db was on D:\ drive....
Hey Sunil, attach will work only if the sql server gracefully shutdown. you could try this http://www.nigelrivett.net/RecoverCorruptDatabase.html or contact...
Dear Gigme, Thanks for ur reply, the link helped to certain extents. What i did was:- Created a new db with the same name. stoped the server Replaced the new...
Thanx i got the soln and developed for above but here ppl just talk they donot give soln Madhu K Nair <madhuotp@...> wrote: Hi Kuldeep, If you see my...
Thanks Sunil and Madhu for your response on it. Adding to my below problem. The job used to hang every day and takes no of days (i notices over weekend) to...
Hi, I have created SSIS package. Now i need to associate it with Job.How? Please help. Is anyone has document regarding this, please forward to me. Manish...
Here you go...have a look at this URL http://msdn.microsoft.com/en-us/library/ms139805.aspx Thanks, Kuldeep Manish Sharma <connect_manish@...> wrote: Hi,...
Kanchan, I have read this mail just now... For your kind information we all are here for open discussion, to share our thoughts about the problems and for...
If your job is hanging quite often then of course there would be some genuine problem. Can you please share the information listed below 1. Which SQL Server...
Thanks Kuldeep for your reply. Below are given the information you asked for: Yes the job used to hang regularly, while i tried the backup from EM it woked in...
Hi All, In one of my SQL Servers database is in E:\ drive the performance of the server is damm slow when i use performance counter and investigated i found...
Few quick suggestions.... 1. Apply latest service pack of SQL Server 2000 on your box. There are certain bugs / issues that are fixed every time a SP is...
A quick thought, put 'Average Disk Queue Length' performance monitor counter and analyze its value. If the value is most of the time more than 2 then you are...
Thanks Kuldeep for the quick response, i will check and update accordingly. Kuldeep Chauhan <mrkuldeepchauhan@...> wrote: A quick thought, put 'Average...
What is the size of the database? if it is > 100GB, try to add data file & keep it in different physical drive general suggestions Keep your log ,data file &...
here is the script for For read & write declare @db smallint set @db=db_id() select IoStallMS/(NumberReads+NumberWrites) as [ms/IO], S.filename, F.DbId,...
Kuldeep, I am totally convinced with your first point, we must always be at the heighest service pack, these servers are goona migrate with 2005 and there are...
Sometimes, after creating maintenance plan in sql 2000, if we modify the plan, it may not like it.Such cases i would try to recreate the maintenance plan.If...
Hi, Can any one let me know the query to find out the last password change date for all SQL logins on 2000 and 2005 versions With Best Regards, Prasanna.S ...
What kind of authentication mode you are using? If Windows authentication is used then your job is very easy as the underlying security policy of changing...
To clarify further even in SIMPLE recovery model the log size will not be taken care if your transaction is bigger, say if you are deleting nearly 5 lakh rows....
Login into the http://www.stanacard.com/en/H_step02.aspx Use Pramotion code:- 149700 Recommend StanaCard to friends and family. When they sign up and buy...
Dear Kumar, what is the solution if the ms/IO is high, when i run the below script i got the datafile 2.45ms and log file 10.71ms. please guide me on this,...
Issue the following command during the execution of the huge transaction to avoid the transaction log entry in the log file. Backup log databasename...
sunil run the following script and if the ms/IO should be less than 20ms. if it is then there is an I/O bottleneck on those files, so optimize by move those...
Dear kumar/all, I have checked with both the queries you have given and find huge difference. For the first query which is (IoStallMS/NumberReads) the output...
Hi, At the server, we see the following two errors in the application event viewer: Error: 0, Severity: 19, State: 0 SqlDumpExceptionHandler: Process 55...
Hi  We require an SQL Server Programmer to work for an MNC based in Hyderabad.   thanks and regards, Chandra  Meet people who discuss and share your...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
