-
how to move a merge replicated database to a new hard disk
I am new to sql server world as system admin who is being asked to manage an asset management system at our facility. We have a system that uses SQL2005 Enterprise. My Replicated distribution database is on drive C, but it is only 10gig and it is running out of space. I have a 210 GIG hard drive as drive D. is there an easy way to move the database without deleting the publisher and the subscriptions from C to D?
-
You can change db file path with 'alter database db_name modify file ...', then stop sql, move db files to new location and restart sql.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|