[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

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.
0
aatishpatel
Asked:
aatishpatel
1 Solution
 
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
 
Tapan PattanaikSenior EngineerCommented:
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
aatishpatelAuthor Commented:
i do not know what kind of backup was told to backup so i want to do full backup............
0
 
Tapan PattanaikSenior 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
 
aatishpatelAuthor Commented:
thanks a lot
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now