I have a SQL server db for which I am attempting to push new subscriptions to other servers. The problem I have is that the Server was installed with the SQL server program files (and repldata directory) on the c:\ drive (which is about 4 gig) and the data files on a raided d:\ partition. When the snapshot agent starts to run it will eventually run out of space on the c:\ drive for storing the bcp files. My question is how can I change the location of the BCP files from the c:\mssql7\repldata folder to the d:\ drive somewhere?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing Location of BCP Files for replication
- Thread starter mdr227
- Start date
Similar threads
- Locked
- Question