Tag Info

Hot answers tagged

2

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.


2

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, ...


1

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 ...


1

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