Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 5
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
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