Forum Replies Created

Viewing 15 posts - 331 through 345 (of 441 total)

  • RE: Question Regarding Backup Policy

    runal_jagtap (10/9/2012)

    Hi Chandan,

    Can you explain more on what should we recommend in normal scenario???

    I am assusming when you say normal scenario, you mean normal backup policy.

    Backup policy or backup plan...

    October 9, 2012 at 7:00 am

    #1547199

  • RE: Steps involved in removing mirrored database

    Perry Whittle (10/5/2012)

    remove mirroring

    Thanks Perry. Is there any difference in steps to when you remove Synchronize or Asynchronize mirroring?

    Regards,

    SueTons.

    October 6, 2012 at 2:43 pm

    #1546446

  • RE: Question Regarding Backup Policy

    GilaMonster (10/5/2012)

    With just a DR plan, how do you restore the DB to 10pm yesterday, right before someone dropped a table?

    Yup....Got it....I didn't think that way in terms of point...

    October 5, 2012 at 12:49 pm

    #1546284

  • RE: Question Regarding Backup Policy

    Perry Whittle (10/5/2012)

    SQLCrazyCertified (10/5/2012)

    Hi All,

    If you have mirroring or logshipping setup as a DR solution......Do you need have a backup policy/plan on top of it?

    Yes you do!

    It sounds like you...

    October 5, 2012 at 12:33 pm

    #1546272

  • RE: Script to Backup SQL Server Log Files

    SQLCrazyCertified (9/26/2012)

    Hi All,

    Need assistance in creating a script for the below requirement.

    Any assistance to satisfy this requirement will be greatly appreciated.

    Due to the mirror being deployed, we need...

    October 5, 2012 at 11:25 am

    #1546229

  • RE: Script to Backup SQL Server Log Files

    ananda.murugesan (10/1/2012)

    opc.three (9/27/2012)

    Have a look at Ola Hallengren's Database Backup script. It does what you're wanting and if setup in a SQL Agent job you can send an email if...

    October 4, 2012 at 9:38 am

    #1545630

  • RE: Script to change linked server password

    catchmekiran (10/2/2012)

    1) Connect to SQL Server instance.

    2) Select Server Objects folder and expand.

    3) Select Linked Servers folder and expand.

    4) Right click on linked server which you want to change the...

    October 2, 2012 at 2:37 pm

    #1544587

  • RE: Script to Backup SQL Server Log Files

    opc.three (9/27/2012)

    Have a look at Ola Hallengren's Database Backup script. It does what you're wanting and if setup in a SQL Agent job you can send an email if the...

    October 2, 2012 at 2:03 pm

    #1544580

  • RE: Script to Backup SQL Server Log Files

    SQLCrazyCertified (10/1/2012)

    GilaMonster (10/1/2012)

    SQLCrazyCertified (9/26/2012)

    · Determine where the current transaction log resides and write trans log to this file directory.

    Why do you...

    October 2, 2012 at 1:58 pm

    #1544578

  • RE: Script to Backup SQL Server Log Files

    GilaMonster (10/1/2012)

    SQLCrazyCertified (9/26/2012)

    · Determine where the current transaction log resides and write trans log to this file directory.

    Why do you want...

    October 1, 2012 at 3:11 pm

    #1544157

  • RE: Script to Backup SQL Server Log Files

    What could be advantage hallengren database maintainance script instead of using builtin Management plan?

    [/quote]

    You mean I can complete my requirement using SQL server maintenance plan?

    Regards,

    SueTons

    October 1, 2012 at 6:53 am

    #1543959

  • RE: Sanitizing the data

    Thanks....Appreciate it.

    SueTons.

    September 25, 2012 at 6:55 pm

    #1542171

  • RE: Sanitizing the data

    Evil Kraig F (9/25/2012)

    Data sanitization is removal of garbage data inbound to the system. It covers a number of smaller minor topics but basically it's a pre-check of the...

    September 25, 2012 at 5:35 pm

    #1542152

  • RE: Quick way to move a bunch of databases?

    Perry Whittle (9/13/2012)

    John Mitchell-245523 (9/13/2012)

    I would recommend backing up the databases first, in case the worst happens, which it has done for me before. Given that you have taken...

    September 14, 2012 at 6:15 am

    #1537765

  • RE: Data drive space issue

    Lynn Pettis (9/13/2012)

    Sounds to me that you need to add disks to your server so you have more space. Another alternative is to look at archiving old data from...

    September 13, 2012 at 8:14 am

    #1537231

Viewing 15 posts - 331 through 345 (of 441 total)