is it possible to use the current database, empty it out, then import ?

[Deleted user]

Situation:  cannot create a brand new database, but can delete all the tables , ignoring the errors

Seeking for you suggestion:  how to move a jira instance (running, but some problem) to this 'kind of' empty database ? 

1. should I do a backup , then restore on jira instance which based on this empty database  to give it try ?
2. should I just do import database ? 

Goal: instance running on a different database with previous data.

[Gaston Valente]

Quan,

You can delete all db objects (except the schema) and restore a db level backup into this database.

Do not start jira until the db backup is restored, jira tries to create the db objects if the db is empty

Then you update your db connection string to the new db.

[Deleted user]

I used SQL Management studio to migrate all data (tables and its content, by import),   while I am not clear about 'all db objects' , how to delete them ? 

how to restore a db level backup ? 

Would you give me some hints ? 

[Gaston Valente]

SQL Server usually creates backups with a .bak extension

You just need to find the correct backup and perform a Restore, it's really simple, here you can find more info:

https://msdn.microsoft.com/en-us/library/ms177429(v=sql.90).aspx

[Brant Schroeder]

Quan,

  I would do a fresh install of the same version of JIRA.  This will create the database for you.  You can then point you JIRA instance at the new DB.  If you do this there will be lots of issues. if you do not migrate the DB content as well.  I think it would be better to address the issues you are having.  Can you explain what those issue are and what you are hoping to accomplish by moving DB?  

[Deleted user]

We don't use embedded database, so installing a new jira, we still need a database to point to.

the new DB, can get database import from old DB, but my question was to ask about the new DB,  can it be just empty, no tables/data at all ? 

[Gaston Valente]

Yes! Jira will create all the objects for you