Hot answers tagged backup
Differential backups are backups of any changes to the DB since the last full backup. So in theory, yes, you could have it do a diff backup since some date (if you did a full backup on that date). Otherwise, no. It'll always be since the last full backup.
1.The restore history information is readily available inside the msdb i.e. msdb.dbo.restorehistory You can use below T-SQL code to find the start time and restore information of a database over a required period. DECLARE @dbname sysname, @days int SET @dbname = NULL --substitute for whatever database name you want SET @days = -1 --previous number of days, ...
Once you switch to Simple the Trans Log will no longer maintain a log of operations since your last (database files) backup - at the point of the switch all transactions will have been committed to the main database files so will not be discarded - they are already effective in the database files. Your point 1 is not (in my opinion) worth doing - once ...
Just take a full backup (with compression, if possible), restore it on the other server, and then you can select into or insert/select without having to worry about what happens to carriage returns, line feeds, and other characters that cause problems for files. You want to move (parts of) a database, not files. Trying to just extract some 120 million rows ...
Only top voted, non community-wiki answers of a minimum length are eligible