i learning back-end development developing c# web service interacts database. not sure, however, database supposed kept. supposed in same location web service hosted?
[1]yes,usually hosting provider provide database of chosen plan shared hosting/vps hosting/dedicated server.so should keep database in hosted environment.
[2]take backup , keep copy of local system ftp transfer.
