Viewing 15 posts - 106 through 120 (of 342 total)
You could also download the free SQL Server backup file reader (SQL BAK Reader) that can read details of SQL Server backup files without needing to install the correct version...
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.
July 21, 2010 at 8:31 pm
Error messages when restoring from newer version of a backup file to older versions:
SQL Server 2008 R2 to SQL Server 2008
Msg 3169, Level 16, State 1, Line 1
The database was...
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.
July 21, 2010 at 8:19 pm
Using this for reference:
- run DBCC LOGINFO to see the status of the VLFs in the transaction log
- back up the transaction log
- run DBCC LOGINFO again, and see if...
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.
July 21, 2010 at 10:40 am
Your client is right. A full database backup does not break the chain of transaction log backups. They'll be able to use the last good full database backup, 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.
July 21, 2010 at 10:33 am
There isn't any extra steps required to restore a database created on a 32-bit SQL Server to a 64-bit SQL Server. Could you please post the entire result of...
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.
July 20, 2010 at 9:51 am
there is any option to recover the only drop table without affecting other tables cos lot of changes in other tables?
Find out the time the table was dropped as per...
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.
July 19, 2010 at 9:12 pm
... and then trying to restore it, then also I am receiving the same error as mentioned while i started the post....
That is strange. The error message...
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.
July 18, 2010 at 9:06 am
If it's of any help, Windows operating system error 23 reads as 'Data error (cyclic redundancy check)'.
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.
July 16, 2010 at 8:26 am
In this scenario whether the differential backup start backup from already exist full backup or takes from the scheduled full backup.
LOL. It depends. Both types of backups will...
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.
July 15, 2010 at 7:57 pm
Common reason for that error is because the SQL Server service startup account does not have rights to the remote share.
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.
July 14, 2010 at 11:07 am
No, you do not need to restart the SQL Server service. The change takes effect immediately.
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.
July 14, 2010 at 8:37 am
That explains why you originally wanted to restore over the network, as you don't have enough space to store both the bak file and the restored database.
Some options:
- shrink 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.
July 14, 2010 at 8:33 am
When i tried to restore the file from locally, it says there is insufficient space on the drive.
When you restore a full database backup, it will restore the database files...
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.
July 14, 2010 at 1:28 am
IS this standby mode is culprit ????
When you restore a transaction log using the NORECOVERY option, SQL Server does not need to analyze the transaction log and roll back any...
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.
July 12, 2010 at 6:22 am
I'm so sorry, I just noticed from the title of your post that your secondary server is in the standby mode. In that case, you should check if 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.
July 8, 2010 at 11:09 pm
Viewing 15 posts - 106 through 120 (of 342 total)