Thanks, that make sense.

What I meant is do the backup before I do any change.

All below is on testing server.

So when I do a restore from SSMS later to...

A full back up for the testing right after the restore.

Let me rephrase this:

1. for example the database name is AdvancedWork on testing server.

I restore the database with overwrite ...

So for example I restore my testing database from a version from Production server.

Then I don't need to do a full backup after the restore.

So in the future if I...

Thanks, I edited the original post.

What I mean, whenever I refresh a database from an older or newer version of it, I need to do a full backup right after...

Thanks all. I will try the scripts.

I also am curious when bopeavy said to use 'you can use xp_cmdshell(not recommended on prod) and get the info through a query to...

Thanks, got it.

I found that in the log it apparently looks like when server is restarted, the offline databases are brought back online.

Is this a designed behaviour?

I did try on sql 2008...

Thanks all, great tips.

Thanks, also any way to find out who stop(start) or restart it?

What I often see is sometimes when I check the sql log I found SQL server was restarted for...

I guess the reason he uses this is to easily calculate the startdate.

by +1.

I tested by passing the parameter @Enddate='20110715', it works. If I pass '07152011' it will not work,...

Thanks a lot

Thanks. For third party software database, we never used bak, or mdf/ldf file, it always intall application from front end, and during the process, install database.

I've tried to call them...

I don't think there is a bulk operation.

But I will keep monitoring to see if it happens next time.

It happened at 3 am after transaciton log backup is done.

still confused.

Our windows setting is using English(United States), and sql installation's default to English (united states) collation is SQL_Latin1_General_CP1_CI_AS.

In our enviroment we have our database servers that hosts in house...

Thanks, so do you mean more paging or memory pressure means OS need more RAM space?