Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
benildusmuerling
Yak Posting Veteran
81 Posts |
 Posted - 2012-05-01 : 01:47:10
|
| Hi All,can you help me in doing a transactional backup, whoever please be good enough to say, if I restore a transactional backup, would the fullbackup would be there, or the transactional backup would overwrite the previously taken full backup.Thanks,AB |
|
|
sarabpreet12
Starting Member
5 Posts |
Posted - 2012-05-01 : 17:53:59
|
| Hi,If you are working on a production Server, PLs. don't even try to take a Transaction Log Backup. (Reason Being: You dont know how to take TLog Backup, that means you are not aware of anything related to Backup\Recovery, this might put the recoverability of the DB into Risk even if you are able to take a successful Tlog Backup)In-case you are working on your own Dev\Test machine here is the code:Backup Log <DB_Name> to disk = 'c:\test\DB.bak'you can replace the path and filenamePlease read the below mentioned link inorder to know more about restoring TLog\ Full backup http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backupshttp://msdn.microsoft.com/en-us/library/ms177429.aspxhttp://msdn.microsoft.com/en-us/library/ms190411.aspxThese links will give you basic idea & you can start learning point fwd.Thanks.Sarabpreet Singh Anand |
 |
|
|
|
|
|
Transactional Backup