Hi All,
Thank you for your everyones kind support. But i did not get the info.what im expected.
Actually i would like to create new database in microsoft sql server management studio 214 using .sql file (its size was 5.89GB).
I need to know the proper steps and procedures..If i import this file to MSSQL server management studio getting error, if not I used the below script:
USE master ;
GO
CREATE DATABASE maximo_2
ON
( NAME = Sales_dat,
FILENAME = 'c:\testtdatt.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = maximo_log,
FILENAME = 'c:\testtlogg.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB ) ;
GO
comment executed successfully.But i could not able to view my database, .mdf and .ldf file could not be executed too.
Im really not too sure how to get my new database in proper manner.
Dear Experts please kindly give me a suggestion. Really need your great help.
Thanks.