GilaMonster (5/18/2011)

---

Pages/sec are reads from the page (swap) file, not reads from any file on disk. If SQL is reading pages into its data cache, its reading them from...

GilaMonster (5/18/2011)

---

Pages/sec are reads from the page (swap) file, not reads from any file on disk. If SQL is reading pages into its data cache, its reading them from...

I'm not currently capturing this counter; i'll add it and check.

Thanks for the advice.

Thanks for your advice; i am starting to understand why many DBA's seem to favour direct TSQL coding rather then using the GUI.

Interestingly, i was adding the linked server via SSMS but i have just added it via TSQL script and it has worked correctly.

I have no idea what the problem was.

That is how we have been doing it up to this point; i just wanted to see if using replication as an alternative offerred any benefits.

Apologies, i thought i had provided enough info in my original post but i have now included a more thorough breakdown of my specific problem.

I wasn't saying that i wanted...

I'm not sure that this is the best way to achieve what i set out in my original post but i have created a script to compare the database objects...

Fantastic; thanks to all contributors.

I now have the information (and more) that i was looking for.

I have read through the article on using SSL for data encryption within SQL Server that was suggest earlier in this thread; as well as doing some reserach on some...

We don't currently have a VPN or an SSL set up for connection betweens our network and the hosted servers. The network administrator has confirmed that if we are to...

Thanks to you all for your imput so far; it's greatly appreciated.

With regards to the VPN; the answer is that i don't know. I will speak with our Network support...

We use mixed authentication currently anyway so there are some SQL Server logins already in use.

Thanks for your replies so far, i keen to learn as much as i can...

Out of interest; would you see it as a significant increase in risk to allow connections via enterprise manager considering that we already allow access via RDP?

Thanks for the quick reply, i'll take your perspective on board.