How can we help you today? How can we help you today?
randyv
Activity overview Badges (0) Posts (51) Comments (57)

Comments

Sort by recent activity
I was looking at table constraints for a column constraint; sorry / comments
  1. Community
  2. SQL Compare Previous Versions
  3. getting an error about a constraint that doesn't exist?
I was looking at table constraints for a column constraint; sorry
0 votes
OK, I'm stumped, not in contraint column usage either. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. getting an error about a constraint that doesn't exist?
OK, I'm stumped, not in contraint column usage either.
0 votes
typed it in again and this time it took. Weird. / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. unable to login on iPad
typed it in again and this time it took. Weird.
0 votes
I think I figured out what step I forgot. I'll post back here if I run into the problem again. (backup the tran log first, then run the full backup, then restore from the full backup) / comments
  1. Community
  2. SQL Backup Previous Versions
  3. use problem... need help
I think I figured out what step I forgot. I'll post back here if I run into the problem again. (backup the tran log first, then run the full backup, then restore from the full backup)
0 votes
Chris - Thanks; yes I agree with your points. Since I was just getting the users a sandbox to test in, I wasn't concerned with 'open' transactions; but after talking with the testers these are precisely the transactions I should have been concerned about. So I assume I should fetch the last full backup, which I write nightly after close of business, then say yes to backing up the tail. But then what? I think (but would like you to confirm) that I restore the full database, but leave it non-operational, then after that is done I restore the tail tran log and make it operational? Would that be correct? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. use problem... need help
Chris - Thanks; yes I agree with your points. Since I was just getting the users a sandbox to test in, I wasn't concerned with 'open' transactions; but after talking with the testers these are pre...
0 votes
downloading now; thanks for the tip. [image] / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SSMS not responding; SQL Prompt is root cause. Why?
downloading now; thanks for the tip.
0 votes
Thanks very much - this gives me some ideas on how to proceed. / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Couple of questions before I install, please
Thanks very much - this gives me some ideas on how to proceed.
0 votes
Here is the complete message as I'm receiving it in email from SQL Backup - Seems the local backup is completing fine, but the network backup is not. Any idea why? ERRORS AND WARNINGS 4/1/2011 8:15:05 AM: 4/1/2011 8:15:05 AM: Verifying files: 4/1/2011 8:15:05 AM: E:\Davisware\LDF Backup\Service\LOG_(local)_Service_20110401_081501.sqb 4/1/2011 8:15:05 AM: 4/1/2011 8:15:05 AM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required 0 bytes of free SQL Server memory, which was not available. VDI error: An abort request is preventing anything except termination actions. 4/1/2011 8:15:05 AM: SQL error 3013: VERIFY DATABASE is terminating abnormally. 4/1/2011 8:15:05 AM: SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_F9F1FB46-C191-4698-9504-C760D475A239'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.). 4/1/2011 8:15:05 AM: 4/1/2011 8:15:05 AM: Memory profile 4/1/2011 8:15:05 AM: Type Maximum Minimum Average Blk count Total 4/1/2011 8:15:05 AM: 4/1/2011 8:15:05 AM: Commit 243068928 4096 56452 22147 1250242560 4/1/2011 8:15:05 AM: Reserve 284266496 4096 41963 20477 859279360 4/1/2011 8:15:05 AM: Free 7262208 4096 132504 286 37896192 4/1/2011 8:15:05 AM: Private 284266496 4096 47296 41896 1981550592 4/1/2011 8:15:05 AM: Mapped 1060864 4096 128107 76 9736192 4/1/2011 8:15:05 AM: Image 24948736 4096 181342 652 118235136 4/1/2011 8:15:05 AM: 4/1/2011 8:15:05 AM: Validation of all backup files failed. PROCESSES COMPLETED SUCCESSFULLY 4/1/2011 8:15:00 AM: Backing up Service (transaction log) to: 4/1/2011 8:15:00 AM: E:\Davisware\LDF Backup\Service\LOG_(local)_Service_20110401_081500.sqb 4/1/2011 8:15:01 AM: Deleting old backup file: E:\Davisware\LDF Backup\Service\LOG_(local)_Service_20110401_064500.sqb 4/1/2011 8:15:01 AM: Deleting old backup file: \\whaley09\WFR-DailyBackups\Whaley03\LOG_(local)_Service_20110401_070000.sqb 4/1/2011 8:15:01 AM: BACKUP LOG [Service] TO VIRTUAL_DEVICE = 'SQLBACKUP_CFF69D11-89C3-4F68-AEE0-D5D2F39F204E', VIRTUAL_DEVICE = 'SQLBACKUP_CFF69D11-89C3-4F68-AEE0-D5D2F39F204E01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 524288, NAME = N'Database (Service), 4/1/2011 8:15:01 AM', DESCRIPTION = N'Backup on 4/1/2011 8:15:01 AM Server: WHALEY03 Database: Service', FORMAT 4/1/2011 8:15:04 AM: Backup data size : 6.438 MB 4/1/2011 8:15:04 AM: Compressed data size: 678.000 KB 4/1/2011 8:15:04 AM: Compression rate : 89.71% 4/1/2011 8:15:04 AM: Processed 533 pages for database 'Service', file 'ServiceDev_log' on file 1. 4/1/2011 8:15:04 AM: BACKUP LOG successfully processed 533 pages in 0.583 seconds (7.478 MB/sec). / comments
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1010: How do I set maxbuffersize
Here is the complete message as I'm receiving it in email from SQL Backup - Seems the local backup is completing fine, but the network backup is not. Any idea why? ERRORS AND WARNINGS 4/1/2011 8:1...
0 votes
OK, but do you have some suggestions on what to change to eliminate the error? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1010: How do I set maxbuffersize
OK, but do you have some suggestions on what to change to eliminate the error?
0 votes
Not sure what went wrong. Ran the suggested code: EXEC master..sqlbackup '-sql "BACKUP LOG ... WITH MAXTRANSFERSIZE = 524288..." ' Got two answer sets back: #1 SQL Backup v6.4.0.56 Syntax error: 'WITH' after '...' #2 name value exitcode 850 sqlerrorcode 0 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. VDI error 1010: How do I set maxbuffersize
Not sure what went wrong. Ran the suggested code: EXEC master..sqlbackup '-sql "BACKUP LOG ... WITH MAXTRANSFERSIZE = 524288..." ' Got two answer sets back: #1 SQL Backup v6.4.0.56 Syntax error: 'W...
0 votes
Total activity
140
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
32