Comments
Sort by recent activity
Hi Anu,
No, the html version is created completely and successfully.
regards
Jonathan / comments
Hi Anu,
No, the html version is created completely and successfully.
regards
Jonathan
Hi Anu
I am sorry to say that I cant send you the requested file.
In the C:\Documents and Settings\allenj\Local Settings\Application Data\Red Gate\Logs folder I only have a folder called "SQL Response 1", there is no "SQL Docs 2" folder.
There is no folder by that name one level up either, there are however SQL Backup, SQL Compare, SQL Data Compare 7, SQL Dependency Viewer 2.0, SQL Prompt 3, SQL Prompt 4, SQL Refactor and SQL Response Client.
The only file on my PC with the name "SQL Doc 2" is the shortcut in C:\Documents and Settings\All Users\Start Menu\Programs\Red Gate
regards
Jonathan / comments
Hi Anu
I am sorry to say that I cant send you the requested file.
In the C:\Documents and Settings\allenj\Local Settings\Application Data\Red Gate\Logs folder I only have a folder called "SQL Respo...
It would be good to also see how well the job progressed before the network problems or better still until it gave up/ran out of re-tries.
If the job was to backup 5 databases to DR and it got 1,2+3 done, had problems in no4 but then gave up trying during the backup of no5 then this detail would only be found via the DR file share and checking each folder's contents. This may be in the SQL job output but getting it into the SQL Backup interface would be preferrable.
Jonathan / comments
It would be good to also see how well the job progressed before the network problems or better still until it gave up/ran out of re-tries.
If the job was to backup 5 databases to DR and it got 1,2+...
Guys,
There seem to be two ways of looking at this:
1 - Backup my databases to local HDD then copy to LAN\WAN location
2 - Backup my databases to LAN\WAN location
in scenario 1, you have your backups done and the copy may or may not retry if the network is present.
in scenario 2, you are backing up databases to a network location, if the job encounters a network problem then moving to the next database will just find the same problem.
Possibly what you are suggesting is an option to flip from one option to the other if a network issue arises. I.E. backup to DR site but if the network drops backup locally?
Personally I have got around this with two jobs in version 5; 1 does the local backup on a given schedule and the other does the DR backup on another schedule. If either fail I know I have the other should I need to restore. / comments
Guys,
There seem to be two ways of looking at this:
1 - Backup my databases to local HDD then copy to LAN\WAN location
2 - Backup my databases to LAN\WAN location
in scenario 1, you have your backu...
Petey,
I agree with everything you say and would certainly advise users to consider the effects of the settings they choose.
In my scenario we are only shipping the whole backup to another site on a weekly basis while the is server quiet over the weekend, our biggest problem is getting the file transferred quickly over our network so that other processes (NTFS backups etc) can take place. Making it a smaller file is a big gain for the small price of a busy CPU for a few minutes (our test server took 15 m to backup and verify, live takes 2m but the h/w is very different). Currently scheduling this and recovering where they clash is an all too common problem.
Jonathan / comments
Petey,
I agree with everything you say and would certainly advise users to consider the effects of the settings they choose.
In my scenario we are only shipping the whole backup to another site on ...
Noted, and thanks for making it clear.
Live is still in v5, I am testing v6 on our, poorly spec'd, test rig. Live uses compression level 3 from v5.
I wouldnt say our live hardware is anything special, 2xDual Core Xeons 20GB RAM, 8xHDD (2 RAID 1 for OS+logs, 2 RAID 0 for OLAP DB, 4 RAID 5 for OLTP DB)
The backup goes straight off the server to a network share (beware risks here as network failure will crash backup with no recovery) and then gets copied to DR site. I think the fact that we have multiple cores and plenty of RAM means we gets great speed. SQL Backup uses 3 threads. Also the server is almost unused when the job takes place.
Jonathan / comments
Noted, and thanks for making it clear.
Live is still in v5, I am testing v6 on our, poorly spec'd, test rig. Live uses compression level 3 from v5.
I wouldnt say our live hardware is anything speci...
I have found that a lot of red underlines are resolved by adding:
USE <database>
GO
to the top of every script.
Its certainly not 100% but it gets rid of a lot.
Jonathan / comments
I have found that a lot of red underlines are resolved by adding:
USE <database>
GO
to the top of every script.
Its certainly not 100% but it gets rid of a lot.
Jonathan
simon.jackson wrote:
Oops, looks like we double encoded. If you still wish to try out the v4 EA then you should be able to copy the section from the v3 options file and run it through an html encoder. [ e.g. http://www.barelyfitz.com/projects/encoder/ and select the "HTML entities" option ]
Thanks for the feedback, we'll look at putting an automated alias upgrade alongside the snippet upgrade in the final version.
Hope the rest of the EA is better for you!
Does this mean that while we run v4 we wont have the snippet importer?
If so then I may well uninstall too. The snippets are vital to a smooth experience. Is there no way we could have a standalone exe to import/convert the v3 snippets to v4? This is like testing a new car with only three wheels fitted ... / comments
simon.jackson wrote:
Oops, looks like we double encoded. If you still wish to try out the v4 EA then you should be able to copy the section from the v3 options file and run it through an htm...
Can confirm comments by George Palacean above.
Its also odd when you Ctrl and left arrow or Ctrl + right arrow.
If you happen to have left a section of text without a closed comment (' or ") then the cursor jumps to the opening character or to the end of the line, it ignores spaces entirely. / comments
Can confirm comments by George Palacean above.
Its also odd when you Ctrl and left arrow or Ctrl + right arrow.
If you happen to have left a section of text without a closed comment (' or ") then t...
Aliases:
I just had occasion to reference the sys.databases table.
I typed "SELECT * FROM [sys].[databases]" and the alias text was added as " AS d1". In my font this is indistinguishable from dl and dI. (There may also be a strong case for me needing to use a grown-up font here.)
There were no other aliases in use - one query file open, one query on the page - so why did it not use just 'd'? Is there a setting to prevent numbers being used in aliases.
Closing characters:
none of mine close ... ', ", /*, ), ] (even after changing all the settings off and back on yesterday and shutdown/restart this morning) / comments
Aliases:
I just had occasion to reference the sys.databases table.
I typed "SELECT * FROM [sys].[databases]" and the alias text was added as " AS d1". In my font this is indistinguishable from dl a...