Posts
Sort by recent activity
Concurrent backups (full and transaction)
My intent is to test my recovery model and setup log shipping to replicate a database on another server.
I have a database called AdventureWorks on a primary sql server. Presently SQL Backup perfor...
Network Copy Location keeps trying to copy to the old path
We were using the Network Copy Location feature to copy backed up databases and transaction logs from our sql server to a NAS. The NAS died the other day and I changed the Folder in which I wanted ...
Outcome column on Jobs tab is misleading
I'm confused. After I manually start a backup job a few minutes later the Outcome column reports successful but if I look in the Inprogress tab the backup job is still Running...isnt that misleading?
Is the copying of backups to a network location separate?
When the "Copy Backups To Network Location" option is used, Is it run on a thread separate from the actual backup process?
It seems to me that it would be preferred that copying the backups would h...
Use of file location tags in "Copy backup to network locatio
Can I use the file location tags in the "Copy Backup To Network Location" option? Originally I would like to organize my backups by year-month-day. I have a finite amount of local storage and organ...
Will databases be deleted if folder is based on date?
In the backup wizard, step 3 of 6 under the Backup location section:
If this is my Folder specification: C:\000\<DATETIME yyyy_mm_dd>\ AND I turn on the "Delete existing backup filies in this folde...
Feature Suggestion WHERE clause suggest...
I think it would be cool if SQL Prompt would offer where clause suggestions based on existing indexes for that table.
My thought is it would help users write more efficient and faster T-SQL when th...
Column Ordinality
Is there an option in SQL Compare that will inspect the column ordinality between two tables... so that if the destination columns are not in the same order as the source tables a script can be gen...
Add A Column To A Table With ExtendedProperty
I use this snippet when I want to add a column to a table and want to add a blurb about this columns purpose.
Getting into the habit of using the ExtendedProperty also allows me to use SQLDoc to cr...
GROUP BY Feature Request / Enhancement
Hello,
I wanted to suggest an enhancement to your SQL Prompt product.. which I *LOVE* by the way!
If I type
SELECT City, State From Addresses
and I begin to type GROUP BY and press the space bar .....