SQL Server General DBA
How do you get rid of users that are already in the database on the backup server when a restore starts?
QuestionI’m trying to implement log shipping as described in your log shipping article, with a few slight modifications. The question I have is how do you get rid of users that are already in the database on the backup server when a restore starts? If someone is using the read-only capabilities when the restore starts, […]
Can you provide the scripts that you use to transfer (copy) logins from a primary server to a secondary server?
Here’s the script I use to move logins, along with the script I use to resynch login IDs and database user IDs after moving the logins. I did not write either one, but I have made some modifications to both of them for my own purposes. I would give credit to the original authors of […]
No, at least not using sp_detach_db, sp_attached_db; or backup and restore. But you can recreate the database schema in a database on a different version of the database and then use DTS or SSIS to move the data.
Importing data from Excel is a simple task if you are using SSIS. You can accomplish this by simply drag and dropping few controls and you are done. But what if your excel workbook has dynamic sheets, which means you will not know the sheet name. Excel Sheet Let us assume we need to import […]