Rachel Byford (7/22/2010)

---

In Management Studio, right-click on the Replication folder and choose Launch Replication Monitor. In the Replication Monitor, coose the pulication you're interested in and you'll see the...

Hello. Will you please give directions for getting to the tracer token tab in SQL Server 2008. I can't find it by just poking around and I can't find...

Super, thanks for tip about PK, Gila. That was my trouble today.

One more question on partitioning. Is it common to add a DateCreated column to every table and assign every table to the same partition scheme so that related data...

ALZDBA, I am currently not having any problems with the job. Nightly the backups are running. There were only an inexplicable couple of days and all I could find...

My score was 644. close!

That is something concrete I can work with. Thank you. I did not look at this at all yet :blush: (and there is Activity Monitor), but I think I...

Thank you for your attention to this Gila.

I'm using SQL Server 2008 so I should say Query Editor.

Until now I thought single user mode and emergency mode were synonomous. Finally, I know better.

My interest first...

You mention Object Explorer and Query Analyzer as seperate interfaces, yet so far I have always engaged with them as one whole package aka SSMA. I wouldn't know how...

Just to be absolutely sure I have asked this question the right way I want to ask it in this way.

1. Is there anyway I can issue TSQL commands in...

Could you give me the exact path? I don't see a drop down for schedule type within the job itself.

No, I don't plan to run the backup whenever...

Thank you so much, Jim! I looked over the example and it makes sense to me and clarifies it all. I also read the question the same way, that...

Steve Jones - Editor (7/18/2010)

---

xp_cmdshell and T-SQL backup commands have nothing to do with one another.

T-SQL commands are run inside SQL Server, and you should be able to run them...

Thanks for replying. I really want to understand this and it seems i'm missing something fundamental.

I believed that restores had to happen in order: full, dif, trn OR full, trn...