Comments
Sort by recent activity
we too would love to be able to point the output to a sharepoint site. Right now we have a link do our documentation but having it right in sharePoint would of course be best. / comments
we too would love to be able to point the output to a sharepoint site. Right now we have a link do our documentation but having it right in sharePoint would of course be best.
this morning I installed the latest version (2.3) and the errors stopped shortly after the install. / comments
this morning I installed the latest version (2.3) and the errors stopped shortly after the install.
I previously had SQL Search installed. I don't remember if it updated to a new version yesterday when I did the install. I don't remember if I had SSMS open after I upgraded SQL Prompt either. Since is has been several hours since I tried using SQL Prompt I enabled it and try again and still find it hanging although now instead of 26 seconds it is only 20 seconds but still too long in my opinion. / comments
I previously had SQL Search installed. I don't remember if it updated to a new version yesterday when I did the install. I don't remember if I had SSMS open after I upgraded SQL Prompt either. Sinc...
Is there a way to get the last version. This problem is hindering my ability to get my work done so much that I'm actually going to disable SQL Prompt. / comments
Is there a way to get the last version. This problem is hindering my ability to get my work done so much that I'm actually going to disable SQL Prompt.
I use the Qualify Object Names command in SQL Refactor especially when I am writing a script in a database I'm not familiar with or if I'm giving my query to someone else. Are there plans to include this in SQL Prompt 5? / comments
I use the Qualify Object Names command in SQL Refactor especially when I am writing a script in a database I'm not familiar with or if I'm giving my query to someone else. Are there plans to includ...
Thanks, no matter how many times I need to write cursor code, I always cut and paste an example to make sure I get it all. This snippet will be very helpful. / comments
Thanks, no matter how many times I need to write cursor code, I always cut and paste an example to make sure I get it all. This snippet will be very helpful.
our password has not changed so all the files should have the same password. This folder only contains differential backups per the script. I just looked at the folders and now it appears that files are being deleted. Is it possible that SQL Backup 6 will not remove sql backup 5 files? / comments
our password has not changed so all the files should have the same password. This folder only contains differential backups per the script. I just looked at the folders and now it appears that file...
Helen
The job runs every night so I'd expect it to do deletes every night.
Here is the code in the job. I created the job using the GUI and did not modify it outside the GUI at all. DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES EXCLUDE [master] TO DISK = ''e:\backups\BIPRODUCTION\<database>\<type>\<AUTO>.sqb'' WITH ERASEFILES = 7, ERASEFILES_REMOTE = 4, MAILTO_ONERROR = ''_sqlpsqi@dfa.state.ny.us'', PASSWORD = ''<ENCRYPTEDPASSWORD>xxxxxx</ENCRYPTEDPASSWORD>'', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 3, COPYTO = ''\\mscotda0a1bg\sqlback\mscotda0a1azbiproduction\<type>\<database>'', KEYSIZE = 256, THREADCOUNT = 3, DIFFERENTIAL"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
/ comments
Helen
The job runs every night so I'd expect it to do deletes every night.
Here is the code in the job. I created the job using the GUI and did not modify it outside the GUI at all.DECLARE @exitcod...
I've been manually removing our windows users every time I do a compare ever since I started using the product over 3 years ago. I'd love a way to filter out windows users. / comments
I've been manually removing our windows users every time I do a compare ever since I started using the product over 3 years ago. I'd love a way to filter out windows users.
moving another window over the client does not seem to have any affect at all. / comments
moving another window over the client does not seem to have any affect at all.