Why dont you consider Transactional replication. I think it suits your environment. Initially the snapshot is generated and gets reflected at the subscriber and transactions that happen at the publisher...

Hi,

Are you configuring the replication over the internet. If so first add the hostname and ipaddress into the host file. I think this should resolve ur problem.

Thanks

Chandra Mohan...

Always take the backup to local disk on the server and transfer it over the network to the destiation after the backup is successful.

Thanks

Chandra Mohan N

Did you take a look on the activity that is going on the server.

Refer : http://www.sqlservercentral.com/redirect/articles/67120/

Give a try with sp_executesql instead exec. Meanwhile I will check.

Thanks

Chandra Mohan N

Check this

sc query | FIND "STATE"

but requires xp_cmdshell

Thanks

Chandra Mohan N

I sugget you to read book on replication by Apress

Hi,

There is no command for taking the backup of a single table in sqlserver. But if you want you can take the backup by creating other dummy...

Hi,

Can you post the code here.

Thanks

Chandra Mohan N

Can you check whether port on which the named instance is running is open. And what is the error message that you get when trying to connect. Are you trying...

Did you try the above one?

There is no way other than adding the user to sysadmin role in sql 2000.

Thanks

Chandra Mohan

I think its better to download a trial version and checkout. But I think extractor is not safe because you are experimenting with your crucial backup. Anyhow can you give...

To resolve the problem

1. Check whether sql browser service is running or not. If it is not running start the service and check out.

2. Stop 2000 and restart 2005 and...

Try using the arpwrapper from the command line.

"%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /Remove"

Refer: http://support.microsoft.com/kb/909967