yes, the article details that.

If the sql server service will not come online, check that all the dependant resources start successfully, you can see this in failover cluster manager. Take evrything offline and then...

Lazy DBA (10/10/2012)

---

My log shipping was working for the past two years and now it has started failing with "cannot find a file that can be applied" or "Too recent"...

Check the event logs for more info, there's bound to be an error there somewhere 😉

That is correct, you cannot drop the first created (primary) data or log file . If you want to move this you will incur some minimal downtime.

Create your alter database...

have youi checked the event logs for details of any errors\warnings?

OK, so you probably don't need a 3 day retention period

ankur_libra (10/10/2012)

---

Can you please suggest as per current scenario, where Log file...

Ah right, gotcha.

But, back to my original quote, no study material...

Don't they run a boot camp in Redmond?

shiv-356842 (10/10/2012)

---

Hi Team,

WE are adding new witness server sql server 2008 R2 SP1 Standard Edition.

Prinicipal & Mirror servers Sql server 2008 Standards Edition only. we are adding this witness...

OK, so how often are the restores being applied by the restore job?

If they're restored hourly you could probably reduce the retention on the secondary, either that or get more...

Standard, Enterprise, Web, workgroup, Developer, Express.....

Which version\edition of SQL Server are you using?

Why??

i could be wrong but i'm sure I'm not. I wouldn't think that the MCM course will teach you hex,...

GilaMonster (10/10/2012)

---

TagA and TagB are just the two bytes (first and second) of the record header, nothing fancier than that. You don't need to decode them, DBCC Page does it...