Jacque Scott
asked on
Creating scripts to copy db schema only, no data, to another server. MSSQL
I need to copy the database structure of one db onto another server. I don't need the data, just the schema. I went to tasks and generated scripts.
Here is a portion of the script I have a question on. Why did it create the .mdf file on the F:\\ drive? Since I am running the script on a different server I get an error.
Directory lookup for the file "F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ ProLaw.mdf " failed with the operating system error 3(The system cannot find the path specified.).
Here is a portion of the script I have a question on. Why did it create the .mdf file on the F:\\ drive? Since I am running the script on a different server I get an error.
Directory lookup for the file "F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\
CREATE DATABASE [ProLaw] ON PRIMARY
( NAME = N'ProLaw_Data', FILENAME = N'F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ProLaw.mdf' , SIZE = 19710784KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'ProLaw_Log', FILENAME = N'F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ProLaw_log.ldf' , SIZE = 7616KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
ALTER DATABASE [ProLaw] SET COMPATIBILITY_LEVEL = 90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [ProLaw].[dbo].[sp_fulltext_database] @action = 'disable'
end
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.