Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 9,726 total)

  • RE: Restoring a dropped table

    hammad772001 (6/15/2011)

    Hi John

    When I took the Database backup I also took the backup of Transaction Log. In case the MDF files are missing, how can we restore using a full...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:43 am

    #1338977

  • RE: Sql "incremental" Backups

    When referring to Windows Incremental backups (or Outlook Email system backups), the backup type backs up data. Since the Transaction Log backs up the SQL Server log, not the data...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:38 am

    #1338975

  • RE: Backup Duration

    gmamata7 (6/13/2011)

    In view history, it says 01:43:53 (1 hr 43 mins) and in the backup log, it says 3050.662 seconds (53 mins).

    Could you please clarify me which one is correct?

    Maybe...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:35 am

    #1338970

  • RE: How much disk free space to keep on drives and why?

    I prefer to know that I'm going to have at least 2 years worth of growth out of my free space. So I add more than enough to account for...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:32 am

    #1338966

  • RE: Procedure to determnine long running SQL in SQL stored procedure.

    Run Profiler or a server side trace. Most people prefer the later because it carries less burden on SQL Server. The GUI can cause issues.

    Do you actually know you have...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:27 am

    #1338963

  • RE: I am not able to login sqlserver through Network.that login is windows login ,But i am able to SQL SERVER SA login.

    kvr1985 (6/9/2011)

    GAIL i am waiting for your reply

    You do realize this is the worst way to post a question, right? Gail has a day job, just like the rest...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:22 am

    #1338955

  • RE: Database (In Recovery..)

    Do what Gail said about posting the error log. And you still haven't answered Grant's question, that I can tell. Why was the server shut down?

    You said you don't have...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 7:18 am

    #1338950

  • RE: Memory

    sqlfriends (6/14/2011)

    But the problem for my case is I already found some sql jobs are delayed for serveral minutes during the peak hour in the morning automatically by the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 6:49 am

    #1338929

  • RE: Are the posted questions getting worse?

    WayneS (6/14/2011)

    Craig, Trey and any others out in AZ... you'll okay with all those fires going on? (I know it's not that close to you'll, but smoke travels and causes...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 15, 2011 at 4:54 am

    #1338869

  • RE: Are the posted questions getting worse?

    Trey Staker (6/14/2011)

    @craig-2 -- Did you know that Brian Knight will be teaching a 3 day SSAS training class here in Phoenix June 21-23? I just found out...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 14, 2011 at 12:27 pm

    #1338602

  • RE: Memory

    sqlfriends (6/14/2011)

    And for the last statement:At last of the monitoring period, collect the output of DBCC MEMORYSTATUS

    This cannot be included in Perf monitor, shall I setup a sql job of...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 14, 2011 at 12:24 pm

    #1338601

  • RE: the server threw an exception [0x80010105]

    All,

    The OP has crossposted on MSDN forums and received an answer:

    http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/cee59a53-70be-4942-974b-6b1a0f96203f

    shinobigoh, did that response help you?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 14, 2011 at 12:20 pm

    #1338595

  • RE: PerfectDisk Vs DisKeeper

    Wow. You should be a sales person for Diskeeper.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 14, 2011 at 12:15 pm

    #1338590

  • RE: the server threw an exception [0x80010105]

    Google your error message. There are several potential solutions out there. Check the very first link that comes up.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 14, 2011 at 11:00 am

    #1338548

  • RE: the server threw an exception [0x80010105]

    FYI: Google your error message. A lot of posts came up with the same error.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 14, 2011 at 10:38 am

    #1338537

Viewing 15 posts - 5,821 through 5,835 (of 9,726 total)