Solved

Manually backup an SQL Server

Posted on 2008-06-17
7
190 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

705 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

16 Experts available now in Live!

Get 1:1 Help Now