Comments
Sort by recent activity
Hi Eddie,
Thanks for the further enquiry. I have the situation now where its all working so I cant tell you what happens when I click the red cross icon! Maybe we had network conditions that were causing the connection some problems..?
If the issue comes back then I'll get back in touch.
Thanks
Jonathan / comments
Hi Eddie,
Thanks for the further enquiry. I have the situation now where its all working so I cant tell you what happens when I click the red cross icon! Maybe we had network conditions that were c...
I have set the timeout to 45s and fixed the protocol to TCP/IP and the red cross icon appears immediately after the Edit SQL Server dialog is closed when the Encrypt connection checkbox is checked.
As an aside, is it a known issue that F5 doesnt refresh the server connection, it has to be selected from the View menu? / comments
I have set the timeout to 45s and fixed the protocol to TCP/IP and the red cross icon appears immediately after the Edit SQL Server dialog is closed when the Encrypt connection checkbox is checked....
Hi Eddie,
thanks for the reply.
I think it would be worth putting this forward as a suggestion. I would not class my servers as the busiest servers but we had a huge number of alerts that seemed to over crowd the screen and mask the other server alerts that i did have to work on. We have replication in place and a number of jobs that run every 15 minutes so we had plenty of alerts on display after a day of maintenance.
An alternative may be to find some way of grouping or summarising these alerts while SQL Agent is stopped. Maybe having a counter in the SQL Agent alert showing how many job executions have failed to start or being able to configure the alert to not show (or show summary data only every hour or two) if the SQL Agent is stopped?
regards
Jonathan / comments
Hi Eddie,
thanks for the reply.
I think it would be worth putting this forward as a suggestion. I would not class my servers as the busiest servers but we had a huge number of alerts that seemed to...
Kerry,
I am also just starting to look at Log Shipping in our network. I am stuck choosing between native SQL Server Log Shipping and SQL Backup to set up the process.
To be fair there are more plus's for the SQL Backup option when we go live as we will be shipping over the internet to a DR site so encryption and compression will be almost 100% required. They work slightly differently from what I can see. Mostly in the way that the log backups are created, stored and archived. SQL Backup has a handle on synching the RESTORE job a few minutes after the BACKUP so as to have the data moved more quickly to its destination. Only downside I think is that this means a SQLBackup license is needed for the standby server, if its a dedicated standby server you dont need a SQL license though.
On our hardware/network SQL Backup ran a full backup and verification of a 1.4GB database in 21s and compressed it to 109MB.
make sure you download the Log Shipping Monitor tool from here: http://labs.red-gate.com/index.php/Log_Shipping_Monitor
its a 'RedGate Labs' tool but is agnostic so will keep tabs on LogShipping with SSMS and SQLBackup origins.
Not sure if this answers your questions to any great extent but hope it helps.
Jonathan / comments
Kerry,
I am also just starting to look at Log Shipping in our network. I am stuck choosing between native SQL Server Log Shipping and SQL Backup to set up the process.
To be fair there are more plu...
Hi Kerry,
The 'accidental' update is a good one. In my opinion, if it was two days ago then its pretty much their fault for not telling you sooner...
To have a 'standalone/adhoc' backup, of a database that is in the middle of Log Shipping or other backup cycle I use the WITH COPY_ONLY option. This doesnt break the chain of LSN numbers in the log files and lets the other process have a full and contiguous set of files to restore. Check BOL for details. I guess you could schedule a job to run one of these on a routine that would let you find lost details if you restore these databases of use SQL Data Compare to view data in the backup files directly.
Its a pretty high cost to set up and maintain (your time, HDD space etc) compared to the number of times it will be needed though isnt it? / comments
Hi Kerry,
The 'accidental' update is a good one. In my opinion, if it was two days ago then its pretty much their fault for not telling you sooner...
To have a 'standalone/adhoc' backup, of a datab...
Yup, changing the file location above has removed error in backup and in log shipping wizard. All working now. / comments
Yup, changing the file location above has removed error in backup and in log shipping wizard. All working now.
additional, and possibly more fundamental - I cannot backup the database to the location marked above. Looks like its not my stupidity in working the wizard but possibly permissions ... or something ... / comments
additional, and possibly more fundamental - I cannot backup the database to the location marked above. Looks like its not my stupidity in working the wizard but possibly permissions ... or somethin...
That would indeed be awesome.
Using a file open interface, to just point SQL Prompt at a folder full of SQL scripts and have them formatted and saved back again would be brilliant. / comments
That would indeed be awesome.
Using a file open interface, to just point SQL Prompt at a folder full of SQL scripts and have them formatted and saved back again would be brilliant.
Miles,
my instant action on this would be to run:
SELECT * INTO <table2> from <table1> where 1=2
to my knowledge (and experience) this creates an identical, empty table in the same database.
If you have SQL Prompt then you could create a snippet for it ... / comments
Miles,
my instant action on this would be to run:
SELECT * INTO <table2> from <table1> where 1=2
to my knowledge (and experience) this creates an identical, empty table in the same database.
If you...
Hi,
For my purposes I have used MS Word and PDF for distributing/sharing database object definitions. They seem to be the easiest way to generate a technical document, MSWord with its 'clickable' table of contents is great. PDF is obviously a format that everyone can read regardless of installed software.
For Disaster Recovery/Business Continuity I create and store database scripts in SQL file format on our network. These obviously could change database objects if executed so I only distribute these between DBAs as necessary.
I'm afraid I dont have any examples - David/Red-Gate, can you come up with some sample output? Maybe from AdventureWorks?
HTH
Jonathan / comments
Hi,
For my purposes I have used MS Word and PDF for distributing/sharing database object definitions. They seem to be the easiest way to generate a technical document, MSWord with its 'clickable' t...