Database Change Management
Database Change Management
Home | Profile | Register | Active Topics | Active Polls | Members | Private Messages | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?




 All Forums
 Support
 DB Ghost Support Forum
 Error when creating database
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Shazam


3 Posts

Posted - 12/18/2006 :  18:08:16  Show Profile Send Shazam a Private Message  Reply with Quote
I keep getting an error message when trying to a create a database in the Database Change Manager:

"Invalid usage of the option _Log in the CREATE/ALTER DATABASE statement"

Using SQL Server Profiler, there is an ALTER DATABASE sent that looks like this:

"ALTER DATABASE [xxx] MODIFY FILE (NAME = xxx _Log,MAXSIZE = UNLIMITED)"

Note the space before the "_Log".

I'm using SQL Server version 9.00.2153.00.

Google AdSense

USA
Mountain View


leachm



125 Posts

Posted - 12/19/2006 :  02:36:32  Show Profile  Click to see leachm's MSN Messenger address Send leachm a Private Message  Reply with Quote
Could you script the CREATE DATABASE statement from the database that you are selecting as the template for the build and paste it in here as a reply please?

regards,

Malcolm Leach
You must be logged in to see this link.
DB Ghost Build, Compare and Synchronize = Change Management for SQL Server
Go to Top of Page

Shazam



3 Posts

Posted - 12/19/2006 :  10:11:27  Show Profile Send Shazam a Private Message  Reply with Quote
I got it to work. My original database had spaces in the filenames, which I guess were used for the new database. I removed the spaces and everything worked.
Go to Top of Page

leachm



125 Posts

Posted - 12/30/2006 :  07:59:42  Show Profile  Click to see leachm's MSN Messenger address Send leachm a Private Message  Reply with Quote
This issue has been fixed in the latest version of DB Ghost - 4.5.1407 and is now live on the website

regards,

Malcolm Leach
You must be logged in to see this link.
DB Ghost Build, Compare and Synchronize = Change Management for SQL Server
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Jump To:
Database Change Management © Copyright 2005 Innovartis Ltd. Go To Top Of Page
Snitz Forums 2000
RSS Feed 1 RSS Feed 2
Powered by ForumCo 2000-2008
TOS - AUP - URA - Privacy Policy
ForumCo Free Blogs and Galleries
Signup for a free forum or Go Banner Free