You only need ports 443/445 if you are connecting using Named Pipes.

Pedro

Do you get those messages if you use sqlservr -m to start SQL Server?  If so, then I think you do need to rebuild your master database, and then restore...

Nirmal

You're going to have to help me out with some error messages... right-click on the job and choose View Job History.  Tick the Show step details box.  Click on a...

Nirmal

What is failing - the building of the string or the actual restore of the log?

John

Or this - not tested this so probably full of errors, but you get the idea.  Cursor probably not strictly necessary.  As it's a one-off update I don't think the performance issue...

Nirmal

It's not the job that's the problem - it's the SQL within the jobstep.  You need to change it so that it includes some error handling that will make it...

Michelle

Have a look here - this will give you some ideas on what sort of thing to monitor.  You can then add extra counters if you think they will be...

Yes.  Binary sort order is the fastest (but probably the least useful).  From BOL:

"Sorts and compares data in Microsoft® SQL Server™ tables based on the bit patterns defined for each...

Bill

C:\Progra~1\Micros~1\MSSQL\Backup\MyDB.bak should do it.  BUT if you already had a folder whose name began with "Progra" or "Micros" when either of those abbreviated ones were created, then you may be...

Fernando

Did you save the query that you used to move the tempdb files?  If so, check that you specified a location that actually exists and on which the account that...

Ronnie

I see what you're asking.  You should use the CHECKPOINT command to issue a checkpoint.  This is more likely to be successful during a quiet period since there will be...

Ronnie

Forcing a checkpoint isn't the same as truncating the transaction log.  A checkpoint is when data from the transaction log is committed to the database.  The transaction log will be...

Sangra

You're right - you do need a primary key on every table you wish to use for replication.  There's no way round that.

Do your tables have any sort of uniqueness...

Lori

Thanks - I think I had come to that unfortunate conclusion.  I say unfortunate because the network people here won't give me a domain account for starting SQL Server and...

a) sp_addarticle, as you say.

b) sp_droppublication (although I've a feeling you have to use sp_dropsubscription first)

c) sp_addpublication (and then sp_addsubscription)

d) if you used @sync_type='none' in sp_addsubscription then you don't need...