Viewing 15 posts - 31 through 45 (of 341 total)
Download SQLBAKReader (link in my sig) to check if the backup set(s) in your backup file is of the same or older version as the SQL Server instance you are...
March 31, 2011 at 9:19 pm
Some hints to speed up your backups.
Backup compression will also usually speed up your backups. Red Gate's SQL Backup[/url] is one option.
March 28, 2011 at 5:44 am
SQL Server checks the page checksums when it reads the pages, so if you were able to copy the data from the corrupted database without errors, then it's unlikely that...
March 25, 2011 at 5:42 am
On SQL Server's end, you could check the SQL Server errorlog to check if any errors were logged for the restore. You can also check the Windows Event Log,...
March 24, 2011 at 8:46 am
vamshikrishnaeee (3/23/2011)
March 24, 2011 at 4:36 am
I think the difference lies in the fact that in the first insert command, SQL Server needs to build the data that needs to be inserted into the table. ...
March 21, 2011 at 6:44 am
Try the following:
SELECT a.name, b.total_elapsed_time / 60000 AS [running time], b.estimated_completion_time / 60000 AS [remaining], b.percent_complete as [% complete],
(SELECT text FROM sys.dm_exec_sql_text(b.sql_handle)) AS command
FROM master..sysdatabases a
INNER JOIN sys.dm_exec_requests b ON...
March 16, 2011 at 3:41 am
RESTORE HEADERONLY as per Gail's suggestion if you have access to a SQL Server instance, SQL BAK Reader if not.
Isn't there's also msdb.dbo.backupset.type?
Values are:
D = Database.
I = Database Differential.
L =...
March 15, 2011 at 11:34 am
Try using 'Process Explorer' or 'Handle' from Sysinternals to determine which app is using the file.
March 13, 2011 at 7:44 pm
Perry Whittle (3/13/2011)
So this is a backup that was taken with Redgate SQLBackup is that correct?
No, I don't think so. In his first post, he mentioned that the backup...
March 13, 2011 at 3:57 am
It's not all T-SQL, but have you tried SQL Image Viewer? Recognizes BMP, JPG, GIF, PNG, TIFF, and PSD images by reading the image data, supports SQL Server, Oracle,...
March 13, 2011 at 3:49 am
Once you run that, SQL Server will log additional details in its log about any restores that you now run.
Try restoring that database now, and check the details in the...
March 11, 2011 at 9:38 pm
If you run the following:
DBCC TRACEON (3004, 3605, -1)
SQL Server logs additional information in its log file re. the restore. Might give some clues as to what its doing.
March 11, 2011 at 7:23 pm
No, that's not possible. A restore would create the same files as the original database.
If you're short of disk space, you could consider using Red Gate's SQL Virtual Restore...
March 8, 2011 at 10:01 am
Thanks for your help on this issue. So, I followed the instructions from the following link:
http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
Did you see the follow-up link on that page, to this: http://sqlskills.com/BLOGS/PAUL/post/Bug-log-file-growth-broken-for-multiples-of-4GB.aspx
Looks like...
March 7, 2011 at 6:39 pm
Viewing 15 posts - 31 through 45 (of 341 total)