Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2004-05-21 : 04:58:48
|
| What are the actvities need to be performed once the DB is migrated from on server to another server so that the DB at the new server performs at its best.Thak you.------------------------I think, therefore I am |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-21 : 12:23:21
|
| Update statistics, DBCC DBREINDEX, SQL Profiler trace, and Performance Monitor data capturing.Tara |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-21 : 15:22:36
|
| You also need to migrate the logins after you get done migrating the databases. Otherwise, nobody will be able to access your databases. Search for sp_help_revlogin to do that. It's not a bad idea to detach all your user databases from the old server and leave a security trace on it to trace failed logins. You can capture HostName, ApplicationName, and ClientProcessID to figure out the application and PID if you missed any in the cutover.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-05-22 : 05:10:12
|
quote:
Originally posted by derrickleggett
a security trace on it to trace failed logins.
What's the best way to do that?I'm thinking about something I can do to try to check for people hacking in (rather than just getting failed logins to pile up in the Event Log with everything else ...)Kristen |
|
|
|
|
|
|
DB migration