LogShipping and Transaction Log Backup

We use veritas Backup Exec for Hourly Transaction Log
BAckup
Would it be possible to integrate Logshipping with the
Translog backup performed using veritas Backup Exec?
not really. What you would have to do is to extract the tlogs from the
backupexec media and then apply them. You will be probably better off to
ship the backup and logs natively.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Cyriac George" <cgeorge@.naturesplus.com> wrote in message
news:3d3501c4a595$25befc00$a301280a@.phx.gbl...
> We use veritas Backup Exec for Hourly Transaction Log
> BAckup
> Would it be possible to integrate Logshipping with the
> Translog backup performed using veritas Backup Exec?
>
|||Thanks Hilary for the reply
I was also considering using BackupExec Scripts to achieve the same result
I am not comfortable using native script for Backup since we have a SAN
managed
backup infrastructure. Right now I am doing restore to the Stand By Server
using
Transaction Log restore from the Tape
Thanks
Cyriac George
"Hilary Cotter" wrote:

> not really. What you would have to do is to extract the tlogs from the
> backupexec media and then apply them. You will be probably better off to
> ship the backup and logs natively.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Cyriac George" <cgeorge@.naturesplus.com> wrote in message
> news:3d3501c4a595$25befc00$a301280a@.phx.gbl...
>
>
|||I meant native NT or SQL commands to accomplish the backup.
Unless you have huge tlogs (for large databases you should be dumping
perhaps each minute), you should be dumping to disk using multiple backup
devices.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Cyriac George" <Cyriac George@.discussions.microsoft.com> wrote in message
news:9A620431-339C-4B69-A075-10DFF3886E96@.microsoft.com...[vbcol=seagreen]
> Thanks Hilary for the reply
> I was also considering using BackupExec Scripts to achieve the same result
> I am not comfortable using native script for Backup since we have a SAN
> managed
> backup infrastructure. Right now I am doing restore to the Stand By Server
> using
> Transaction Log restore from the Tape
> Thanks
> Cyriac George
> "Hilary Cotter" wrote:
|||Hilary,
Is Replication a better option in this scenario?
My concern with the replication is loss of performance
on the main (Primary) server. Also given the fact that My primary server
is Clustered, and We have hourly BAckup of Transaction Logs using Backup
Exec, Can I still maintain the standby server using Replication?
What is a rough estimate of the performance loss on the
Server?
Thanks
Cyriac George

Login Times

Yes there is.
Have a couple of jobs running.
Start the job at a specific time
In the first job put in EXEC sp_denylogin '<usr_name>'
Then if you need to kill any of the processes for that
user still in there.
in the second login put EXEC sp_grantlogin '<usr_name>'.
So you start the first job at say 7pm
And the second job at say 8.30am
Peter
"I may be drunk, Miss, but in the morning I will be sober
and you will still be ugly."
Winston Churchill

>--Original Message--
>Helo,
>Is there any way I could grant or deny a user login based
on the time of
>day?
>I'm running mad with this issue, since not everybody is a
full time
>employee, and for security reasons I would want to block
their logins when
>they are supposed to be out of the office.
>Thanks in advance.
>
>.
>Thanks!
I wasn't thinking about jobs at all... I was running mad trying to pull in
triggers, and even thinking about changing the network configuration... but
my head wasn't thinking on jobs at all and it's a really nice answer.
Thank you Peter.
"Peter The Spate" <anonymous@.discussions.microsoft.com> escribi en el
mensaje news:19dd01c4bb6a$f99c8b10$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes there is.
> Have a couple of jobs running.
> Start the job at a specific time
> In the first job put in EXEC sp_denylogin '<usr_name>'
> Then if you need to kill any of the processes for that
> user still in there.
> in the second login put EXEC sp_grantlogin '<usr_name>'.
> So you start the first job at say 7pm
> And the second job at say 8.30am
> Peter
> "I may be drunk, Miss, but in the morning I will be sober
> and you will still be ugly."
> Winston Churchill
>
> on the time of
> full time
> their logins when