how to restore sql server database on host(internet) with c#

Question

hi I have a backup of the database. now how do it restore on host(internet) ,with c#??? thank you .

Raja T · Answer

Hi, I think u don't have admin rights please check it. More details check bellow URLs http://www.sqlbackuprestore.com/backupandrestorerights.htm http://stackoverflow.com/questions/18059688/how-to-restore-database-in-servers-sql-server-database http://ukwebhostblog.com/user-does-not-have-permission-to-restore-database

mahdiyeh m · Answer

i run commands ,but get error . con.ConnectionString = "Server=Ip;Database=namedatabase;User Id=id;Password=pass"; SqlCommand cmd = new SqlCommand("ALTER DATABASE namedatabase SET SINGLE_USER with ROLLBACK IMMEDIATE " + " USE master " + " RESTORE DATABASE namedatabase FROM DISK=N'" + path + "' WITH REPLACE"); .... note: path is="d:\bakdatabase.bak"; message error: User does not have permission to RESTORE database RESTORE DATABASE is terminating abnormally. Changed database context to 'master'. how to fix error??

Raja T · Answer

Hi, Checkout bellow urls http://stackoverflow.com/questions/5984553/c-sharp-express-back-up-restore-database https://social.msdn.microsoft.com/Forums/sqlserver/en-US/95750bdf-fcb1-45bf-9247-d7c0e1b9c8d2/how-do-you-backup-a-database-using-sql-server-2005-express?forum=sqlexpress