Viewing 4 posts - 1 through 4 (of 4 total)
Also, whenever you restore databases, you typically run into "Orphaned Users" (mismatch between
Logins and Users)
EXEC sp_change_users_login 'update_one','login','user' to fix that.
http://www.akadia.com/services/sqlsrv_logins_and_users.html%5B/url%5D has some info on it
April 8, 2010 at 1:15 pm
yes exactly...you shouldnt be making modifications to the Master database.
1) DTS has Transfer Logins & Transfer Stored Procs tasks. Look into that.
2) you could copy the .MDF and .LDF...
April 8, 2010 at 1:09 pm
Having a separate physical disk for OS, Data, Logs and Backups make sense.
But a separate disk for tempdb seems like overkill..
I suppose it depends on what you are doing with...
April 8, 2010 at 10:42 am
Have you checked the SQL SERVER Logs?
perhaps you are hitting a file size limit? or a limit on the number of files?
Is it a DTS task that is waiting on...
April 7, 2010 at 11:21 am
Viewing 4 posts - 1 through 4 (of 4 total)