son8989
یک شنبه 22 اردیبهشت 1392, 17:35 عصر
سلام من یه مشکلی دارم میخوام پایگاه داده روداخل کوئری ایجاکنم اما نمیدونم چرا نمیشه کسی از دوستان اگه میتونه مشکلشو بهو بگه
use master
GO
CREATE DATABASE Apress ON primary
(NAME =N'Apress',
FILENAME =N'C:\Program Files\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\
Apress.mdf',SIZE =3072KB ,
MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
(NAME =N'Apress_Log',
FILENAME = N'C:\Program Files\Microsoft SQL
SERVER\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\
Apress_log.ldf',
SIZE = 1024KB , MAXSIZE = 204GB, FILEGROWTH = 10%)
COLLATE SQL_latin1_General_CP1_CI_AS
GO
پیامی که بهم میده :
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATAApress.mdf" failed with the operating system error 123(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.
use master
GO
CREATE DATABASE Apress ON primary
(NAME =N'Apress',
FILENAME =N'C:\Program Files\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\
Apress.mdf',SIZE =3072KB ,
MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
(NAME =N'Apress_Log',
FILENAME = N'C:\Program Files\Microsoft SQL
SERVER\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\
Apress_log.ldf',
SIZE = 1024KB , MAXSIZE = 204GB, FILEGROWTH = 10%)
COLLATE SQL_latin1_General_CP1_CI_AS
GO
پیامی که بهم میده :
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATAApress.mdf" failed with the operating system error 123(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.