Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 7.0 Database scripting

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-04-08 : 07:40:07
Johan writes "I have a database of 7.5 Gig and i get the following error when i'm trying to do Database scripting of my Data base.

The error is as follows Error2:(SQL-DMO) Createfile error on EHD.PWP2003.DP1. The system cannot find the file specified.

PWP2003 is my Database name.EHD is the Server Name.

Thank you
Johan"

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2003-04-08 : 12:57:17
few things you want to check out
1. Whether the SQL Server Service Startup account is a domain admin to where your machine is?(Trust, Share and Security included)
2. Whether the service acccount has the permission to write the file to the folder you want to create. Error2 is a user error.
This is most likely solvable if you try to script the db from the physical db server itself.
Let us know what you find.

Go to Top of Page
   

- Advertisement -