Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
5
Newest
 Scholar
Impact
~569 people reached

  • 0 posts edited
  • 0 helpful flags
  • 13 votes cast
Sep
5
awarded  Scholar
Sep
5
accepted Are there any problems with deploying an SQL Server database to a production server by taking a backup?
Sep
3
comment Are there any problems with deploying an SQL Server database to a production server by taking a backup?
I created the database from the script rather than the other way round, so I know there is nothing hard coded in 'my' data. It's more the metadata that SQL server stores behind the scenes - or potential lack thereof - that I was thinking about.
Sep
3
comment Are there any problems with deploying an SQL Server database to a production server by taking a backup?
I think it's better to avoid contamination than go with it and try to find it in testing, although my notion of 'contamination' is currently quite abstract and could be ungrounded.
Sep
3
comment Are there any problems with deploying an SQL Server database to a production server by taking a backup?
The question is really about an initial deployment, but realistically there will probably be a change at some point so a regard for that is prudent. Also bear in mind that a diligent script already exists, with all dependencies in the right order.
Sep
3
awarded  Editor
Sep
3
awarded  Student
Sep
3
comment Are there any problems with deploying an SQL Server database to a production server by taking a backup?
OK I've changed it to that
Sep
3
revised Are there any problems with deploying an SQL Server database to a production server by taking a backup?
edited title
Sep
3
comment Are there any problems with deploying an SQL Server database to a production server by taking a backup?
...because I am more interested in discovering unknown disadvantages of the approach than finding advantages that the DBA is already aware of
Sep
3
asked Are there any problems with deploying an SQL Server database to a production server by taking a backup?
Jan
13
awarded  Autobiographer
Dec
9
awarded  Supporter