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

Backup policy or backup plan...

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

Regards,

SueTons.

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

Perry Whittle (10/5/2012)

---

Yes you do!

It sounds like you...

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...

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...

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...

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...

SQLCrazyCertified (10/1/2012)

---

GilaMonster (10/1/2012)

---

Why do you...

GilaMonster (10/1/2012)

---

Why do you want...

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

Thanks....Appreciate it.

SueTons.

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...

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...

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...