Auto backup configuration in SQL2005
Home > IT Answers > SQL Server > Auto backup configuration in SQL2005
Shamoh
40 pts.
0
Q:
Auto backup configuration in SQL2005
SQL 2005 Database, SQL 2005, SQL Backup
How to setup an autobackup for the backup type of Full database and transaction log together as a single bakup file in sql2005.? We can setup to backup full database seperately and transaction log seperately, but i wanted these two should be a single backup file. Any suggestion pls.

Software/Hardware used:
Software
ASKED: Oct 30 2009  6:01 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46735 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Just backup the full and log backups to the same filename without specifying the with format option.
Last Answered: Oct 30 2009  10:35 PM GMT by Mrdenny   46735 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0