does your wmi user have access to those 3 db's?

are they set to read_only or offline?

Mani (7/15/2009)

I just want to know how all other DBA's approach in configuring log shipping in SQL Server 2005.

1.Do you use Separate Monitor server for Monitoring Log shipping?

2.How big...

http://www.sqlservercentral.com/Forums/Topic328124-148-1.aspx

rambilla4 (7/1/2009)

Can you point me to...

We have EMC clarion and we wanted to have lun backups but it requires a snapshot license so we declined.

You can have Automatic Snapshots Enabled for Lun and that will...

Port 5022 is blocked on the principal or mirror server.

Do a netstat -a to see if anything else is using it.

Unblock 5022 in your firewall http://support.microsoft.com/kb/842242

Troubleshooting Mirroring

http://technet.microsoft.com/en-us/library/ms189127.aspx

Error 1418

http://technet.microsoft.com/en-us/library/aa337361.aspx

It's amazing if it's running on Linux or Unix. Oracle RAC on windows = Migraines.

You can categorize them in SQL Agent:

http://www.mssqltips.com/tip.asp?tip=1484

Failovers are treated as restarts so all jobs will stop.

You can create a custom script to start your jobs on the passive node after the failover.

Customize this script to fire...

Are you using Systems Management Server?

http://support.microsoft.com/kb/q274743/

try REPLICATE

create table t1 (MyCol1 varchar(20) null)

insert into t1 values('ABCDEFGHIJKLMNOP')

select dataLength(mycol1) from t1

SELECT MyCol1 + REPLICATE(' ', 20 - DATALENGTH(MyCol1)) from t1

Put the old server name in DNS as a pointer to the new server name this is if your app connects by using a server name (NYCFINSQLP01 instead of 10.1.0.1)...

can you post create table statements

What are you using to extract data and view it?

Here you go.

How to move system databases to another drive

http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx