How to create backup of SQL Server db for purposes of creating it on a development pc
Posted on 2005-05-11
(Access Sage, SQL newbie)
Hello fellow experts
I have a client that has a SQL back-end, Access front-end where they want me to do some Access enhancements on it. Is there a way to create a backup copy of their SQL back-end database for purposes of creating it on my development pc, for working on their front-end?
My alternative is to use a TightVNC-like connection to their server in order to do any work connected to the back-end, which I'd like to avoid if possible.