Viewing 15 posts - 43,216 through 43,230 (of 49,571 total)
My guess is that you're truncating the tran log at some point. Look through the jobs and see if you have a BACKUP LOG ... WITH TRUNCATE_ONLY or BACKUP LOG...
November 12, 2008 at 12:32 am
They're produced by a crash of the DB engine or an illegal operation by one of the processes. The best thing to do if you're getting frequent stack dumps is...
November 12, 2008 at 12:30 am
sairams (11/11/2008)
Dear kshitij,Thanks 4 your reply...
Encrypting the confidential values means i need to do a mass work on the application..Is there any other better option
No better option. Encryption...
November 12, 2008 at 12:28 am
Have you created the endpoints? Can you connect from the principal to the mirror (try ping) and vis versa?
November 12, 2008 at 12:19 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic600933-146-1.aspx
November 11, 2008 at 2:37 pm
That's not SP2. 9.00.1399 is SQL 2005 RTM. The build number for SP2 is 3042.
Get SP2 and patch that server.
November 11, 2008 at 2:14 pm
Mohit (11/11/2008)
November 11, 2008 at 2:10 pm
You can use a case statement
SELECT CASE WHEN Value > 100 THEN 100 ELSE Value END FROm SomeTable
Can you post the query? Maybe someone can see something wrong with the...
November 11, 2008 at 2:05 pm
anvieph (11/11/2008)
Hi I tried this:-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T1400
Upgrade your SQL 2005 instance to Service pack 1 at least (preferably SP2 with CU 6 or...
November 11, 2008 at 2:03 pm
What does the entire of the event log entry read?
November 11, 2008 at 1:13 pm
blandry (11/11/2008)
November 11, 2008 at 10:29 am
Gaby A. (11/11/2008)
Easier to backup up full every day, and restore that full and all trans logs since then.
Depends what kind of maintenance window you have nightly. Last big DB...
November 11, 2008 at 9:59 am
shree (11/11/2008)
Users are having performance problems recently.I have planned it do at off hours .
it makes any problem while creating it because table has
Many forien key relations.
No problems. Number...
November 11, 2008 at 9:47 am
marianne.schillings (11/11/2008)
I have been reading this blog, and I am fearly new to SQL server DB. I am interested to know: SQL DB is on line and can you do...
November 11, 2008 at 9:46 am
Viewing 15 posts - 43,216 through 43,230 (of 49,571 total)