How can I retrieve the logical file name of the database from backup file

DECLARE @Table TABLE (LogicalName varchar(128),[PhysicalName] varchar(128), [Type] varchar, [FileGroupName] varchar(128), [Size] varchar(128), [MaxSize] varchar(128), [FileId]varchar(128), [CreateLSN]varchar(128), [DropLSN]varchar(128), [UniqueId]varchar(128), [ReadOnlyLSN]varchar(128), [ReadWriteLSN]varchar(128), [BackupSizeInBytes]varchar(128), [SourceBlockSize]varchar(128), [FileGroupId]varchar(128), [LogGroupGUID]varchar(128), [DifferentialBaseLSN]varchar(128), [DifferentialBaseGUID]varchar(128), [IsReadOnly]varchar(128), [IsPresent]varchar(128), [TDEThumbprint]varchar(128) ) DECLARE @Path varchar(1000)=’C:\SomePath\Base.bak’ DECLARE @LogicalNameData varchar(128),@LogicalNameLog varchar(128) INSERT INTO @table EXEC(‘ RESTORE FILELISTONLY FROM DISK=”’ +@Path+ ”’ ‘) SET @LogicalNameData=(SELECT LogicalName FROM @Table WHERE Type=”D”) …

Read more

rsync prints “skipping non-regular file” for what appears to be a regular directory

Are you absolutely sure those individual files are not symbolic links? Rsync has a few useful flags such as -l which will “copy symlinks as symlinks”. Adding -l to your command: rsync -rtvpl /source/backup /destination I believe symlinks are skipped by default because they can be a security risk. Check the man page or –help …

Read more

restoring git repository from bundle backup

Short answer: $ git bundle verify $somewhere/foo.bundle $ git clone $somewhere/foo.bundle Cloning into ‘foo’… Receiving objects: 100% (10133/10133), 82.03 MiB | 74.25 MiB/s, done. Resolving deltas: 100% (5436/5436), done. $ cd foo $ git status … Lazy Badger said this, but it’s in the last paragraph. 🙂

How do you back up your development machine? [closed]

There’s an important distinction between backing up your development machine and backing up your work. For a development machine your best bet is an imaging solution that offers as near a “one-click-restore” process as possible. TimeMachine (Mac) and Windows Home Server (Windows) are both excellent for this purpose. Not only can you have your entire …

Read more