How to import an existing MS SQL database into subscription

[Mark_McNeece]

Hi!

I'm brand new to Plesk so forgive me if I'm asking a silly question here...

I've created a website for a client using Sitefinity CMS and MS SQL Server 2008 R2. I've transferred the database from my local SQL server to the production server using SQL Management Studio.

I've created a customer and subscription for hosting the website and it's all up and running perfectly. However, I want to automate the backup of the SQL database for the website which I can only do if the subscription knows about the SQL database for that website. So, how do I associate the two? How do I get the database to show up in plesk for that customer such that it can be part of the scheduled backups - and of course also somethign I could restore via plesk if I had too?

Does that make sense? I hope so. The database exists. It wasn't create via plesk in any way, but I want plesk to be able to back it up, and ideally for it to show up in the customers subscription, etc.

Many thanks in advance

- Mark

 

[IgorG]

You can create empty database with the same name in Plesk for this subscription and after that import dump of your database to this new database.