Create a "blank" database on the new SQL server (with the same name as the SCCM database, or copy the database files to the new SQL server and attach if you detached), and restore the the SCCM database to the new SQL server.jis5k 耐圧 How to attach and detach a database in SQL Server sql server - How to properly detach a MSSQL database Web I still have to attach the database to sql server. So I reinstalled my old system hard disk on my pc and had sql server detach the database after which I removed the hard disk and reinstalled the ssd drive. I got tired of trying to attach the database to the new instance of sql on the ssd drive. Yes, you can detach a database from SQL Server 2008 and attach it to a SQL Server 2012 instance, but the compatibility level of the database should be 90 or … sql - How to detach database and copy db file in local device.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |