128 reputation
15
bio website stackoverflow.com
location United States
age 35
visits member for 2 years, 4 months
seen Jun 28 '13 at 16:23
I code, therefor I am.

Dec
6
awarded  Notable Question
Oct
31
awarded  Popular Question
Dec
7
awarded  Student
Dec
7
awarded  Supporter
Dec
7
awarded  Scholar
Dec
7
comment Restoring SQL Server databases - tips and tricks?
"I had exactly the problems you had on sqlserver 7 when I had a primary / slave setup based on replication. The day I switched the slave as a master I had to reseed all the identity columns and process all the grants manually. This was not a surprise this was because replication does not replicate system tables and because the identity columns were set as "NOT FOR REPLICATION"." This was it. I did restore a backup...but it was a backup of the slave database in a log-shipping setup. Thanks!
Dec
7
accepted Restoring SQL Server databases - tips and tricks?
Nov
30
comment Restoring SQL Server databases - tips and tricks?
I ran the backup on one server (right click on DB, All Tasts, Backup), created a .bak file, transferred the .BAK file, and then right clicked on the other server/instance, and selected Restore Database, and pointed it at the .BAK file.
Nov
28
awarded  Autobiographer
Nov
28
asked Restoring SQL Server databases - tips and tricks?
Mar
31
asked SQL Server 2008 Table Maintenance - Rebuild, Reorganize, Update Stats, Check Integrity etc