INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Microsoft SQL Server: Setup and Administration FAQ

Replication

How to Move a Database That is Configured for Snapshot Replication by JohnBates
Posted: 15 Sep 05

This FAQ relates to SQL Server 2000 and Snapshot replication only. These tips may not work if the database uses the Transactional or Merge replication type.

You can move a user database to another logical drive on the same server by following these steps using Enterprise Manager. For example, you might want to move the db to a drive that has more available disk space.

This is what I tried and, to my surprise, it worked beautifully:

1. Perform a full backup of the db
2. Take the db off-line
3. Restore the backup - pointing the files to the new drive path, with 'Leave Database Operational' and 'No additional restores needed' checked

When the Restore completes:
- the database will automatically be on-line and pointing to the data and log files on the new drive
- and the data and log files will have been removed from the drive where the db was originally
- The Snapshot and Distribution jobs should work fine at this point.

When I used these steps, didn't even have to re-create the Subscription.


Back to Microsoft SQL Server: Setup and Administration FAQ Index
Back to Microsoft SQL Server: Setup and Administration Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close