Setting up your own log shipping solution is not difficult, it just depends on how you want to set it up, I use a bunch of bat files to accomplish...

Thanks Remi

I am sorry - looks like I posted this in the wrong place - moving this thread to --> SQL Server -->administration.

Good Job Steve.

As a rule of thumb - Make sure you place the log file on seperate disk or at least on a seperate partition. If that is the...

general network error could mean anything. If you can authenticate against the DB in NY, then its likely that you are encountering a network or bandwidth issue which is...

Totally agree with Karl and Russel. Set up your own log shipping solution. I set up mine from scratch in the old days ( SQL Server 7.0) when log...

before doing anything else did you try this?

Use master

GO

sp_resetstatus (db_name)

stop and start the SQL Service.

Check out this post - plenty of discussion of SP4 and the issue with instances running AWE - http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=182669

USE MSDB

DECLARE @backup_date DATETIME

BEGIN

set @backup_date=(select dateadd (dd, -15, getDate()))

EXEC SP_DELETE_BACKUPHISTORY @backup_date

END

I have run this ( deleting backup history over 15 days old) and I have never had an issue -...

Petmani,  You say we should apply SP4 if we use AWE - Please check out the latest release noted from MS:

"Warning: Microsoft has found an issue with the final...

Its possible that you have not enabled TCP/IP protocol support for your SQL Server.  Execute SvrNetCn.exe and enable TCP/IP. The SvrNetCn.exe is located under C:\Program Files\Microsoft SQL Server\80\Tools\Binn.

Thanks guys - I ran it last night in Prod and it worked like a charm

Thanks Noel,

Just to make sure -  by running this:

ALTER TABLE table_name  WITH NOCHECK ADD CONSTRANT [CONSTRAINT_NAME] DEFAULT (0) FOR [COL_NAME]

After I run this, the default constraint will be enforced on all...

Hi Guys,

Sorry - I have been distracted with other projects.  But am looking at this issue this morning.  So here is what I did:

I added the column without the constrant...

NP - thats why we are here - We are all here to help each other.  I would run the DBCC CHECKDB after you move the DB.  Check BOL for...