Specify SQLNexus Database file path?

Nov 24, 2010 at 10:10 AM

Hi,

When you connect to a server using the SQLNexus software a SQLNexus database is automatically created on that server.

Is there anyway to specifiy where the Database files are created when you connect to a server?

Thanks

David

Coordinator
Nov 24, 2010 at 2:40 PM

The SQL Nexus database files are created in the default data/log directory locations provided for the SQL Server instance. They can be changed for the instance using the following:

http://msdn.microsoft.com/en-us/library/ms143547.aspx

There is no mechanism currently in SQL Nexus to provide the database location while creating it using the Nexus GUI. You could however create the SQL Nexus database before hand at the desired location and then use SQL Nexus to import data into the already created Nexus database.

Nov 24, 2010 at 3:05 PM

Ok thanks amitban,

David