how can we use sqlwebrestore

[hamed23100]

i need to know how can i restore sql server databases to websites. is there any special software or webpage to do this? i have plesk power pack.

 

[OlegB]

What kind of databases you want to get restored:
MSSQL, MySQL?
What kind of backup do you have?

 

[hamed23100]

the database i want to restore is mssql you can see an example of the thing i really need at http://70.86.149.218/sqlwebrestore

 

[OlegB]

Unfortunately this link is not working.
But I can give a tip. If you have a separate MSSQL database backup you restore into Plesk.
You need just create this database and DB user within Plesk and restore content using osql.exe tool.

C:\Program Files\SWsoft\Plesk\admin\bin>osql -E
1> restore database mydb from disk = "c:\mydb.mssql.bkp" with replace;
2> go
Processed 80 pages for database 'mydb', file 'mydb' on file 1.
Processed 1 pages for database 'mydb', file 'mydb_log' on file 1.
RESTORE DATABASE successfully processed 81 pages in 0.047 seconds (13.987 MB/sec).
1>quit

Something like that.

 

[hamed23100]

hi
the problem that you cant see http://70.86.149.218/sqlwebrestore was because their server was down. it is up now please check it again.
http://70.86.149.218/sqlwebrestore