SQL Server Snapshot Backup

How to export/ import userschema in SQL server 2005?

To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.      

Applying snapshot on Subscriber - SQL SERVER 2005

hi, i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part.  When the snapshot is created and...

Complications in snapshot replication from a SQL Server database

I have done snapshot replication from my SQL Server database to another SQL Server database. After completing the replication, the replicated data is not present in the other SQL Server database. Why might this be?

Stopping transactional replication from skipping a block of records

Have you ever run into an instance in SQL 2005 where transactional replication is skipping a specific block of records? I have tried many troubleshooting techniques: dropped/created sub and pub, created new empty destination table, reinitialized and several others. New transactions come across...