- I'm set up the the replication in Sql Server from database1 in server1 to database2 in server2, in Visual Basic.
- Can I set up by stored procedures?not by the Vizard,how many method can i set up the replication in Sql Server from database1 in server1 to database2 in server2?
Please give me a good method!!
I'm using replication with two database on SQL 2000,when begin, the log files size is 50mb and the data files size is 150mb. But now the log files size is 2Gb and the data files size is 4Gb. I would like to decrease the log files and the data files ??? How do i do this???
(I using Truncate and shrink doesn't change )