Forum Replies Created

Viewing 15 posts - 361 through 375 (of 458 total)

  • RE: Automatic backup task

    Ignacio A. Salom Rangel (10/27/2012)


    Did you try this link http://technet.microsoft.com/en-us/library/dd851678.aspx

    Ok, unfortunately, that's not something I can work with. I am not a domain administrator. I have local admin privileges on...

  • RE: Automatic backup task

    Ignacio A. Salom Rangel (10/27/2012)


    Did you try this link http://technet.microsoft.com/en-us/library/dd851678.aspx

    No, that's something new, thank you. I'm not at work and have a slow connection here, but I'll try it as...

  • RE: multiple relationships

    ernesto.felix.city (10/26/2012)


    I am just curious for why you included 'brackets' [ inside every object in your query solution?

    I am a newbie and I am just confused for why it looks...

  • RE: DBA Support

    Developer, originally in Fortran, Cobol and RPG (I go back a few years), eventually migrated to Office/VBA, recently to Access/Sql Server. Accidental and unintentional DBA, along with still being a...

  • RE: Automated backup plan

    Hey, Lee, thanks for your input. It's always good to hear different perspectives, especially when those thought are accompanied by sound reasoning and underscored by experience. In my case, data...

  • RE: Automated backup plan

    Okay, I think I've got a reasonable plan. I'll do a nightly full, and an hourly differential and 15-minute transaction log during the day. The last will be mostly for...

  • RE: Automated backup plan

    AmarettoSlim (10/17/2012)


    After reading the posts on this thread I'm sensing you already kinda know the acceptable thresholds of data loss based on experience in the company.

    I do. It's the paleontology...

  • RE: Automated backup plan

    Jamie Scharbrough (10/17/2012)


    The answer to this is: It depends.

    I guess I'm approaching this with the view that this is a learning enviornment, and so you should do all the...

  • RE: Automated backup plan

    Jamie Scharbrough (10/17/2012)


    Well, it also depends on how small we're talking and how comfortable you are with backups in general.

    Biggest DB is a bit over 100MB, and my experience with...

  • RE: Automated backup plan

    Abu Dina (10/17/2012)


    pdanes (10/17/2012)


    You think, then, that such a cascaded full/differential/transaction approach makes sense, even given the situation I've described? If so, may I ask for your reasoning on the...

  • RE: Server crash, less than 100MB of disk space

    Well, this isn't exactly SQL stuff, and I'm no expert, but...

    If I was in charge of the machine, I hope I'd have enough sense to keep it from ever getting...

  • RE: Automated backup plan

    Jamie Scharbrough (10/17/2012)


    I agree with everyone who's said you need to be concerned about recovery, but I also understand where you're coming from.

    I'd say a weekly full (I like...

  • RE: SELECT fields with a space in the name

    Square brackets, as Gail told you, are always a safe way to refer to fields, even if you don't have spaces. Some languages also have accent marks, which can raise...

  • RE: Server crash, less than 100MB of disk space

    I'd get my shotgun and go find the clown who's in charge of the mail server. -Somebody- must be responsible for the machine - he should never have let it...

  • RE: Automated backup plan

    Yes, I've read that sort of advice as well, and it's certainly true, but it's difficult to restore something without first having backed it up. I was looking for some...

Viewing 15 posts - 361 through 375 (of 458 total)