Viewing 15 posts - 256 through 270 (of 342 total)
Check that the SQL Server service log-on account is a domain user and not the Local System account.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
November 9, 2004 at 6:26 pm
Markus, the point I raised on CPU usage was in comparing between native backups and 3rd party SQL Server backup tools. The native backup imposes almost no extra load on...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
November 5, 2004 at 11:51 pm
See here for a discussion on compression using standard compression tools (WinZip, WinRar etc) vs online backup/restore compression/decompression tools like MiniSQLBackup.
If you are comparing between the two, then online...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
November 4, 2004 at 11:34 pm
In SQL Server Books Online, look for point-in-time in the index.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
November 3, 2004 at 8:50 am
Simple log shipping? You must mean this.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 29, 2004 at 8:26 am
>> I realise that people are probably sick of hearing this type of thing by now ...
Not me. Thanks for the reminder.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 28, 2004 at 9:06 am
Well, for sure the backup will contain the new rows if the trxs have been committed by the time the backup ends.
According to Inside SQL2K by Kalen Dalaney, a...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 28, 2004 at 9:02 am
A backup contains everything you'll find in the database. Note that full-text catalogs are not stored in the database, so they are never backed up using the BACKUP command.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 27, 2004 at 8:31 pm
You can't use the WITH MOVE option when restoring differential backups. Also, you might try running the RESTORE HEADERONLY for both backups, and check if the CheckPointLSN for the full...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 27, 2004 at 8:26 pm
Restore the full database backup using the NORECOVERY or STANDBY options if you want to further apply differential or log restores e.g.
RESTORE DATABASE leon FROM .... WITH NORECOVERY
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 26, 2004 at 10:54 pm
The problem the OPs encountered is the failure to attach databases which were not originally detached. I wouldn't know the internals of the differences between a shutdown and a detach.
From...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 19, 2004 at 12:54 am
RESTORE LOG MyDatabase FROM DISK = 'Mytranslog.trn' WITH NORECOVERY
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 16, 2004 at 10:07 am
If you take a look at the problem that Jasper Smith solved in the post I mentioned, you would see that the user failed to even attach using sp_attach_single_file_db. Usually,...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 14, 2004 at 7:45 pm
Lukas, that was a very strange way to prove your point, as you could just as easily have ran sp_attach_db 'pubs', 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\pubs1.mdf', 'C:\Program Files\Microsoft SQL Server\MSSQL\DATA\pubs1_log.ldf'
Great for...
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 14, 2004 at 10:43 am
PowerDVD301_2_Data.MDF is just the name of the data file that needs to be 'attached' in the example. Replace it with the name of your mdf file.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
October 13, 2004 at 8:37 pm
Viewing 15 posts - 256 through 270 (of 342 total)