Als we een database aanmaken geeft hij de volgende fout weer. Weet iemand hiervoor de oplossing ? Dit wordt gebouwd in SQL manager 2008
CREATE DATABASE [new_db]
ON PRIMARY
( NAME = [datalift],
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\datalift_Data.mdf',
SIZE = 3 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 10 % )
LOG ON
( NAME = [datalog],
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\datalog_Log.ldf',
SIZE = 3 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 10 % )
COLLATE SQL_Latin1_General_CP1_CI_AI
GO
ALTER DATABASE [new_db]
SET RECOVERY FULL
GO
/* Could not obtain exclusive lock on database 'model'. Retry the operation later.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. */
CREATE DATABASE [new_db]
ON PRIMARY
( NAME = [datalift],
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\datalift_Data.mdf',
SIZE = 3 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 10 % )
LOG ON
( NAME = [datalog],
FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\datalog_Log.ldf',
SIZE = 3 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 10 % )
COLLATE SQL_Latin1_General_CP1_CI_AI
GO
ALTER DATABASE [new_db]
SET RECOVERY FULL
GO
/* Could not obtain exclusive lock on database 'model'. Retry the operation later.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. */
