Activity overview
Latest activity by freddy12345
petey wrote:
freddy12345 wrote:
since i did not tell it to Replace, why is it doing anything, and what is it doing?
On SQL Server 2000, REPLACE is not required in order to overwrite an existing database. On SQL Server 2005 and newer, REPLACE is not required if:
- you are running the database using the simple recovery model
- the database is running using full/bulk-logged recovery model, and there are no entries in the transaction log that needs to be backed up
--Thank you for your response. From at least one point of view, it would seem dangerous to allow DB replacement without specific user directive. perhaps from another point of view it is desirable. Yikes. wonder if anyone else has got burned by this?
Fortunately, there was very little damage done in this instance. / comments
petey wrote:
freddy12345 wrote:
since i did not tell it to Replace, why is it doing anything, and what is it doing?
On SQL Server 2000, REPLACE is not required in order to overwrite an existi...
Accidental Restore...help!
Hi,
i just issued this restore script, but on the wrong server.
exec master..sqlbackup N'-SQL "RESTORE DATABASE [cdr200907] FROM DISK = ''\\Crystal\Share1\Mangal\BACKUPUncompressed\Daily\CDR20090...
Thanks for your response, Helen,
yes i see the Outcome column and sorting by that is helpful.
Still, it is not nearly as helpful as the prior feature, whereby all failed jobs, for all servers, were visible in one window, including the error messages. in one glance, i could see the whole story.
creating a report 'by hand' with manually entered dates, is the least helpful of the 3, because i like to check for job errors several times a day.
Your company makes great software. i respectfully suggest that usability testing (or, more of it), would be very productive with your software. i used to work at Human Factors International, the world leader in usability, and you might consider their input -- www.humanfactors.com
thanks for listening!
Fred / comments
Thanks for your response, Helen,
yes i see the Outcome column and sorting by that is helpful.
Still, it is not nearly as helpful as the prior feature, whereby all failed jobs, for all servers, were...
List of Failed Backup Jobs
Hi,
It seems that you removed the feature from V4 that showed failed backup jobs. This was a great convenience, to see all failed jobs from all servers, in one window.
Wondering why it was taken ou...
restore script needed
Hi,
i have a folder full of hourly backup files for our production database. the file names contain the date and time. i need a script that will restore the most recent backup in the given folder,...
Thank you! This looks like it'll do the trick.
Fred / comments
Thank you! This looks like it'll do the trick.
Fred
multiple restores in 1 job?
hi,
i need to move about 30 databases (all the user DBs) rom one server to anew server. i selected Backup all user databases and the backup job ran fine.
now i want to restore all those on the new ...
Jonathan,
sorry, i forgot to include the other info you requested.
sql compare 5, ver 5.3.0.44
sql server 2005, sp1
my boss asked me to duplicate this on my own, and follow thru with you. so, i'll be getting back to you on this!
thanks so much,
Fred / comments
Jonathan,
sorry, i forgot to include the other info you requested.
sql compare 5, ver 5.3.0.44
sql server 2005, sp1
my boss asked me to duplicate this on my own, and follow thru with you. so, i'll ...
Hi Jonathan,
Thanks for your response. The person who is actually doing this explains further:
"The problem is that the script doesn’t drop all constraints first, so running the script gives errors."
does this clarify?
Fred / comments
Hi Jonathan,
Thanks for your response. The person who is actually doing this explains further:
"The problem is that the script doesn’t drop all constraints first, so running the script gives err...
All constraints scripted, not just missing ones
Hi,
we're using sql compare to synch 2 DBs. We notice that the synch script adds ALL constraints for the tables on the destination DB -- not just the missing constraints. This gives errors that n...