If I take a backup of a database on a SQL 2005 Server, and then restore that backup to a different (new) database on the same database server instance, what things will not be persisted (things like cached execution plans, statistics etc...)
A:
I am not sure if I have been doing it incorrectly or not, however, when I do a restore it never seems to carry over user information. I end up needed to re add them manually (or through another script).
northpole
2009-06-17 16:47:00
+3
A:
Plans will be recreated at first run.
Otherwise, everything database level will be there except where it interacts at the instance level, such as:
- replication
- backup jobs/schedules
- maintenance plans/schedules
- login mappings to users
For a standard, everyday database, you've no worries.
gbn
2009-06-17 16:48:58
also any custom stored procs that have been added to the "master" database
Ian Ringrose
2009-06-17 16:53:24
good point, I'd say this "instance level" though
gbn
2009-06-17 16:55:29
+1, you're over 8k now...
KM
2009-06-17 21:23:06
+2
A:
Orphaned Users are often the result of restoring MS SQL Server databases. Here's an article on fixing orphaned users.
jinsungy
2009-06-17 17:02:58