| Author |
Topic |
|
dineshsatam
Starting Member
19 Posts |
 Posted - 2007-10-25 : 14:34:12
|
| Can it possible of taking full dump db backup of Logshipping server [Secondary Server.]Or any other way {DTS} on Secondary server, to update third server on daily basis.please co-operate me on this issueThanx in advanceRegardsDineshDina Satam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 14:35:19
|
| If the log shipped database is in read-only/standby mode, then yes you can take a backup of it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
dineshsatam
Starting Member
19 Posts |
Posted - 2007-10-25 : 14:52:07
|
| Thanx for replyBut I want it to be in Job, so that every night it will take full dump of Secondary Server.And again secondary server will be in online syncDina Satam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 14:54:44
|
| There's nothing stopping you from putting your code into a job.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
dineshsatam
Starting Member
19 Posts |
Posted - 2007-10-25 : 14:58:21
|
| So u mean to say I have to create a job which take full dump of Secondary server.But one dought, while full dump of Db is in progress that time logshipping will run ?Dina Satam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 14:59:14
|
| Log shipping should not be impacted as you are only performing a full backup.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
dineshsatam
Starting Member
19 Posts |
Posted - 2007-10-25 : 15:04:09
|
| Thanx Brother,I will try tomorrow. I will create a job for taking full dump of DB which will run on particular time. And also will check whether it impact to Logshipping .As I was under impression by Our DBA, he said while taking full dump of Logshipping server u have to stop TXN_ Log Shipping.Dina Satam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 15:24:09
|
| I am not male, so brother does not apply.Like I said, the log shipped database must in a specific mode in order for you to run a backup on it. If the DBA did not set it up to be in standby mode, then this will not work. So you need to verify what mode the DBA used.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-25 : 17:40:29
|
| Wow, first it was Ms. Kristen and now it's Brother Tkizer. What's this board coming to? hehe |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 17:48:17
|
| I think Kristen gets a kick out of it, otherwise he'd update his profile to include that info. As for me, I think that people just don't expect females working in the IT industry, especially as a DBA.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-25 : 17:58:26
|
| Yea, I'm sure he does.I've been a SQL DBA at three different companines (in KY, KS, and TN) and at all three there has been least one female DBA. Maybe you should bold and increase the font on your first name in your signature. hehe |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 18:08:35
|
| I actually know a male with the same name. Same pronunciation at least. He spelled it Terrah though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-26 : 09:50:44
|
| I've met three Van's in my life and two have been males and one female. |
|
|
|
|
Need a help in Backup Policy