Solved

Manually backup an SQL Server

Posted on 2008-06-17
7
192 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
7 Comments
 
LVL 142

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 142

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
Give your grad a cloud of their own!

With up to 8TB of storage, give your favorite graduate their own personal cloud to centralize all their photos, videos and music in one safe place. They can save, sync and share all their stuff, and automatic photo backup helps free up space on their smartphone and tablet.

 

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Solaris SUN OS 4.1.3 machine clone 2 56
report returning null 21 79
Set Warning Thresholds on Database mirroring 4 33
Powershell script 13 54
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Read about achieving the basic levels of HRIS security in the workplace.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

919 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

20 Experts available now in Live!

Get 1:1 Help Now