cancel
Showing results for 
Search instead for 
Did you mean: 

Backing up SQL 2012

Come612
Level 2

I am backup a database. My current Method is to do a "Full - Back up database" I need to know that if I need to restore the database to a new SQL instance I have all I need... Does this provide this? Also, do I need to do a transaction log backup or is that included in this backup?

Please advise.

 database2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified
A full backup is all you need. You only do a transaction log back if you are going to do a point in time restore and this is a separate backup

View solution in original post

1 REPLY 1

pkh
Moderator
Moderator
   VIP    Certified
A full backup is all you need. You only do a transaction log back if you are going to do a point in time restore and this is a separate backup