titsiros (11/29/2015)
But why is this a temporary solution, is there a problem with leaving it on external and keep it plugged in?
None, until it gets accidentally unplugged, dropped, borrowed for other use, etc. Plus, unless it's a USB 3 drive, it's going to be slower than internal drives
If I cant delete any table/records, what are my options of reducing the db size?
None, unless there's already a lot of free space in the files
If i simply copy&paste files to internal drive will sql server automatically repoint to new location or i have to change something under Databases?
You have to tell SQL where the files went. Look up ALTER DATABASE command.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability