Solved

SQL database simple copy backup needed.

Posted on 2013-01-23
4
224 Views
Last Modified: 2013-02-20
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.
0
Comment
Question by:isitcomputers
  • 2
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 38811174
You can run a SQL command to full BACKUP DATABASE first onto a folder residing on that Server then copy the backup from the same cmd file to the desired path where the usb is.
0
 
LVL 39

Expert Comment

by:lcohan
ID: 38811179
0
 
LVL 1

Author Comment

by:isitcomputers
ID: 38822823
Sorry, haven't had a moment to try the advice.  Will try the cmd line option on Monday.
0
 
LVL 1

Author Comment

by:isitcomputers
ID: 38827056
From this command line:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe"
    -E -Q "BACKUP DATABASE mydatabase TO DISK='C:\tmp\db.bak' WITH FORMAT"

Being a novice with this stuff (and I do apologize) I have the following questions:

1) Can I or should I change the osql,exe to sqlcmd.exe ?  I see both on the server.

2) Is "mydatabase" the database name that I am backing up?  Do I need the path in the statement?

3) What does "WITH FORMAT" mean ?

4) Can I put this into a script that will run nightly?
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now