Solved

Manually backup an SQL Server

Posted on 2008-06-17
7
197 Views
Last Modified: 2010-03-19
How do I manually backup an SQL Server 2005?  Where are all the files that I need to locate?
0
Comment
Question by:al4629740
[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
7 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 21807522
do you want to backup just "1 database", or the entiere system?
can you clarify the exact "requirements" ?
0
 

Author Comment

by:al4629740
ID: 21807538
One database.

But how about the entire system also?
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 300 total points
ID: 21807568
for 1 database, you would issue a SQL statement to backup the database to 1 disk file.
sample statement:
BACKUP DATABASE your_database_name TO DISK='D:\backup_your_db.dbf'

then, you can copy/move/tape that file, and restore it later with a RESTORE statement from disk (to another server and/or another database name if needed)
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:al4629740
ID: 21807617
I get this error when I exectue the command

Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'C:\BackupIllinoisDB'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
0
 
LVL 4

Assisted Solution

by:zx10r
zx10r earned 50 total points
ID: 21807724
the error you get when backing up can be resolved here http://support.microsoft.com/kb/290787
0
 

Author Comment

by:al4629740
ID: 21809748
What if I just backup the DATA folder?
0
 
LVL 23

Assisted Solution

by:bhanukir7
bhanukir7 earned 150 total points
ID: 21810987
Hi

if you want to do that way then the database should be turned off. Which is called a cold backup.

You can otherwise use ntbackup to schedule a backup of the SQL database also.

bhanu
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

730 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