Manually backup an SQL Server

How do I manually backup an SQL Server 2005?  Where are all the files that I need to locate?
al4629740Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
do you want to backup just "1 database", or the entiere system?
can you clarify the exact "requirements" ?
0
 
al4629740Author Commented:
One database.

But how about the entire system also?
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
al4629740Author Commented:
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
 
zx10rCommented:
the error you get when backing up can be resolved here http://support.microsoft.com/kb/290787
0
 
al4629740Author Commented:
What if I just backup the DATA folder?
0
 
bhanukir7Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.