Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 4,745 total)

  • RE: Does anyone have a good reason to run xp_CmdShell?

    @allmhuran - I guess it depends exactly what you are trying to do.

    We are just backing up, creating directories and deleting files, we leave copying files to software we have...

    ---------------------------------------------------------------------

  • RE: Log shipping

    err.... as I described above? I thought this was urgent?

    ---------------------------------------------------------------------

  • RE: HELP - SQL WILL NOT START

    the topic that just keeps on giving 🙂

    ---------------------------------------------------------------------

  • RE: Log shipping

    http://msdn.microsoft.com/en-us/library/bb522682(v=SQL.100).aspx

    ---------------------------------------------------------------------

  • RE: Log shipping

    when using alter database modify file to move files, offline\online is the normal way to achieve this, however a database in recovery mode cannot be set offline.

    ---------------------------------------------------------------------

  • RE: Log shipping

    If the secondary is in standby, set it to norecovery (change the option in the logshipping set up.)

    run one more backup, copy, restore.

    Disable those jobs.

    On the secondary use the 'alter...

    ---------------------------------------------------------------------

  • RE: Are the posted questions getting worse?

    Tom.Thomson (6/13/2011)


    george sibbald (6/13/2011)


    SQLRNNR (6/13/2011)


    The Dixie Flatline (6/12/2011)


    If I passed, could I add "Thread Certified" to my resume` ?

    I thought you already had "Certified" added to your resume.

    He's not only...

    ---------------------------------------------------------------------

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Ninja's_RGR'us (6/13/2011)


    george sibbald (6/13/2011)


    Ninja's_RGR'us (6/13/2011)


    I like it too. Been around since dos 4.? so everything comes pretty naturally to me there... no point in learning clr and reinventing...

    ---------------------------------------------------------------------

  • RE: Does anyone have a good reason to run xp_CmdShell?

    Ninja's_RGR'us (6/13/2011)


    I like it too. Been around since dos 4.? so everything comes pretty naturally to me there... no point in learning clr and reinventing the wheel.

    I mainly...

    ---------------------------------------------------------------------

  • RE: SQL Server 2008 R2 backups with data compression

    been using it for about 6 months with no issues.

    ---------------------------------------------------------------------

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/13/2011)


    The Dixie Flatline (6/12/2011)


    If I passed, could I add "Thread Certified" to my resume` ?

    I thought you already had "Certified" added to your resume.

    He's not only sane, he has...

    ---------------------------------------------------------------------

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/12/2011)


    If I passed, could I add "Thread Certified" to my resume` ?

    that would make you a 'TCP'

    ---------------------------------------------------------------------

  • RE: System Database - MODEL corrupted

    Firstly, are you sure you copied back the correct log file?

    If you have another instance at exactly the same version as this you could use a COPY of the model...

    ---------------------------------------------------------------------

  • RE: Are the posted questions getting worse?

    wondering how famous the mention would make me I googled myself. and the thread came up!

    So I am now famous, but for all the wrong reasons.

    Will this be good...

    ---------------------------------------------------------------------

  • RE: Are the posted questions getting worse?

    :-D:-D:-D:-D

    ---------------------------------------------------------------------

Viewing 15 posts - 1,726 through 1,740 (of 4,745 total)