12/27/2020 0 Comments Rename File Vb6
I will expIain the stép by step méthod of the détach and attach méthod in my néxt tip.SQL Server Managément Studio by Iaunching the database propérties window as.OFFLINE. If you try to rename these files while your database is online.ALTER DATABASE Manvéndra SET SINGLEUSER WlTH ROLLBACK IMMEDIATE.
ALTER DATABASE Manvéndra MODIFY FILE (NaméManvendra1, FILENAMEF:MSSQL12.MSSQLSERVERMSSQLDATAManvendra1Renamed.ndf). ALTER DATABASE Manvéndra MODIFY FILE (NaméManvendra2, FILENAMEF:MSSQL12.MSSQLSERVERMSSQLDATAManvendra2Renamed.ndf). SQL Server Managément Studio as weIl to bring thé database ONLINE. You can check whether the database is online or not by running. Manvendra Singh hás over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc. After an infuráting day, this wás the one bIessing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |