Tag Info

Hot answers tagged

9

This is just a matter of using dynamic SQL to process your data. You can also leverage msdb.dbo.backupset and msdb.dbo.backupfamily to find your most recent full backups. This script will get the most recent full backup file location for each database and use it to run your cursor: declare @dbname sysname ,@backupfile nvarchar(max) ,@sqlcmd ...


3

Yes, you can issue ROLLFORWARD after restoring an offline backup. The ROLLFORWARD command syntax remains the same, regardless of the type of restored backup image.


3

I started writing this in comments, but quickly ran out of space so I'm putting in this answer. The way backups work with FULL recovery in SQL Server you can do what you want with transaction and differential backups (as said in the comments). A transaction log has all the statements since the last linked backup (be it a full, differential or trn backup). ...


2

Whoever told you "When rolling forward to end of logs without specifying overflow log path only active logs will be read" was wrong. When you have LOGARCHMETH1 set to DISK, TSM, USEREXIT or VENDOR, the DB2 log manager EDU (db2logmgr) is responsible for moving log files to and from the archive location. When performing a ROLLFORWARD operation, DB2 will ...


2

If you archive logs to a location different from the active log directory (logpath database configuration parameter), you need to specify the clause overflow log path /path/to/archived/logs. The ROLLFORWARD command does not do it automatically. PS. You really should start reading manuals -- they are full of useful stuff, including multiple examples...


1

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

Doing this C:> mysqldump -uroot -p abc > abc.sql does not include the two lines you mentioned. On the Prod Server, do this C:> mysqldump -uroot -p --databases abc > abc.sql Using --databases abc makes mysqldump write those two lines On the Staging Server, do this C:> mysql -uroot -p < abc.sql Don't specify abc upon reload. Those ...


1

Since you said you are beginner and is in learning phase I would give you lot of good articles to learn about SQL Server backup. To start with main question as already mentioned in my comment So can I restore 4th one with 1st one. With out the 3rd ? Differential backup only relates to previous full backup you have taken so NO you cannot restore 4th ...



Only top voted, non community-wiki answers of a minimum length are eligible