Guys,
I am actually scripting the database from the scratch and I tried it on my local machine. and it was fine.
CREATE DATABASE [ISO_DB] ON PRIMARY
( NAME = N'ISO_DB',
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10.EXPRESS\MSSQL\DATA\ISO_DB.mdf' ,
SIZE = 2048KB ,
MAXSIZE = UNLIMITED,
FILEGROWTH = 1024KB
)
LOG ON (
NAME = N'ISO_DB_log',
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10.EXPRESS\MSSQL\DATA\ISO_DB_log.ldf' ,
SIZE = 1024KB ,
MAXSIZE = 2048GB ,
FILEGROWTH = 10%)
GO
But I have to create a script on the development server and the server is a vitual server and the only information I have is the I.P of the machine. I have admin privileges to the machine. The server on which the sql server is installed does not have any physical name as such that I am aware of. I am actually not sure as to how to show the path of the server.. any ideas as to how to handle this issue.
thanks!