SQLTeam.com | Weblogs | Forums

Using sql without changing the program settings



I'm new to SQL and would like to know if it is possible to "save as" (MS office) to make sure that the program where the original database is used for will still work. The second (saved as) database should not be connected to the program, I only need it to retrieve information inside the database.


Sounds like you should take a BACKUP of your database. If you want to experiment with it, safely outside the scope of the main database, then you can RESTORE it to a differently named database, and then experiment with the copy-database. You APP will still be connected to the originally-named database

It would be safer if you restore the database to a different machine - you can use SQL on a PC/Laptop, locally, if that would suit you (and you have enough disk space etc.)