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?

Improve company productivity with a Business Account.Sign Up

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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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
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.