Activity overview
Latest activity by Osolage
Manage backup biles on network share
I haven't had time to determine whether there's an effective way to use the copy to "Copy backup to network" feature. It seems that when I do this, the original backup file remains on the local dis...
Thanks for the answer, Jason. I'm all set now. Much appreciated! / comments
Thanks for the answer, Jason. I'm all set now. Much appreciated!
Thanks for the query, Petey. It almost gets me exactly what I want. It actually returns 3 rows, though. The first row contains the backup filepath that I'm looking for. The 2nd and 3rd rows look like the vitrual devices that were used. Below are the 2nd and 3rd records:
SQLBACKUP_7676DD31-8619-4376-BDB3-DF43AC9D9C8601
SQLBACKUP_7676DD31-8619-4376-BDB3-DF43AC9D9C8602
Is there a column on the table that I can use to filter those records out?
Thanks again,
Ra / comments
Thanks for the query, Petey. It almost gets me exactly what I want. It actually returns 3 rows, though. The first row contains the backup filepath that I'm looking for. The 2nd and 3rd rows look li...
Script to find the most recent full backup?
Is there an easy way to find the most recent full backup of a database using T-SQL or the command line tools? I need a script that will do this for me so that I can restore it on a regular basis as...
Finding the latest full backup
hello, is there a best practice script for finding the latest full backup file for a database? i'm trying to automate the restoration of the latest full backup file to a QA database that is on the ...
Proper steps to restore a filegroup
Greetings,
I have a database that is nearly 500 GB at this point. Due to our ETL process, I find it necessary to restore the production database to ETL database server, run the ETL on ETL database ...
Stop qualifying column names for updates
Hi,
Every time I write an update statement SQL Prompt fully qualifies the update columns, but I don't want it to. How can I stop this?
For example:UPDATE [dbo].[X]
SET [TargetVa...
Scripts Folder option to generate drop scripts?
Hello,
I love SQL Compare. It has become exceedingly more useful as newer versions are released!
I would like to see the option to have SQL Compare generate DROP statements at the top of each of th...
Hi,
I've been working with Java development teams for about 5 years now that use CVS and/or Subversion. So that we could have one source control system, we've standardized all of our source code into CVS including database scripts. I'm very happy with the scripting captabilities in SQL Compare, however, I haven't found a way to have it commit to CVS. Is there a way? Can you guys add support for that?
Thanks,
Randy M. Franklin, Jr. / comments
Hi,
I've been working with Java development teams for about 5 years now that use CVS and/or Subversion. So that we could have one source control system, we've standardized all of our source code in...