I am making backup for my tables in the database and I am generating scripts (from task) in SQL Server Management Studio.
There's about 30-40 tables that I am interested to backup including constraint,indexes, etc. I'm not doing a full backup. There's like 300 tables in the database. The entire database is so big and doing a full backup would take way too long, hence only backup certain tables.
However, in "Save or Publish script" screen, it's stuck there for very long claiming the tables are "preparing". Is there any solution to this?
Is it normal to wait that long? (1 hour)