Hello,

I would like to share results of my research regarding this new feature and hope it can fill a current gap in overall information about it:

http://www.alexvolok.com/2015/06/sql-2016-temporal-tables-introduction/%5B/url%5D

http://www.alexvolok.com/2015/06/sql-2016-temporal-tables-changing-the-schema/%5B/url%5D

http://www.alexvolok.com/2015/06/sql-2016-temporal-tables-indexing-part-i/%5B/url%5D

also, an excellent overview...

Y'll not have stop replication

Dont forget to script user logins, jobs, custom error messages etc.

Or, as simplest way: backup|restore system databases (master, msdb).

1) Ensure, that sql server agent on test server have enough security permission to access a file on primary server.

2) Create job with step, which contains this batch:

Restore database db_name...

Hi,

Try this:

ALTER TABLE [Rules] DROP CONSTRAINT [IX_Rules]

Hi, Cory

Check this topic:

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=12363&#57689

Hi,

You can have 2 databases:

1) Main (operational) with necessary ammount of data.

2) Historical. Created for collecting nonoperational data for further data analisys or recovery some necessary information.

This database can be...