Interview Questions
1. How do I move or rename files for databases involved in replication?
In versions of SQL Server prior to SQL Server 2005, moving or renaming database files required detaching and reattaching the
database. Because a replicated database cannot be detached, replication had to be removed from these databases first.
Beginning with SQL Server 2005, you can move or rename files without detaching and re-attaching the database, with no
effect on Replication
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment