SQL Server backup

I want to perform a back of a database after hours. so what are the exact steps. i need to know because this is a very important database and big in size also. so please need the exact steps to do a backup. Any help is appreciated.
aatishpatelAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Tapan PattanaikConnect With a Mentor Senior EngineerCommented:

Hi aatishpatel,
               
                    for taking full backup , you have take backup type = "FULL", mark the 2nd figure of the below link

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-database-backup.html
0
 
chapmandewCommented:
what kind of backup?  if full, then:

backup database dbname
to disk = 'c:\backupfile.bak'

are you referring to trans log backups?
0
 
AanvikCommented:
http://msdn.microsoft.com/en-us/library/ms187510(SQL.90).aspx

Step by Step approach for taking Backup. You can also create a SQL Maintenance Plan to create db backup daily..
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Tapan PattanaikSenior EngineerCommented:
0
 
aatishpatelAuthor Commented:
i do not know what kind of backup was told to backup so i want to do full backup............
0
 
aatishpatelAuthor Commented:
thanks a lot
0
All Courses

From novice to tech pro — start learning today.