We do hourly transaction log backups during the work day.

Mike

We are running out of space on our mirror server. I though that if I could reduce the log, it would give us some breathing room while we figure...

The plan is for a website to put in requests in the Queue table and SQL to handle the requests. The called SP would be something like this:

parameter @id...

Hi -

Log backups are 30 min everyday between 8am and 6pm. Once the t-log has been restored - it will be deleted.

I want to write or get help...

mike 57299 (12/8/2012)

---

They have daily backup and 30 min transaction log backps. Unfortunately, because we are charged for bandwidth at the location, I can't pull daily backups from...

Yes, the data in a writable state is a must. That is why mirroring and log shipping won't work.

Mike

Can that be done in addition to mirroring?

Jason-299789 (11/9/2012)

---

I personally use a script to generate the drop constraints, this usually works and only needs tweaking

Select

'Alter Table ['+s.name+'].['+o.name+'] Drop Constraint ' +c.name

from sys.default_constraints c

JOIN sys.objects o...

Yes, I want them named consistently so that it is easier in the...

Yes, there is no where clause because there is only one record in the table.

Mike

Thank you very much. I was pounding my head against a wall.

Mike

If you truncate the t-log you will not be able to use a previous full backup to start a recovery if a more current full backup file turns out to...

All,

I am currently doing a full backup at 3am and log transaction backups every hour from 5 am - 6pm. I also have a second server running with...

It turns out that it is a problem with mirroring.

Thanks All.

Can you recover the database from Standby, make a backup, put the database back to standby and re-initiate log shipping without starting from a fresh full backup?