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)...
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...
December 29, 2010 at 9:27 pm
Try the suggestions in this article and its sub-articles. Provides some tests you could run.
Thanks.
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...
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...
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...
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...
November 23, 2010 at 5:29 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...
November 2, 2010 at 9:35 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...
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...
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...
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.
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?
October 19, 2010 at 7:29 pm
Viewing 15 posts - 76 through 90 (of 342 total)