Forum Replies Created

Viewing 15 posts - 12,601 through 12,615 (of 39,963 total)

  • RE: Log backups while Full/Differential backups are running

    pdanes (4/23/2013)


    So a backup is a 'snapshot' from the moment in time that the backup process was initiated? And operations performed during the backup process do not get incorporated?

    When the...

  • RE: SQL server logs backup / reduction

    I would agree with Gail on the shrink.

    As for the size, there is no right size. If you are getting 2GB daily, 2GB might be fine for the size. I...

  • RE: SQL server logs backup / reduction

    Your service account may not have rights to that path. Not all accounts will. You'll have to determine if that's the case.

    If the db is recovering, you will have to...

  • RE: SQL server logs backup / reduction

    You don't need to map a drive. The service account for SQL Server logs into Windows. It can't see your drive mappings when you've logged in with RDP.

    Instead, run the...

  • RE: SQL server logs backup / reduction

    You don't need to take anything offline to run a backup. If you take the database offline, you can't run a backup in SSMS.

    As far as the mapped drives, the...

  • RE: SQL server logs backup / reduction

    If you're loading 1-2 GB a day in the log, I'd shrink the log to 5GB. Space is relatively cheap, and this gives you pad.

    You don't need a 140GB log,...

  • RE: SQL server logs backup / reduction

    aayushmail007 (4/22/2013)


    Thanks Steve and Gila.

    if this is organization data what would you prefer ?

    My first requirement will be to have space in drive

    2nd recover when needed

    Those are not the...

  • RE: Log backups while Full/Differential backups are running

    Jeffrey Williams 3188 (4/22/2013)


    GilaMonster (4/21/2013)


    Let's see... what happens when we have a 6-hour full backup duration and a 15 minute data loss SLA and log backups don't run during that...

  • RE: SQL server logs backup / reduction

    My thoughts:

    If you are updating this once and day, and it's your database, important, but not affecting others, here's what I'd do.

    Change the database to simple mode. With updates once...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/22/2013)


    Steve Jones - SSC Editor (4/22/2013)


    Brandie Tarvin (4/22/2013)


    Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/22/2013)


    Steve Jones - SSC Editor (4/22/2013)


    I know Brandie will like this, and perhaps others. My 14yr old asked if he could go to Comicon in Denver with his...

  • RE: Are the posted questions getting worse?

    I know Brandie will like this, and perhaps others. My 14yr old asked if he could go to Comicon in Denver with his friends.

    Now I'm thinking I might need...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/22/2013)


    Hey guys, I need your help please. On Wednesday we're having a "bring the kids to work day" and I'm helping out. I've been asked to "train" the...

  • RE: Print View

    Thanks. I've sent this to our team and we'll discuss it.

  • RE: A Billion Transactions

    Gary Varga (4/22/2013)


    I also think that we are going to have learn to throw away more data too. This will probably be a rough road in data management. Those of...

Viewing 15 posts - 12,601 through 12,615 (of 39,963 total)