Comments
Sort by recent activity
P.S. The result sets of the 4 views and stored space in the 4 tables constitutes about 20 million rows and about 20gb of storage. / comments
P.S. The result sets of the 4 views and stored space in the 4 tables constitutes about 20 million rows and about 20gb of storage.
Nevermind - looks like a UNC is what is needed to get this to work. Question though - I thought you guys addressed being able to back up to mapped drives in a earlier release? Is that not the case? Do you really have to specify a UNC to anything other than the C:DRIVE of a system that has SQL Backup installed? / comments
Nevermind - looks like a UNC is what is needed to get this to work. Question though - I thought you guys addressed being able to back up to mapped drives in a earlier release? Is that not the cas...
I am having this same problem. Can anyone share what the solution was for this? / comments
I am having this same problem. Can anyone share what the solution was for this?
ChrisAVWood wrote:
If you haven't tried the DBCC CHECKDB then it could be the CHECKSUM. It could also be the verify. If your DB is corrupt good luck. You will need Paul Randal's help http://sqlskills.com/blogs/paul/.
hopefully you have the last full backup at hand and if you could run a differential without checksum and verify and you had somewhere else to restore them to you could run the DBCC CHECKDB.
Chris
I'm hoping and praying that I DO NOT have corruption! I have had to go against the grain with every fiber of my being to compromise certain things for this particular database server (because if customer's are complaining about slowness in the environment, then what's the point...).
If it is corrupt, the only silver lining will be the massive push that I have been on for the past month to migrate it over to another server with twice as much RAM (32gb) and the Enterprise Edition of 2005 SQL Server (but the problem has been that they do not want to take the outage to get it done in the simpliest of fashions - just a straight copy of the .mdf and .ldf to get it over to the new box). I guess when they wind up taking an unplanned outage, they might finally move.
Thanks again Chris - I am going to try one more LUN tonight, then see if I cannot run you idea tomorrow as needed. / comments
ChrisAVWood wrote:
If you haven't tried the DBCC CHECKDB then it could be the CHECKSUM. It could also be the verify. If your DB is corrupt good luck. You will need Paul Randal's help http://sqls...
ChrisAVWood wrote:
I am sure that you have already tried this but.
Can you write anything to that drive?
Can you write anything to that drive using the Windows account that SQLBackup is using?
Can you do a log backup or a differential backup rather than a full?
Can you run DBCC Checkdb with PHYSICAL_ONLY on the database in question?
Chris
Hey Chris - no, these are all good questions, and yes to all but the last - I cannot get jobs to execute on this server, not matter what window of opportunity I use. I had to stop all maintenance on the server because of the length of time the jobs were running (even with just the PHYSICAL_ONLY checks on DBCC).
It's been pretty frustrating, and I am getting paranoid about not having any backups of this system (we had another one crash on Monday this week, and had it not been for the backup sets for those databases that I had been keeping, heads would have rolled).
Any other thoughts? / comments
ChrisAVWood wrote:
I am sure that you have already tried this but.
Can you write anything to that drive?
Can you write anything to that drive using the Windows account that SQLBackup is using?
C...
eddie davis wrote:
Hi SQL_ME_RICH
I suspect that you may have a problem with the actual disk drive using the drive letter G:\.
I recommend that you attempt to backup to another disk and see if this action resolves the error.
Many Thanks
Eddie
Hello Eddie - Thank you for the quick response!
The drive in question is a SAN disk, and I probably should have pointed out that it's a NetAPP SAN and the disks have been checked, and have no errors. I have tried multiple LUN's.
This is running SQL Server 2005 Standard Edition 64-bit, which is troublesome enough, but should still work. I am not sure what has caused this to start to fail, and have been investigating everything from the WebApp front end (because of recent deployments all the moving pieces and such) to trying different LUN's to get the thing to backup.
Any other ideas? / comments
eddie davis wrote:
Hi SQL_ME_RICH
I suspect that you may have a problem with the actual disk drive using the drive letter G:\.
I recommend that you attempt to backup to another disk and see if t...
Marianne wrote:
Hi
Many thanks for your feedback. The 'Compressed Size' column in the Backup Properties dialog shows the size of the backup file (whether it was compressed or uncompressed). The column label will be changed in the next version to reflect this.
Cheers,
Marianne
Marianne, thank you for this information, but just out of curiosity then - what is this other file size in the Properties box? Is it just an errant calc? / comments
Marianne wrote:
Hi
Many thanks for your feedback. The 'Compressed Size' column in the Backup Properties dialog shows the size of the backup file (whether it was compressed or uncompressed). The ...
Thx. / comments
Thx.
I wondered if perhaps that didn't have something to do with it...I have a 3 monitor setup.
1. Mobile PC Display / 1920 X 1080 / Landscape / Extend desktop to this display.
2. Acer AL2216W / 1680 X 1050 / Landscape / Extend desktop to this display.
3. HP 2509 Series Wide LCD Monitor / 1920 X 1080 / Landscape / Extend desktop to this display.
Each of the settings above are the 'recommended' settings, but regardless to which screen I have the dialog box in - all 3 show the fields overlapping the field title to the left.
Oh also - I found one other thing, and this has nothing to do with the display (and I will post this in a new post if you wish), but I noticed just recently that if you right click on a completed backup job that is not using compression (like a Transaction Log), the 'Properties' dialog box shows the file size, and then a compressed size, but when you go out into the main window again - it shows the compressed size from the dialog box as being the 'Uncompressed Size'.
Not to nitpick, but that's kinda off... / comments
I wondered if perhaps that didn't have something to do with it...I have a 3 monitor setup.
1. Mobile PC Display / 1920 X 1080 / Landscape / Extend desktop to this display.
2. Acer AL2216W / 1680 X ...
That's kinda what I thought, but just wanted to confirm.
Thank you! / comments
That's kinda what I thought, but just wanted to confirm.
Thank you!