Hi; I had created a database in my pc, when i reinstalled another windows now there are lots of errors because there is no connection. how to rectify my database, and in case of reinstallation of windows what to do preventing the same problem? everytime should i install the sql server and recreate the tables or there is another solution?
if you are planning to reinstall os,it will be good you take the database backups on some seperate disk. so that you dont have to create the databases each time you install sqlserver.you could do a restore instead.