Comments
Sort by recent activity
One thing I have noticed -is that I am not getting the table alias included with each of the fields. It did expand only the proper table where I had prefaced with cpia.* and hit tab, but only the first column got my alias.
I'd like to see the alias carried through the entire expand. / comments
One thing I have noticed -is that I am not getting the table alias included with each of the fields. It did expand only the proper table where I had prefaced with cpia.* and hit tab, but only the ...
That's absolutely brilliant! Now I don't have to wait for an update! [image]
Alright then on the hot key, what about either A) a button we can add to the toolbar, or just a menu item that says "Refresh Cache Current DB"? That's really all I need, just something that would save me the few extra steps.
One other question, how do I get SQL Prompt to show me objects in another database? I have two dbs that I use in production, and sometimes I want to query data from the other DB while still within my main DB. I do a select * from reporting.dbo. and instead of getting objects from that DB (which I know Prompt has cached), I only get objects from the DB I'm in. I looked at the options, but didn't see anything that leapt out at me. Of course you know that my next question will be regarding the prompts for linked servers (but we'll leave that for another day for now :lol: ).
Great job over all - your products absolutely ROCK! / comments
That's absolutely brilliant! Now I don't have to wait for an update!
Alright then on the hot key, what about either A) a button we can add to the toolbar, or just a menu item that says "Refresh C...
petey wrote:
Start Profiler, filter on the application name SQBCoreService.exe. Then start a backup using SQL Backup. You should see 2 backup commands, one identical to the one you issued, and another similar to the first, but using VIRTUAL_DEVICE = ... instead of DISK = ...
The command is getting to the server, however it just won't work. I tried stopping and restarting the SQBCoreService and that didn't work either.
Here is the command coming to the server:
BACKUP DATABASE [model] TO VIRTUAL_DEVICE = 'SQLBACKUP_1AF7352C-C01D-4FD1-8DBA-D5C93F3FE4D7' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 65536, NAME = N'Database (model), 3/28/2007 8:54:14 AM', DESCRIPTION = N'Backup on 3/28/2007 8:54:14 AM Server: PULSITY-SQL1 Database: model', FORMAT
I do see that it is testing to make sure the account it is using has rights to backup and it does. (This was working until a few days ago).
This is getting really upsetting - I haven't had a backup now since the 24th. That is NOT good. I'm going to try and manually run the SQLBackup program to see if it has any more luck backing up a db than the automated job. / comments
petey wrote:
Start Profiler, filter on the application name SQBCoreService.exe. Then start a backup using SQL Backup. You should see 2 backup commands, one identical to the one you issued, and...
petey wrote:
Was the SQL Server name or SQL Server instance name changed recently?
Did you try using the command line version? Does that work?
Thanks.
The SQL Server name and/or instance has not changed - I did try using the backup from the command line and that is failing as well with the same message.
I finally called in for support on this because we are going on almost a week with this not working any longer. I'm working with them at the moment to try and rectify this.
Thanks.
Bill / comments
petey wrote:
Was the SQL Server name or SQL Server instance name changed recently?
Did you try using the command line version? Does that work?
Thanks.
The SQL Server name and/or instance has ...
We are migrating to a scenario where we will have a "reporting/processing" database that will be on a different physical server. If we could specify LinkedServer.Database to be cached, that would be a bonus. / comments
We are migrating to a scenario where we will have a "reporting/processing" database that will be on a different physical server. If we could specify LinkedServer.Database to be cached, that would ...
It took 1263.665 seconds to do the full restore, but it did finally work.
I haven't tried the step recommended above to restore the header, that's not going to mess up my database - is it?
If not, I'll test it to see what happens. [image] / comments
It took 1263.665 seconds to do the full restore, but it did finally work.
I haven't tried the step recommended above to restore the header, that's not going to mess up my database - is it?
If not, ...
I too am having problems with the UI - it starts the "Retrieving History" - the agent then goes to 30% CPU and never comes back.
This file was backed up with the current version of SQL Backup, with compression, but no encryption.
I am trying to use the command line restore now. There is no indication if it's doing anything, so I can't tell if it's in the same infinite loop or not.
I did just check the directory to where the file is being restored and it has increased the size of my data file to the full size of the DB, so perhaps it is working.
I know recently when I tried to restore a backup over a smaller version of the file (the original size was 20gb on my dev server, and now my production DB is at 50gb) - it took a long time (like an hour) before it actually started to restore the database. I'm hoping it's not going to take that long now. This was all with version 4.x of the software - no cross versions going on and it was all on SQL2000. I'm now restoring that same backup to my SQL2005 on my local PC. / comments
I too am having problems with the UI - it starts the "Retrieving History" - the agent then goes to 30% CPU and never comes back.
This file was backed up with the current version of SQL Backup, with...
1. Dependency graph. A visual representation with a diagram showing all of the entities (color coded by type) that depend on this entity.
2. An Foreign Key graph that shows all related tables. Maybe with an arrow showing which way the dependency is going.
3. I'll also agree that I'd love to see the Diagrams be imported if possible. Don't know if SMO lets you export to an image via the API, but if you could embed that in the help file, that would be huge. I don't care right now if you made the diagram linkable (I click on a table - it takes me to that part of the help) -just having the diagram(s) would be a huge bonus I think.
4. Ability to add other types of data on a table. Basically the ability to create my own Extended properties - maybe define them at a project level and say that they are a Table/Field/Sproc/View/Function/etc property and then the editor would let me fill in the values at the appropriate spot. Even cooler would be to specify the data type and length so that you could have some mask fields available (say for capturing only a date, etc).
5. Ability to store all of the extended properties outside of the database so that if something were to happen and you had to rebuild your docs on a backup or on another server, you'd have all of your information available. This would be helpful too if while you are designing you would rather drop the table and rebuild it to put the fields in the order you want. It's a small thing, but would be helpful to me. / comments
1. Dependency graph. A visual representation with a diagram showing all of the entities (color coded by type) that depend on this entity.
2. An Foreign Key graph that shows all related tables. Ma...