February 7, 2010 at 3:59 pm
I'm new to this, I am using the step by step sql 2008 book.
creating databases, I'm getting the error:
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\DATA\SQL2008SBS_1.R" failed with the operating system error 2(failed to retrieve text for this error. Reason: 15105).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\DATA\SQL2008SBSFS.1DF" failed with the operating system error 2(failed to retrieve text for this error. Reason: 15105).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
I think its permission related as I can parse it ok. not sure what to do next.
February 8, 2010 at 12:47 am
This was removed by the editor as SPAM
February 8, 2010 at 2:38 am
Hi and Thanx
I am setting it up on my lap top, which I'm administrator on.
this the SQL I'm using:
CREATE DATABASE SQL2008SBS ON PRIMARY
(NAME=N'SQL2008SBS', FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\MSSQL\DATA\SQL2008SBS.MDF',
SIZE=3MB,MAXSIZE=UNLIMITED,FILEGROWTH=10%),
FILEGROUP FG1 DEFAULT (NAME=N'SQL2008SBSFG1_DAT1',
FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\DATA\SQL2008SBS_1.R',
SIZE=2MB,MAXSIZE=UNLIMITED,FILEGROWTH=2MB),
(NAME=N'SQL2008SBSFG1_DAT2',FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\DATA\SQL2008SBS_2.R',
SIZE=2MB,MAXSIZE=UNLIMITED,FILEGROWTH=2MB),
(NAME=N'SQL2008SBSFG1_DAT3',FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\DATA\SQL2008SBS_3.R',
SIZE=2MB,MAXSIZE=UNLIMITED,FILEGROWTH=2MB)
LOG ON
(NAME=N'SQL20008SBS_LOG',FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\DATA\SQL2008SBS_.LDF',
SIZE=2MB,MAXSIZE=UNLIMITED,FILEGROWTH=10MB)
GO
CREATE DATABASE SQL2008SBSFS ON PRIMARY
(NAME=N'SQL2008SBSFS', FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\MSSQL\DATA\SQL2008SBSFS.MDF',
SIZE=3MB,MAXSIZE=UNLIMITED,FILEGROWTH=10%),
FILEGROUP DOCUMENTFILESTREAMGROUP CONTAINS FILESTREAM
(NAME=N'FILESTREAMDOCUMENTS',FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\DATA\SQL2008SBSFS')
LOG ON
(NAME=N'SQL2008SBSFS_LOG', FILENAME=N'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10.SQLEXPRESS\DATA\SQL2008SBSFS.LDF',
SIZE=2MB,MAXSIZE=UNLIMITED,FILEGROWTH=10MB)
GO
February 8, 2010 at 3:31 am
This was removed by the editor as SPAM
February 8, 2010 at 7:35 am
Thanxs
in the end I just ran the first line create..........
I'm now going to try and run a modify script to add the filegroup options and cross my fingers.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply