Forum Replies Created

Viewing 15 posts - 8,116 through 8,130 (of 9,715 total)

  • RE: Hourly backups + Weekly full = Overlap = problems???

    It's funny. This subject came up last night at our local users group. I'd never heard of it before then. Now you guys are talking about it on this thread....

    Bulk-logged...

    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 11:27 am

    #1136179

  • RE: jobs are runinng long time (urgent )

    Who is responsible for the actual server, the physical box? Who installs the OS, monitors patch updates, and might install an anti-virus program on the box?

    This is the person 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.

    March 18, 2010 at 10:58 am

    #1136156

  • RE: transaction log restore question

    jorge.torralba (3/18/2010)

    I think the best solution for us will be database snapshots every 15 minutes. This comes with a price. Losing transactions between snapshots. But, restore time is just a...

    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 10:42 am

    #1136144

  • RE: transaction log restore question

    CirquedeSQLeil (3/18/2010)

    Brandie Tarvin (3/18/2010)

    ... (keeping in mind you first have to restore the full db to SQL 2005 and it will be upgraded).

    You only need to restore the Primary...

    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 10:37 am

    #1136140

  • RE: Hourly backups + Weekly full = Overlap = problems???

    Be very careful about using compression & encryption on your database backups at the same time. These two tools don't play play well together and can hose your backup files.

    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 18, 2010 at 10:35 am

    #1136138

  • 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

Viewing 15 posts - 8,116 through 8,130 (of 9,715 total)