Forum Replies Created

Viewing 15 posts - 8,131 through 8,145 (of 9,725 total)

  • RE: Does the choice of Simple vs Full Rec. Model in non-system DBs affect tempdb space?

    mazzz (3/17/2010)

    They seem to be under the impression that changing the recovery models of their databases to Simple would have a positive effect on tempdb's growth.

    Do they know what tempdb...

    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.

    March 18, 2010 at 4:30 am

    #1135817

  • RE: Backing up a database with a Full Recovery Model

    shusta (3/17/2010)

    So would it be safe to say that each night when this Full Mode database is backed up it's backed up in its entirety including the data in 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.

    March 18, 2010 at 4:22 am

    #1135812

  • RE: Unable to full backup

    Starterm,

    Go ahead and start a new topic for this issue. Your problem seems to be different than the OP. The OP is having trouble making a File backup. Your problem...

    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.

    March 18, 2010 at 4:07 am

    #1135807

  • RE: transaction log restore question

    jorge.torralba (3/17/2010)

    Wasn't an app. It was a developer dba running a script that dropped the tables. Thought I could go back in time to a point without having tio restore...

    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.

    March 18, 2010 at 3:59 am

    #1135802

  • RE: Differential Backup Size

    Glad we could help.

    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.

    March 17, 2010 at 9:09 am

    #1135325

  • RE: jobs are runinng long time (urgent )

    Please answer the other questions so we know what you've checked and what you haven't checked. Otherwise, we can't help you further.

    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.

    March 17, 2010 at 9:07 am

    #1135324

  • RE: jobs are runinng long time (urgent )

    Your post is a little hard to read, so forgive me if I don't quite understand the problem.

    Is it just Maint. Plans that are taking forever or is it all...

    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.

    March 17, 2010 at 8:01 am

    #1135238

  • RE: simple recovery model Log truncation

    parthi-1705 (3/17/2010)

    I am having a 30 million records i need to delete 25 million old records with minimum log how it can be done there will be continues users accessing...

    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.

    March 17, 2010 at 7:57 am

    #1135235

  • RE: Restoring a db with more data files??

    That's actually a pretty good idea. The only thing to keep in mind, though, is that it will potentially stripe the data across the files or shove them all in...

    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.

    March 17, 2010 at 7:47 am

    #1135228

  • RE: Restoring a db with more data files??

    You do realize you can get better performance out of your DB if these LUNS really are separate drives (physically speaking) and you apportion out your tables properly, right? This...

    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.

    March 17, 2010 at 7:03 am

    #1135195

  • RE: Backup

    Check Books Online for the system tables. In the Index, type in "sys" (without the quotes) and it will take you right to them. BOL gives you the table names,...

    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.

    March 17, 2010 at 5:11 am

    #1135118

  • RE: xp_cmdshell copy option is not working

    Also, if the folder destination does not exist, xp_cmdshell will NOT create it as part of the copy, unlike several other windows programs which will.

    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.

    March 17, 2010 at 4:56 am

    #1135110

  • RE: DB backup error

    Usually when I get this error, another backup is actually running at the time. But it's only happened to me maybe two times, so "usually" might not mean anything.

    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.

    March 17, 2010 at 4:55 am

    #1135108

  • RE: Restoring a db with more data files??

    You can definitely add more files to the Primary Filegroup without a problem. The issue is moving the data from the existing file to the new file.

    The best way to...

    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.

    March 17, 2010 at 4:53 am

    #1135106

  • RE: Unable to full backup

    starterm (3/17/2010)

    I have backup of the database but it was taken before 3 months. Now if restore the file from backup to make it online, the updated values in 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.

    March 17, 2010 at 4:47 am

    #1135103

Viewing 15 posts - 8,131 through 8,145 (of 9,725 total)