Solved

SQL database simple copy backup needed.

Posted on 2013-01-23
4
228 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 40

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 40

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article explains how to install and use the NTBackup utility that comes with Windows Server.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

690 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