Thanks Jeff 🙂

Currently me planning to go with SSIS Package Automation...

Well see how i succedd.. incase any query i will come here again.. stating

65 views & 0 replies :w00t: (...

Jeff, No we would never need a data a month old, incase if someone needs the data we can retrieve it from Archive DB..

but whats the best approach???:w00t:

david.alcock (3/18/2013)

---

Apologies, I am not sure what you are asking.

If it what action to take next, then it depends on the requirements of the business perhaps. Is the data...

I did a Import export activity for transfeering the Tables/data to other DB/server and saved the Packgae as SSIS package to the File Location..

Now how do i move ahead...

1) Tables...

David, can you tell me how did u perform this activity via SSIS... please explain in details

4 View ... 0 replies :w00t:

Scenario

First Full backup was only taken... no Log backup was there.. hence the Log sie exceeds to maximum... upto 2GB+ :w00t:

And so they use to Truncate log..

Please assist what to...

Thanks Gail 🙂

But On weekly basis the Log gets Full & then application stops running or the DB runs very slow ... how to tackle this now...

But Truncate Log after rebuild index is valid???

Truncate Query - (backup Log XYZ with truncate_only)

Is this fine or should i execute some other query?? do u have any query?

Thanks BriPan 🙂

One more query.. I am asked to Build a maintenance plan, Can u tell me the sequence in the belwo points

1) Full Backup + Log Backup

2) ReBuild Index

3)...

Hi Anthony,

There is One Log shipping Done on the Testing server, which is working fine..

As i can see the LS jobs in SQL Server Agent..

Now if i want to view...

anthony.green (2/18/2013)

---

Ensure DB is set to full recovery.

Click enable this primary check box,

Click backup settings

Give it a network path

Give it a local path

Give it the right time frame and schedules...

Thanks Anthony & jeet 🙂

OK, thanks Anthony for your valuable replies 🙂

I just checked with developers they do archieving of data every quarter, so i dont tyhink it will grow more than 25GB...

Will execute the

ALTER DATABASE runal_jagtap MODIFY FILE (NAME...