Tag Info

Hot answers tagged

15

No, there is no workaround to upgrading a database directly from 2000 to 2012. Since you don't have a ton of data, you can do all kinds of things to move the data (but not the database as a whole), including: Import/Export wizard SSIS BCP Manual queries using a linked server from 2012 or an application However these will not necessarily bring over other ...


6

Stating there is no workaround seems a little premature. You say your database only contains a few tables and views. Why not export the tables and views schema as SQL create statements and run them on your target database? You could then also export the actual data into something like CSV format and import them into the target database, or perhaps even ...


4

No, the option is there for you so that you can decide to either: Kick all users out right now and restore immediately; or, let the restore operation wait until it can get exclusive access to the database before it begins. You can't restore and keep connections active, sorry. This is like changing the keg without interrupting someone actively pouring a ...


3

Full backup is not showing up because it has already been restored and no new latest info is there in msdb to reflect the same. Moreover, once msdb is updated with the backup info, it lets you avail with such info and in a manner of chain as followed in as LSN. However, you can do this manually by running below script on a specific database to retrieve ...


2

No, you cannot migrate it directly from 2000 to 2012. What you can do is install a temporary instance of 2005 OR 2008 oR 2008R2, restore the 2000 database here. Once done you can now upgrade from installed instance by taking the backup of database from that instance and restoring onto sql server 2012. You will have to make the migration in two steps: ...



Only top voted, non community-wiki answers of a minimum length are eligible