Forum Replies Created

Viewing 15 posts - 166 through 180 (of 180 total)

  • RE: Inserting Results from Stored Proc into another Database Table

    Hi All,

    Just realised i havent answered/closed this topic.

    I ended up getting it working by using a Try/Catch statement and inserted it into the relevant table depending on the result. ended...

  • RE: SQL Copy only newest files

    Ignore my question, I didnt quiet understand what a cmdshell could actually achieve. Used the Robocopy /MIR option to get the results i wanted...

    Thanks Tava

  • RE: DELETE Statements when using a JOIN - Best Practice

    Thanks for that, they appear to be alot cleaner in layout than the one i was using.

  • RE: About when will SQL Server 2012 be released?

    Thanks guys, will keep on the 2008 Certifications then. hopefully 2012 certs won't come out till i finish 🙂

  • RE: About when will SQL Server 2012 be released?

    Sorry to jump on the OP's post but if SQL2012 will be released in the first half of the year when do the MS Certifications for SQL2012 begin.

    I'm Currently studying...

  • RE: Backup failure History....

    Tava (12/28/2011)


    Saga... (12/28/2011)


    Thanks TAVA for reply.

    Actually I was seeking information for the failed backups in SQL Server. (Those backups which are not successful. We can notify it in error...

  • RE: Backup failure History....

    Saga... (12/28/2011)


    Thanks TAVA for reply.

    Actually I was seeking information for the failed backups in SQL Server. (Those backups which are not successful. We can notify it in error log,...

  • RE: Backup failure History....

    Saga... (12/28/2011)


    Hi Team,

    I need to find out the backup failure history.....

    Till date how many backup are failed in sql server how can I find that...

    please help...

    Could be wrong here...

  • RE: Learn T-sql Help please!!!

    logicinside22 (12/22/2011)


    I do have sql server enterprise installed and have some books also ,i am just confused from where to start first.

    but thanks for guidence.

    happy Holidays and Marry Xmas

    Not sure...

  • RE: SQL Backup Help.

    Tava (12/18/2011)


    Hi All,

    Backup was just Successful, I don't know why it is working now as I'm 100% sure I gave db_backupoperator access in the first place and tests failed.

    - Server...

  • RE: SQL Backup Help.

    Hi All,

    Backup was just Successful, I don't know why it is working now as I'm 100% sure I gave db_backupoperator access in the first place and tests failed.

    - Server Roles:...

  • RE: SQL Backup Help.

    GilaMonster (12/16/2011)


    Marco V (12/16/2011)


    GilaMonster (12/16/2011)


    What kind of account is SQL Server running under?

    and make sure that account has rights to the folder you backup youre db to

    And same with the...

  • RE: SQL Backup Help.

    Divine Flame (12/15/2011)


    Tava (12/15/2011)


    Hi All,

    I don't get any errors, the script executes as a Scheduled task and then no backup gets created i have to make the user a...

  • RE: SQL Backup Help.

    Hi All,

    Thanks for your help, I'll answer some questions that were asked and hopefully clarify a few things.

    Divine Flame,

    Its 2008 R2 Express Version so their aren't any Agent jobs...

  • RE: SQL Backup Help.

    Attached are both the VBS and SQL scripts. This was just directly from the Net. No need in there to store any users and/or passwords.

Viewing 15 posts - 166 through 180 (of 180 total)