I use whatever it is as default for diffrential in maintenance plan.

I think it is created a new file each time it run, because I see timestamp on each...

I prefer to use the native backup tool too.

But one problem I often comes with how to select to backup all user databases but to exclude one or more specific...

Thanks, will look into it.

Also if I can setup an alert notification using Policy management in SQL server to do similar thing like this?

I mean to notify the operator when...

Thanks, what is autorun procedure?

Thanks, I got it, I do feel lucky after getting the answer 🙂

Just an update, I uninstall reporting service, stopped the report server IIS site. And then I did a new installation of reporting service 2008, it looks good so far.

From...

I heard from another DBA, for a testing server which is only used for testing not for production, as long as the each developer using the testing server has a...

Perry Whittle (10/8/2011)

---

In SQL Server 2008 R2, developer is licenced and featured the same as datacenter. You can have as many testers connect as required. The key point of the...

So is my statement below correct?

For testing server, as long as each developer who connect to the testing server have a dev edition license, the server doesn't need a license...

Could you update the information on this post after you checked with microsoft?

Thanks much

We cannot use trial version of Enterprise, is because once the test server is upgraded, we want to keep using it, the developer will use it as a testing server...

Lynn Pettis (10/7/2011)

---

I don't think that means you can install the same licensed version on 4 physical machines. I think it means you can install the copy on virtual systems...

I also found that the Enterprise Edition of SQL Server allows you to install the software on four operating system environments (virtual or physical).

I don't know the reason for...

I run the sproc again, and include the actual excution plan in the attachment.

Thanks