Subscribe to this blog
James' SQL Footprint
Love SQL Server, Love life.
Archives: September 2012
Change file logical name for mirror database
Today I encountered a interesting issue when rename logical name for mirror database.
We have a database which has been setup mirror on it, and we need to change the logical file name for data and log file. As usually, I rename the logical name by SSMS on the primary server(SQL01),…
We have a database which has been setup mirror on it, and we need to change the logical file name for data and log file. As usually, I rename the logical name by SSMS on the primary server(SQL01),…
0 comments, 973 reads
Posted in James' SQL Footprint on 9 September 2012