Hello Everyone,
Can someone please give me some ideas on how I can maintain a database on a
development environment with data that was entered by users from a remote
production site.
I have no direct access and can not remote connect to the remote production
server. The only connection I have is a read only Linked Server Connection
over a VPN. The database is about 4 Gigs in size.
Does anyone here have any suggestions on the best approarch to recreating
the production database at our development site on a nightly basis under my
current limitations?
Thanks
ScottHi Scott
You may want to check for any data protection issues before you try anything.
Have you tried connecting directly to the instance using the credentials for
the linked server? If you aren't wanting to do a full backup/restore you may
want to set up replication or log shipping to a separate databases and then
transfer the data from that to the other system.
John
"Scott Yu" wrote:
> Hello Everyone,
> Can someone please give me some ideas on how I can maintain a database on a
> development environment with data that was entered by users from a remote
> production site.
> I have no direct access and can not remote connect to the remote production
> server. The only connection I have is a read only Linked Server Connection
> over a VPN. The database is about 4 Gigs in size.
> Does anyone here have any suggestions on the best approarch to recreating
> the production database at our development site on a nightly basis under my
> current limitations?
> Thanks
> Scott
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment