Thank you.
I see the 4 line in the llinked article:
As the source database is updated, the database snapshot is updated.

Thanks, I am not quite clear when you say snapshots.
Snapshots are readonly, and it will be updated as source database is updated.
How can the database be reverted to...

Thank you all.
The purpose for that used in Oracle in our case is to make a guaranteed point of recovery, then testers will do some test data entry, then...

Found the issue, I used a SQL 2014 client to connect to this SQL 2016 instance.
changed to 2016 version of SSMS, the dropdown shows.

Thanks

And actually I cannot see the dropdown box of compatibility level for all databases, it is empty.
What could be wrong?

I found after I upgraded to SQL 2016, and uninstalled 2014, when I want to change compatibility from 12 to 13, the compatibility level of master ,model, msdb, tempdb all...

Thanks!

Thanks all.  That explains it. It seems SSRS not using a queue system., not working that way, Thanks for that query too.

I guess the job folder only has jobs currently running, it will not have jobs queued, correct?

Thanks much

Thanks, We have another enterprise software that has some system reports that the application has report queues , you can delete a job in the queue or restart the queue.We...

• This reply was modified 6 years, 5 months ago by sqlfriend.
• This reply was modified 1 year, 11 months ago by sqlfriend.

Michael is right. I found out the reason I cannot to connect the SQL server VMNew using SSMS is because of the SQL service is not started. And I tried...

I did a nslookup, they are different IPaddress

Thank you.

I followed what you said to browse more, it has a local server the server name is VMNew, but when I connect to it, it shows error.

The thing I am confused about using the SSMS to connect the original SQL server name, is it the one on VMOriginal or is it the instance on VMNew?