Solved

SQL database simple copy backup needed.

Posted on 2013-01-23
4
225 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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…

825 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