I suggest you go and have a chat with the lecturer/teacher and get the material that you missed and work through it. Neither of those is at all correct. Topics...

Since you've given me nothing to go on (no trace script, no details of where/when/how the trace gets started), good luck figuring it out. A trace doesn't survive SQL restarting,...

A trace is a trace, doesn't matter whether it's called from a proc or an agent job or ad-hoc code.

What do you have so far?

p.s. this isn't a SQL certification exam question, is it?

Ok, so let's start with the code that you're running, or are you expecting someone to write a whole profile trace script for you without any idea what your existing...

Not hard. Let's start with the code you already have for the trace.

enriarg (5/20/2014)

---

I was reading about delay transaction log, durability, truncate and all that, someone on one of the documents mention that a service shutdown doesn't really commit the dirty pages,...

You missed "when dynamically creating the where clause"

Personally, I hate...

ALTER VIEW ... then start typing. Don't forget to test all the applications and fix the myriad of...

Yes, because the restore doesn't use the same methods as normal queries do when they're reading/writing. Restore doesn't write much at all to the tran log.

I'm just going to leave this here...

http://www.sqlservercentral.com/Forums/Topic1572621-391-1.aspx

Per hour?

Replication does not prevent a change in recovery model.

ALTER DATABASE <database name> SET RECOVERY FULL

If it throws an error, please post the exact error message.

Curious, why are you setting the...

If the database state is RECOVERING, then it is running the recovery process and will come online at the end of that. Probably there's a large transaction that needs to...

You want to pay someone be available for you to ask assistance of and to do parts of your job that you can't?

Out of shear curiosity, what amount are you...