Nie napisałeś jaki błąd, ale skoro bazy się nie tworzą to, problemem będzie ta część:
CREATE DATABASE [CanaryAirlines] ON PRIMARY
( NAME = N'CanaryAirlines', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\CanaryAirlines.mdf' , SIZE = 69632KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'CanaryAirlines_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\CanaryAirlines_log.ldf' , SIZE = 901312KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
a dokładnie ścieżka do pliku mdf/ldf: C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\
zanim rozpoczniesz puszczenie skryptu puść taki:
IF EXISTS(SELECT 1 FROM [master].[sys].[databases] WHERE [name] = 'zzTempDBForDefaultPath')
BEGIN
DROP DATABASE zzTempDBForDefaultPath
END;
-- Create temp database. Because no options are given, the default data and --- log path locations are used
CREATE DATABASE zzTempDBForDefaultPath;
--Declare variables for creating temp database
DECLARE @Default_Data_Path VARCHAR(512),
@Default_Log_Path VARCHAR(512);
--Get the default data path
SELECT @Default_Data_Path =
( SELECT LEFT(physical_name,LEN(physical_name)-CHARINDEX('\',REVERSE(physical_name))+1)
FROM sys.master_files mf
INNER JOIN sys.[databases] d
ON mf.[database_id] = d.[database_id]
WHERE d.[name] = 'zzTempDBForDefaultPath' AND type = 0);
--Get the default Log path
SELECT @Default_Log_Path =
( SELECT LEFT(physical_name,LEN(physical_name)-CHARINDEX('\',REVERSE(physical_name))+1)
FROM sys.master_files mf
INNER JOIN sys.[databases] d
ON mf.[database_id] = d.[database_id]
WHERE d.[name] = 'zzTempDBForDefaultPath' AND type = 1);
--Clean up. Drop de temp database
IF EXISTS(SELECT 1 FROM [master].[sys].[databases] WHERE [name] = 'zzTempDBForDefaultPath')
BEGIN
DROP DATABASE zzTempDBForDefaultPath
END;
PRINT @Default_Data_Path;
PRINT @Default_Log_Path;
Ten skrypt zwróci w wyniku ścieżkę do folderu danych (1 linijka i ścieżkę do folderu logów (2 linijka).
Podmień C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\DATA\
to co zwróci powyższy skrypt i powinno zadziałać dla MSSQL