Viewing 15 posts - 106 through 120 (of 341 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...
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...
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...
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...
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...
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...
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...
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)'.
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...
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.
July 14, 2010 at 11:07 am
No, you do not need to restart the SQL Server service. The change takes effect immediately.
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...
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...
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...
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...
July 8, 2010 at 11:09 pm
Viewing 15 posts - 106 through 120 (of 341 total)