Tag Info

New answers tagged


Since the database is ONLINE, you have two main options: Create a new database with the same schema for [PRIMARY] filegroup objects as the old database, and transfer data using any of the tools available (e.g. SSIS, bcp, linked server). Depending on the complexity of the existing schema, constraints, and relationships (e.g. foreign keys) this may be quite ...

Top 50 recent answers are included