Go 4 transactional replication only if consistent or reliable network connection is there. Merge replication is better suited for mobile users or field salesman scenario based situations.

Manu

Thanks for the reply George but my concern is that would I be able to restore the differential backup once I execute the sp_change_users_login stored procedure after putting up the...

Are you making use of SET NOCOUNT ON clause in case you don't need the rows affected statement? Try using it and see if it helps.

Manu

Try this:

WHERE (Contact.email = 'Unreg_user' or Contact.Email = 'null' )

Manu

Open the package--> Go under Package--> Save As--> Specify the server instance where you want to move the package and then Click ok.

Manu

I don't know the table name but I think there are some third party utilities which can do this. Try googling.

Manu

Try using disconnected Edit..

Manu

DId you tried this:

http://sqlserver-qa.net/blogs/replication/archive/2007/08/24/1713.aspx

Manu

Nikhil,

Try this

xcopy \\source servername\D$\Backup\*.* \\Destination servername\E$\Backup\*.* /d /s

I haven't removed drive letters so as to avoid any confusion. Use drive letters and folder location according to server drives configuration.

Type...

Make sure that you have not include the “.” in the file extension.

Go thru this:

http://www.sqlservercentral.com/Forums/Topic361562-149-1.aspx

Manu

DBReindex command is logged so log reader agent won't work as efficiently as it has more log to chew through.

Regarding same question in other forum:

http://www.sqlservercentral.com/Forums/Topic335623-5-1.aspx

Normally you should...

You can try by running profiler over a week and find out the logins not used at all during the database access time.

Manu

Can you try by running a profiler and tracing out what exactly is happening inside?

Manu

Thanks. Can you also tell me whether I need to restore transaction log back from production to development too once I restore filegroup backup?

Manu

For a quickstart:-

Identify the tables that need to be purged and the deletion criteria.

Manu