Pausing Log Shipping Plans

We are doing an IP Restructuring on our DR site over the weekend due to some business and management requirements.I actually have 2 questions. I have implemented log shipping plans for our databases. Which means I will have to pause (disable) my log shipping plans while this is being done and resume (re-enable) after everything is comlete.

Any insights on what else I need to do apart from these?

My second question is this. I am generating transaction log backups every 15 minutes and is averaging at 350MB (this much data every 15 minutes - not to mention that I've got around 40+ databases, all configured for log shipping just for this instance alone). My alert threshold is 45 minutes. My log shipping plan for one database starts failing probably because 15 minutes is not enough to transfer 300+MB-sized backup file over a WAN locate across the globe on a not-so-high bandwidth and restore it to the destination. Any recommendations on this apart from increasing the threshold? Your assistance is highly appreciated

Log shipping should not be affected by changing the IP addresses unless you change ones targetted directly by the log shipping jobs. For the WAN case, you can consider adding a step to compress the transaction log backups prior to copying them over the network. This typically improves the end-toend throughput over a WAN.

Regards,

Matt Hollingsworth

Sr. Program Manager

SQL Server High Availability

|||

Hi Matt,

Thanks for your reply. Actually, we will be changing the IPs of the destination servers You were mentioning compressing the transaction log backups prior to copying them over the network. I am using the Database maintenance plans to define my log shipping plans. The way I see it, the copy job does a "pull" method - the destination server is the one initiating the job. How do you insert a step to compress the transaction log backup files in the database maintenance plans? I am only allowed to use "Microsoft supported" procedures as per company policy

sql

patch management

Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:

> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it wa
s
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+
)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
>

patch management

Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
> > Hi experts!
> >
> > Our domain has about 50+ sql servers most of them dedicated and some are
> > multi-instance
> > I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> > still scanning but output file was with 0 size and I
> > canselled the scan. What is the reason for this behavior?
> > Tried with ip ranges and it works fine
> > How to scan all domain and avoid using ip ranges bc they are so many (100+)
> > and it will be hard work.
> > Please share your experiense updating sql servers with sp and security
> > patches. Is there a useful tools for scanning and patching domain with big
> > number sql machines.
> > Thanks in advance.
> >

patch management

Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.
use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:

> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>
|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:

Password problem

Hi to all.

I'm trying to add a new login to SQL Server Express, using SQL Management Studio...

I create the user, select "SQL Server authentication", and type the password, wich is strong enough. I click OK, and, for now, everything's fine. The problem arises when I access that login's properties: the password is different (it has different length), so I can't login with that account.

Any help would be greatly appreciated...

Thanks,

Alberto.

Hi,

the length of the password doesn′t have to do anything with the password itself, even if you put in a blank password (if this is made possible) you will get a bunch of stars / points presented there. That is just a hint that in there is a secret (password) stored in there.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

mmhh...it seems reasonable (with the help of some kind of weird logic)...thanks a lot!

Password Management Policy in SQL 2000

Hi,
Does the SQL 2000 provide the same Password Management Policy capabilities a
s provided in Oracle 9i ?
By Password Management Policy, I mean the Account Locking, Password Ageing a
nd Expiration and Password History features.
Thanks.
Raja
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.The features you list are available in SQL 2000 only when using Windows
Authentication. SQL 2005, currently in beta testing, will extend password
policies to include SQL authentication also.
Hope this helps.
Dan Guzman
SQL Server MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:O1wAhBw0EHA.1392@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Does the SQL 2000 provide the same Password Management Policy capabilities
> as provided in Oracle 9i ?
> By Password Management Policy, I mean the Account Locking, Password Ageing
> and Expiration and Password History features.
> Thanks.
> Raja
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.