Ok. I knew my thought was a design faux pas and not common practise, so lets say i keep the original pk.

But now I won't to use a second "key"...

Yes. Sorry, I ment page splits and the timestamp is not indexed and the table is not a heap...

OK. Thanks Gail. And what about the explanation?

arnipetursson (11/10/2014)

---

We need more info on your requirements:

Are these databases in the same location or do you need to sync over a WAN?

Are these database pairs or are we talking...

Thank you all!

Nobody? ;(

A normal snapshot is not possible, because afaik the databas has to be on the same instance, but she is on another server...

...log shipping was also my last idea...

Hi,

thanks for your help. I don't need the data througout the. Snapshot replication is taking too long...the database is about 2.5TB and the snapshot takes 1:30 for the creation of...

Ok. Thanks for your help.

So is there a thumb rule when to move SSAS on seperate server?

Thanks for your answer. I got several db-files, but I only need the main-mdf-file...

Check out Ola Hallengren's SQL Server Maintenance Solution[/url]. A lot of people out there use it!

Just uncomment it and run it again :hehe: ?

EXEC master.dbo.sp_addlinkedsrvlogin

@rmtsrvname =...

That's important...the bigger your logfile gets the slower gets CDC. Try to minimize your logfile and keep it small through logfilebackups every f.e. 15 minutes!

@1) Number of log records scanned....

You should also know about firewalls and the SQL Server Network Interface. If you want to know more about the protocolls SQL Server uses start here.

What's the size of your logfile?