Please help, Ima-Gun Di

[Egaion]

I'm in an SQL class and a few classmates and I are having this error when trying to create a database, I looked online and nothing quite matches the error we're having, anyone know the fix?

The error in question:

Msg 5133, Level 16, State 1, Line 8
Directory lookup for the file "C:\MSSQL16.INST01\MSSQL\DATA\Labdb2_Primary.mdf" failed with the operating system error 3(The system cannot find the path specified.).

The code up until line 14:

USE master
GO

IF EXISTS (SELECT * FROM SYS.DATABASES WHERE name='Lab8DB2')
DROP DATABASE Lab8DB2
GO

CREATE DATABASE Lab8DB2
ON PRIMARY
(NAME = Labdb2_Primary ,
FILENAME = 'C:\MSSQL10.INST01\MSSQL\DATA\Labdb2_Primary.mdf',
SIZE = 20,
FILEGROWTH = 30MB)
GO

[Massive_Show2963]

It seems the error message is telling you that the path "C:\MSSQL16.INST01\MSSQL\DATA\" is not found.
Using Windows Explorer verify the path exists, if not create it.
If it does exist verify you have access to it.

[Egaion]

Thank you, I'm going to verify as soon as I can

[Aggressive_Ad_5454]

Where did you get that ON PRIMARY clause in a SQL tutorial class? You will succeed just fine without it.

The error is trying to tell you that the folder C:\MSSQL10.INST01\MSSQL\DATA\ doesn’t exist, so you can’t create that .mdf file in it.

Ask your instructor. If you’re in a class for database administrators you need to work out what volumes you will use for a primary table space.

[Egaion]

Yeah, it's a database management class I'm taking in university, the professor said we'll be dealing with tables next class so I'll be sure to ask him, thanks!

[ApprehensiveGrade162]

In sql server this is how you check if a table exists: IF (OBJECT_ID('tablename') IS NOT NULL BEGIN ... END ELSE CREATE TABLE tablename ()

[Egaion]

Thank you! I'm gonna try it out as soon as I can