MSSQL - paulvi/notes GitHub Wiki

from https://social.msdn.microsoft.com/Forums/sqlserver/en-us/3d7bc9b8-7c2d-4d94-88ca-f72885bec342/create-a-new-database-from-existing-mdf-file?forum=transactsql

USE [master] GO CREATE DATABASE [BiblePeople] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\BiblePeople.mdf' ), ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\BiblePeople.log' ) FOR ATTACH GO

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf#datadir mkdir /data sudo chown mssql /data sudo chgrp mssql /data

scp ./NVCPS_New.mdf [email protected]:/data

USE [master] GO CREATE DATABASE [NVCPS] ON ( FILENAME = N'/data/NVCPS.mdf' ), ( FILENAME = N'/data/NVCPS.log' ) FOR ATTACH GO

CREATE DATABASE [NVCPS] ON ( FILENAME = N'/data/NVCPS.mdf' ),( FILENAME = N'/data/NVCPS.log' ) FOR ATTACH GO

CREATE DATABASE [NVCPS] ON ( FILENAME = N'/data/NVCPS.mdf' ) FOR ATTACH GO

1> CREATE DATABASE [NVCPS] ON ( FILENAME = N'/data/NVCPS.mdf' ) FOR ATTACH 2> go Msg 1813, Level 16, State 2, Server localhost, Line 1 Could not open new database 'NVCPS'. CREATE DATABASE is aborted. File activation failure. The physical file name "D:\NVCPS\MsSQL_DataBase\MSSQL10.MSSQLSERVER\MSSQL\DATA\NVCPS_New_log.ldf" may be incorrect. The log cannot be rebuilt when the primary file is read-only.

/var/opt/mssql/data

chmod u+wr ./NVCPS.mdf chmod g+r ./NVCPS.mdf to make it -rw-r-----. like all other in /var/opt/mssql/data

CREATE DATABASE [NVCPS] ON ( FILENAME = N'/var/opt/mssql/data/NVCPS.mdf' ) FOR ATTACH GO

1> CREATE DATABASE [NVCPS] ON ( FILENAME = N'/var/opt/mssql/data/NVCPS.mdf' ) FOR ATTACH 2> go File activation failure. The physical file name "D:\NVCPS\MsSQL_DataBase\MSSQL10.MSSQLSERVER\MSSQL\DATA\NVCPS_New_log.ldf" may be incorrect. New log file '/var/opt/mssql/data/NVCPS_log.ldf' was created. Converting database 'NVCPS' from version 655 to the current version 869.