| Author |
Topic |
|
sgondesi
Posting Yak Master
200 Posts |
 Posted - 2013-10-18 : 08:47:04
|
| can we perform log shipping at the database level?-- Thanks and RegardsSrikar Reddy Gondesi,Trainee SQL Server Database AdministratorMiracle Software systems ,Inc. |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-10-18 : 09:46:41
|
| Log shipping is done on the database. The database cannot be in simple recovery mode. For log shipping, table by table is not possible.djj |
 |
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-10-18 : 10:05:23
|
quote:
Originally posted by djj55
Log shipping is done on the database. The database cannot be in simple recovery mode. For log shipping, table by table is not possible.djj
When i read the differences between log shipping and the database mirroring,it was mentioned that database mirroring can only be performed at the database level. And nothing mentioned with log shipping.my assumption is correct or not?-- Thanks and RegardsSrikar Reddy Gondesi,Trainee SQL Server Database AdministratorMiracle Software systems ,Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-10-18 : 10:06:44
|
quote:
Originally posted by djj55
Log shipping is done on the database. The database cannot be in simple recovery mode. For log shipping, table by table is not possible.djj
When i read the differences between log shipping and the database mirroring,it was mentioned that database mirroring can only be performed at the database level. And nothing mentioned with log shipping.my assumption is correct or not?-- Thanks and RegardsSrikar Reddy Gondesi,Trainee SQL Server Database AdministratorMiracle Software systems ,Inc. |
|
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-10-18 : 10:23:52
|
| Sorry I do not have mirroring experiance. Log shipping is done at the instance level for databases. When you setup log shipping it creates jobs that do transaction log copy and restores on a database.djj |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-10-18 : 10:39:34
|
quote:
Originally posted by djj55
Sorry I do not have mirroring experiance. Log shipping is done at the instance level for databases. When you setup log shipping it creates jobs that do transaction log copy and restores on a database.djj
Yes that's what i mean.i got my issue confirmed.Thank you sir.-- Thanks and RegardsSrikar Reddy Gondesi,Trainee SQL Server Database AdministratorMiracle Software systems ,Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-12-02 : 13:01:55
|
| Hai everyone..Having a doubt..Cant we take log backups of only few databases from the principle server and restore them on secondary?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-12-02 : 13:51:34
|
quote:
Originally posted by sgondesi
Hai everyone..Having a doubt..Cant we take log backups of only few databases from the principle server and restore them on secondary?
Yes you can. Any log backups you take on the primary database that is outside of the LS log backup job must be manually applied to the secondary database with the proper mode (such as NO RECOVERY).And to answer your original question, both log shipping and database mirroring are done at the database level.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-12-03 : 04:05:58
|
quote:
Originally posted by tkizer
quote:
Originally posted by sgondesi
Hai everyone..Having a doubt..Cant we take log backups of only few databases from the principle server and restore them on secondary?
Yes you can. Any log backups you take on the primary database that is outside of the LS log backup job must be manually applied to the secondary database with the proper mode (such as NO RECOVERY).And to answer your original question, both log shipping and database mirroring are done at the database level.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
What do you mean by LS log backup here?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-12-03 : 07:28:01
|
| If you have multiple databases in an SQL Server instance and only some are in Log Shipping the ones that are not in Log shipping can have a manual transaction log backup that is then restored as Tara indicated.djj |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-12-03 : 07:59:25
|
quote:
Originally posted by djj55
If you have multiple databases in an SQL Server instance and only some are in Log Shipping the ones that are not in Log shipping can have a manual transaction log backup that is then restored as Tara indicated.djj
Sorry sir, i dont know what a "tara indicated" is?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2013-12-03 : 09:23:27
|
Tara is user tkizer.quote:
Yes you can. Any log backups you take on the primary database that is outside of the LS log backup job must be manually applied to the secondary database with the proper mode (such as NO RECOVERY).And to answer your original question, both log shipping and database mirroring are done at the database level.Tara Kizer
djj |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-12-03 : 10:14:27
|
quote:
Originally posted by djj55
Tara is user tkizer.quote:
Yes you can. Any log backups you take on the primary database that is outside of the LS log backup job must be manually applied to the secondary database with the proper mode (such as NO RECOVERY).And to answer your original question, both log shipping and database mirroring are done at the database level.Tara Kizer
djj
oh..sorry i dont know that..!-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-12-03 : 12:04:41
|
quote:
Originally posted by djj55
If you have multiple databases in an SQL Server instance and only some are in Log Shipping the ones that are not in Log shipping can have a manual transaction log backup that is then restored as Tara indicated.djj
Thanks for the response.I understood what you have told. I will get back to you sir.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-12-03 : 12:28:13
|
quote:
Originally posted by djj55
If you have multiple databases in an SQL Server instance and only some are in Log Shipping the ones that are not in Log shipping can have a manual transaction log backup that is then restored as Tara indicated.djj
This is not what I meant. You CAN perform tlog backups on a log shipped database outside of the log shipping plan, you just have to manually apply (restore) them to the secondary server.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-12-03 : 12:30:30
|
quote:
Originally posted by sgondesi
quote:
Originally posted by tkizer
quote:
Originally posted by sgondesi
Hai everyone..Having a doubt..Cant we take log backups of only few databases from the principle server and restore them on secondary?
Yes you can. Any log backups you take on the primary database that is outside of the LS log backup job must be manually applied to the secondary database with the proper mode (such as NO RECOVERY).And to answer your original question, both log shipping and database mirroring are done at the database level.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
What do you mean by LS log backup here?
When you setup log shipping through a maintenance plan, it creates SQL Agent jobs. When I am referring to the LS log backup, I mean the SQL Agent job for the log shipping plan that handles the BACKUP LOG commands. You can run this job to create additional log backups, or you can manually run BACKLOG LOG. If you run the job, the log shipping plan will copy those files and apply them to the secondary server. No matter how many times you start the job, the log shipping plan takes care of the rest. But if you manually run BACKUP LOG command, YOU have to manually copy the files and manually restore them WITH NORECOVERY in order to not break log shipping.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-12-04 : 04:04:12
|
quote:
Originally posted by tkizer
quote:
Originally posted by djj55
If you have multiple databases in an SQL Server instance and only some are in Log Shipping the ones that are not in Log shipping can have a manual transaction log backup that is then restored as Tara indicated.djj
This is not what I meant. You CAN perform tlog backups on a log shipped database outside of the log shipping plan, you just have to manually apply (restore) them to the secondary server.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
I have understood this madam. Thanks a lot for the response.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-12-04 : 04:12:25
|
quote:
Originally posted by tkizer
quote:
Originally posted by sgondesi
quote:
Originally posted by tkizer
quote:
Originally posted by sgondesi
Hai everyone..Having a doubt..Cant we take log backups of only few databases from the principle server and restore them on secondary?
Yes you can. Any log backups you take on the primary database that is outside of the LS log backup job must be manually applied to the secondary database with the proper mode (such as NO RECOVERY).And to answer your original question, both log shipping and database mirroring are done at the database level.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
What do you mean by LS log backup here?
When you setup log shipping through a maintenance plan, it creates SQL Agent jobs. When I am referring to the LS log backup, I mean the SQL Agent job for the log shipping plan that handles the BACKUP LOG commands. You can run this job to create additional log backups, or you can manually run BACKLOG LOG. If you run the job, the log shipping plan will copy those files and apply them to the secondary server. No matter how many times you start the job, the log shipping plan takes care of the rest. But if you manually run BACKUP LOG command, YOU have to manually copy the files and manually restore them WITH NORECOVERY in order to not break log shipping.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
I got your point clearly.Thank you so much for the detailed response and your support.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
|
log shipping