SQL database simple copy backup needed.
Posted on 2013-01-23
Hello, I am attempting to help a friend do a daily copy of a single SQL database. The server is running Windows server 2008 and SQL server 2008. Apparently the SQL server is express as there is no management plan option (as I was told).
There is a regular backup being done (I am told). What is needed is a copy backup to a USB stick to be taken offsite. It is not a large database. For added protection, they want to keep current data offsite. FTP is an option down the road but for now, they just want to keep a quick copy of the days data on a USB stick.
I have tried using Windows backup, but ran into problems. I looked at SQL management, but can't see how to do it.
I am not a server admin, but do know how to do basic server functions (very basic!)
Thank you for your assistance.