If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
We have a situation where we have to transfer all tables from MS SQL database to another nightly. But we want to keep
the logins as it is for each server/database. The database is a bout 60 GB. What is the fastest and the most efficient way
to accompolish this task. We plan to recreate the indexes nightly as well.
or you can backup/load, but just drop the users then add your desired users after the db is loaded. You can "ALTER index all rebuild" to rebuild the idxs.