i m having 2 Database files for the same DB and 2 Logfiles ,i want it to make a single file.... is it possible with DTS or any other thing....Originally posted by hemzg
i m having 2 Database files for the same DB and 2 Logfiles ,i want it to make a single file.... is it possible with DTS or any other thing....
Check out DBCCC SHRINKFILE with the EMPTYFILE option in BOL.
regards,
harsh.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment