We have a database system currently in SQL Server 2008 Express that we want to copy to a SQL Server 2012 server for testing. Having never moved a SQL Server database I have a few questions.
- Can I take a full backup without taking the database offline?
- Our database is 6Gb, however our
.LDFfile is over 200Gb. Can I take just a backup of the data and not bring over the transaction log?
- Is the right click Backup in SSMS better/worse than doing
BACKUP DATABASEin T-SQL?
Just making sure I have my ducks in a row since I don't have a current test DB with any real data to test the process. Thanks!