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 |
|
csaha
Yak Posting Veteran
52 Posts |
 Posted - 2012-11-16 : 10:40:03
|
| Why do we need to create a Transactional Log Backup Settings as well as Copy File folder during log shipping.Also during restore which folder is used to restore? I have used the following link: http://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/The network path for copy file is located in \machine1\SQLDBPool_Logshipping_Secondary and the Network path to backup folder is located in \machine1\BackupTransactionallogbackupAbraHRMS_Live Do I store the copy and the backup folder in two separate locations and not on the same server? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-11-16 : 11:17:04
|
| Are these the folders for the local copy of the backup then the copy to the remote server for the restore?You usually wouldn't want to backup or restore to/from a remote server.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
csaha
Yak Posting Veteran
52 Posts |
Posted - 2012-11-16 : 13:53:09
|
| I have created both the folder on the secondary server from the primary server. Anyway my question is do I need to create the backup Transactional log setting as well as the SQLDBPool_logshipping_Secondary in the same server. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-11-16 : 22:50:20
|
| Usually you have Backup Folder in Primary Server and Folder where backup will be copied in secondary server. |
|
|
|
|
|
|
Log shipping folder