Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

CSharp TV
Videos
Tech
Articles
Blogs
News
Forums
Books
Events

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Latest Forum Questions

python training
devi G6h ago1
How do I open a dialog box that opens centered on the current dialog box?
Clyde Eisenbeis6h ago3
about azure app service
jahnavi charakani6h ago2
How to data fetch login form to order form nane email contact number
Abhishek Jagadale6h ago6
Which library is primarily used for numerical computing in Python?
tejasri1d ago4

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

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

Home
Forums
Visual Basic .NET

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

mahdiyeh m

11yAsked Sep 7, 2015, 6:51 AM917Visual Basic .NET

hi

I have a backup of the database.

now how do it restore on host(internet) ,with c#???

thank you .

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Raja T11y ago
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
0
mahdiyeh m11y ago
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??

0
Raja T11y ago
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
0