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 productio
n
> server. The only connection I have is a read only Linked Server Connectio
n
> 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 m
y
> current limitations?
> Thanks
> Scott
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment