Viewing 15 posts - 421 through 435 (of 451 total)
There could be a long running update or delete process. Break down to smaller chunk each time for the update or delete, this will help to reduce the T-log size.
Rebooting the...
July 16, 2007 at 9:58 pm
July 16, 2007 at 9:43 pm
Something need to think about more than backup operation itself:
Where (media) do you keep the backup? How many days backup do you need to keep on the local disk? Do...
July 10, 2007 at 1:06 am
I have used it for nearly 5 years (SQL server 6.5/7.0/2000/2005 and Sybase). Some features are pretty handy. But the history report part is not as good as they advertised. ...
July 9, 2007 at 11:26 pm
I will ask what challenges they are having, what are their current year plan/projects, 3-year or 5-year plan. Let's them give out more information.
July 9, 2007 at 7:47 pm
Not yet. Still looking for the resolution.
July 9, 2007 at 7:17 pm
Yes, I added the parameter whenever it required, "Group", then "addnode", even INSTALLSQLDATADIR = "S:\" which data should go.
The summary.txt says "Setup succeeded with the installation". But in the files\setup_*_core.log for...
July 4, 2007 at 9:26 am
Hi Sugesh, Thank you for dedicated help. Actually, I followed this link to rebuild sys DBs for both cluster and stand alone servers.
The section I followed for cluster is "To...
July 4, 2007 at 7:43 am
Thank you Sugesh for your suggestion.
rebuild = 1 or rebuiddatabase = 1?
I have rebuilt system databases on a stand alone SQL server using rebuilddatabase = 1 and restored recent...
July 4, 2007 at 7:19 am
Thank you for your reply. I need to rebuild system databases, not the entire sql server.
July 4, 2007 at 5:35 am
Thank you Sugesh. Do you mind telling me where/how do you get this information? Any link?
July 3, 2007 at 10:09 am
I found it. Thank you Jeff.
June 14, 2007 at 8:10 pm
Thank you for your reply. I am wondering whether it is up to 2,147,483,647 before overflow occurs as the ID column in sysobjects is int data type. I can not find...
June 14, 2007 at 12:42 pm
Performance test may need a full copy of the current production database assuming the data is valid for testing.
June 13, 2007 at 2:03 pm
Hello loner, everyone is a loner to a certain degree; or everyone has both good and bad moment. It is a fact of life/human being. Do not feel...
June 13, 2007 at 1:09 pm
Viewing 15 posts - 421 through 435 (of 451 total)