Thanks for Clarrification and confirmation.

So, according to you, Log shipping can not be configured betwen servers on windows 2003 and 2008

Mostly it will be permission issue.

make sure you have full access on the UNC path.

Mostly it is SPN Issue only

Check the below link :

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

What is OS of your server ?

Passing Score is 700.

@ SKYBVI - Sushant

1) Agent is running on secondary server.

2) I can connect to the database

3) Copy file destination is good. that folder is accessible from primary as well...

Here are the error which i am getting on the primary server.

2010-11-03 13:45:49.77 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 10.1.11.125]

2010-11-03 13:45:59.80...

I am using SQL Authenication while connecting to secodary server.

Does that will have any issue.

The sql login is part of sysadmin group.

Also, i have created script from the log shipping...

@g n 418 :

What is the status of your problem after doing configuration from sp_configure.

Nice to hear that your Database server is up.

To find out reason of the issue occurred,

1) you can install the above mentioned windows update one by one

2) After installing...

Posted Yesterday @ 9:30:05 PM

Valued Member

You are correct on the HUGE Logs in simple mode. I have seen 100GB logs when the data file is far less in...

@Anderson,

Have u tried to use Jimmy May's DMV which has been provided by enwicc.

If yes, kindly update the forum with results.

Regards,

Chetan

Just a thought.. ( may be wrong, Group member can correct the same).

If your VM server is having Multiple CPU, then you can configure the particular instance ( with any...

--SQL 2008 Sp3 --

R u sure of this ?

MS site says that it has released SQL 2008 SP 1 only and along with Cumulative Updated No.10.

Hi,

go through the link :

http://www.microsoft.com/sqlserver/2008/en/us/high-availability.aspx

Which shows SQL 2008 R2 has Log shipping and database Mirroring as a part of High Availability.