-- Database resotre scriptleri -- Önce restore yapacağınız folder üzerinde mssql kullanıcısının yetkisini vermeniz gerekmektedir. -- sudo chown -Rfv mssql:mssql /home/cuneyd/MSSQLSERVER
USE [master] RESTORE DATABASE [DBACHECKDB] FROM DISK = N'/BACKUPFILES/DBACHECKDB_backup_2017_10_09_040401_5805171.bak' WITH FILE = 1, MOVE N'DBACHECKDB' TO N'/storage/mssqlserver/DATA/DBACHECKDB.mdf', MOVE N'DBACHECKDB_Log' TO N'/storage/mssqlserver/LOG/DBACHECKDB_Log.ldf', RECOVERY, NOUNLOAD, STATS = 5 USE [master] RESTORE DATABASE [NebimV3AuditTrail_backup] FROM DISK = N'/BACKUPFILES/NebimV3AuditTrail_backup_2017_10_09_040401_6054324.bak' WITH FILE = 1, MOVE N'NebimV3AuditTrail' TO N'/storage/mssqlserver/DATA/NebimV3AuditTrail.mdf', MOVE N'NebimV3AuditTrail_Log' TO N'/storage/mssqlserver/LOG/NebimV3AuditTrail.ldf', RECOVERY, NOUNLOAD, STATS = 5 USE [master] RESTORE DATABASE [NebimV3Master] FROM DISK = N'/BACKUPFILES/NebimV3Master_backup_2017_10_09_040401_6115862.bak' WITH FILE = 1, MOVE N'NebimV3Master_Data' TO N'/storage/mssqlserver/DATA/NebimV3Master_Data.mdf', MOVE N'NebimV3Master_Log' TO N'/storage/mssqlserver/LOG/NebimV3Master_Log.ldf', RECOVERY, NOUNLOAD, STATS = 5 USE [master] RESTORE DATABASE [GURMEN] FROM DISK = N'/BACKUPFILES/GURMEN_backup_2017_10_01_001002_0563985.bak' WITH FILE = 1, MOVE N'GURMEN_Data' TO N'/storage/mssqlserver/DATA/GURMEN_Data.mdf', MOVE N'NonClusteredIdxFile' TO N'/storage/mssqlserver/DATA/NonClusteredIdxFile_data.ndf', MOVE N'CDCTBLOGFILE' TO N'/storage/mssqlserver/DATA/CDCTBLOGFILE.ndf', MOVE N'NEBIMLOGTBLFILE' TO N'/storage/mssqlserver/DATA/NEBIMLOGTBLFILE.ndf', MOVE N'GURMEN_Log' TO N'/storage/mssqlserver/LOG/GURMEN_Log.ldf', NORECOVERY, NOUNLOAD, STATS = 5 RESTORE DATABASE [GURMEN] FROM DISK = N'/BACKUPFILES/GURMEN_backup_2017_10_09_020201_2238752.diff' WITH FILE = 1, NOUNLOAD, STATS = 5, KEEP_CDC
