Posts
Sort by recent activity
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...
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...