Solved

Manually backup an SQL Server

Posted on 2008-06-17
7
194 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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 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…

809 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