Forum Replies Created

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

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

    Joy Smith San (3/20/2010)

    Granted the space will not be returned unless you shrink it

    Returned to what ? That sapce will not be used further.?

    Returned to the OS. Freed up 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.

    March 22, 2010 at 4:42 am

    #1137482

  • RE: SQL 2005- job status in email

    See my post on page 1 of this thread. Create a brand new job to run every X number of minutes (however often you want), then pull the data from...

    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 19, 2010 at 10:21 am

    #1136869

  • RE: transaction log restore question

    Thanks, Gail. @=)

    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 19, 2010 at 6:03 am

    #1136627

  • RE: Unable to full backup

    Ask SSC??? What's the URL to the post? I'm not seeing it in the SQL Server 2005 -> Backups forum.

    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 19, 2010 at 5:09 am

    #1136595

  • RE: transaction log restore question

    Paul,

    It isn't a silly question. Developers should not have that ability on Production. In fact, there should be a tight throttle on the # of people who do have production...

    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 19, 2010 at 5:07 am

    #1136594

  • 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

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