Forum Replies Created

Viewing 15 posts - 43,336 through 43,350 (of 49,571 total)

  • RE: Managing Transaction Logs

    Anirban Paul (11/4/2008)

    When will that book will be published? Please inform us. 🙂

    I don't know yet. Also, not sure how much I'm supposed to say about it.

    I'm only writing...

    November 5, 2008 at 12:06 am

    #894071

  • RE: Database in recovery mode

    balbirsinghsodhi (11/4/2008)

    It did not say anything other than blocking. Let's say if you cannot connect sql server then how should we trouble shoot the issue. where to look for the...

    November 4, 2008 at 11:58 pm

    #894070

  • RE: Defragmentation in 2005 vs 2000

    DBADave (11/4/2008)

    I think people use different terms for external fragmentation. It occurs when extents are not contiguous. Check out these links for a better explanation.

    Extent fragmentation is what...

    November 4, 2008 at 11:57 pm

    #894069

  • RE: Msg 62309, Level 19, State 1, Line 1 on Litespeed RESTORE

    Jayakumar Krishnan (11/4/2008)

    The CHECKDB executed and there is no consistency errors on the DB.

    That's good! It may be that the backup was damaged, or it may be that the destination...

    November 4, 2008 at 11:53 pm

    #894068

  • RE: Query is in suspended mode

    balbirsinghsodhi (11/4/2008)

    I think it's not a bad idea to start some kind of web site and help people by charging some money.

    What, like this one? Except of course...

    November 4, 2008 at 11:52 pm

    #894067

  • RE: Query is in suspended mode

    balbirsinghsodhi (11/4/2008)

    Hi Gail..

    Here is the attached actual execution plan.

    Thanks. I'll take a look at it later in the week. I've got a lot of things to get done in the...

    November 4, 2008 at 11:48 pm

    #894066

  • RE: transaction logs

    Lynn Pettis (11/4/2008)

    WHY is everyone so eager to shrink their databases transaction log files?

    Beats me. I'm wondering why people are so eager to throw away log records and expose...

    November 4, 2008 at 6:40 pm

    #893994

  • RE: Help with Query

    htt (11/4/2008)

    Table definitions is in the sample data. I am just looking for a query to produce a result that look like the result when you run the second...

    November 4, 2008 at 6:33 pm

    #893991

  • RE: Backup

    SQL 2000 or SQL 2005? This is a SQL 2005 forum.

    If SQL 2000, was there a full or diff database backup occurring at that time?

    November 4, 2008 at 5:48 pm

    #893984

  • RE: Msg 62309, Level 19, State 1, Line 1 on Litespeed RESTORE

    Jayakumar Krishnan (11/4/2008)

    2008-11-04 16:08:39.130 spid74 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:11748607; actual 23:5220531). It occurred during a read...

    November 4, 2008 at 5:47 pm

    #893983

  • RE: Defragmentation in 2005 vs 2000

    What do you mean by 'external fragmentation'?

    November 4, 2008 at 5:44 pm

    #893982

  • RE: How actually the restore works?

    Mani (11/4/2008)

    Well, when I restore full backup(z:\Backup\SPProd_Cfg.bak at 1am), the mdf file of SPProd_Cfg.mdf will be replaced with the newly restored .bak file and creates the new mdf file?

    Yes,...

    November 4, 2008 at 5:41 pm

    #893979

  • RE: Msg 62309, Level 19, State 1, Line 1 on Litespeed RESTORE

    What does the following do?

    RESTORE DATABASE DATABASE1 WITH RECOVERY

    Is there anything interesting in the SQL error log from that time?

    November 4, 2008 at 5:37 pm

    #893975

  • RE: Help with Query

    Table definitions and expected output please.

    November 4, 2008 at 5:37 pm

    #893973

  • RE: transaction logs

    clive (11/4/2008)

    I normally use this method:

    1. backup log Pubs with no_log

    2. dbcc shrinkfile(Pubs_log, 100) -- shrink log file

    3. dbcc updateusage(Pubs) ...

    November 4, 2008 at 5:31 pm

    #893971

Viewing 15 posts - 43,336 through 43,350 (of 49,571 total)