Home Forums SQL Server 2012 SQL 2012 - General Faster way to move all the data from one database to another ( without backups)? RE: Faster way to move all the data from one database to another ( without backups)?

  • This one I try to use it as something to learn how to move large amounts of data, so I do not mind spending some time doing it, will try the bcp path, thanks

    for the filegroup it had a separate file, was set offline, it is possible to remove the filegroup but not the physical file, when I try to do that I get this:

    Msg 5056, Level 16, State 2, Line 1

    Cannot add, remove, or modify a file in filegroup 'FG_lost' because the filegroup is not online.