Viewing 15 posts - 76 through 90 (of 342 total)
Agree with Grant re. the need to actually restore from a database backup to ensure it's recoverable.
RESTORE VERIFYONLY is fairly useless (with regards to data integrity in the backup set)...
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.
December 29, 2010 at 9:32 pm
A backup of a database does not need create a temporary file anywhere. SQL Server writes the backup data directly to disk, even if it was to a network...
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.
December 29, 2010 at 9:27 pm
Try the suggestions in this article and its sub-articles. Provides some tests you could run.
Thanks.
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.
December 28, 2010 at 8:15 am
When you restore a database from a backup set, the size of the data files and transaction log files will be identical to that of the database at the time...
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.
December 28, 2010 at 4:21 am
We take full backup of the db's daily and all of a sudden we start seeing this error for last 3 days for one particular db. Nothing has changed and...
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.
December 8, 2010 at 7:36 pm
Are you backing up to an existing file? That's probably the case, and the existing file contains a backup set that was split across 2 files. If you...
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.
December 8, 2010 at 1:00 am
Using the PASSWORD option in SQL Server backups only require that you be able to supply the same password during restore operations. It does not encrypt the data in...
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 23, 2010 at 5:29 am
With regards to the errors in the event log, it appears that the Litespeed backup process terminated the backup operation. I would suggest looking for any logs that Litespeed...
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 2, 2010 at 9:37 am
sql_lock (11/2/2010)
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/10/27/sql-server-backup-simulator.aspx?
The credit has to go to @andrew Kelly for his blog post last week..
http://sqlblog.com/blogs/andrew_kelly/archive/2010/10/28/sql-server-backup-simulator.aspx
NOTE: Read the...
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 2, 2010 at 9:35 am
It looks like the Litespeed backup process aborted the backup.
As mentioned by Pradeep, look in the SQL Server error logs to check if there are more informative error messages in...
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 1, 2010 at 7:39 am
For example, from FULL BAKCUP A to FULL BACKUP B, we have a log chain. If you issue a FULL backup C without COPY_ONLY between A and B, then, you...
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 22, 2010 at 10:35 pm
Have you manually check if you are able to read/write to the network share, perhaps using Windows Explorer, when logged on as the same account as that used by your...
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 21, 2010 at 11:27 pm
it says if the estimated number of rows are very different from the actual number of rows then it means there are bad statistics on the database.
For large tables, SQL...
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, 2010 at 9:38 pm
Here's something I wrote some time back on improving backup speed: Speeding up backups
Hope this helps some.
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, 2010 at 7:36 pm
Have you tried creating the same user account, with the same passwords, on both machines, and use that account as the SQL Server Agent service startup 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.
October 19, 2010 at 7:29 pm
Viewing 15 posts - 76 through 90 (of 342 total)