I've never made a dumb mistake like that.... well ... except for that time, and that other time, and then there was that other time also .....

• This reply was modified 1 year, 9 months ago by  homebrew01.

Here's my powershell script (with company information changed)

I'm "assuming" that since it works when I run the BAT file manually, which runs powershell, that it would use the same permissions...

I don't see any benefit to the extra lines. Just takes up space and results in more scrolling.

[These] [brackets] [also] [add] [to] [clutter]. I use them sparingly.

SELECT
...

• This reply was modified 1 year, 10 months ago by  homebrew01.
• This reply was modified 1 year, 10 months ago by  homebrew01.
• This reply was modified 1 year, 10 months ago by  homebrew01.

Too much ? Or not enough ?

I can confirm this issue.  I was actually going to post about it but Homebrew01 beat me to it.

That and it now takes about a thousand years for the...

• This reply was modified 1 year, 11 months ago by  homebrew01.
• This reply was modified 1 year, 11 months ago by  homebrew01.

Comparing addresses sounds like a mess, if coming from different sources.

123 N. Park st

123 No. Park street

123 North Park St.

Who generates Water Account # ?  Does the city assign it ?

To verify, you might have to get data from town records.

• This reply was modified 1 year, 11 months ago by  homebrew01.

Fractional account # ?

CustomerAcctNo  DECIMAL(9, 2)  ???  1234567.02 ?

This is fine.

• This reply was modified 1 year, 11 months ago by  homebrew01.
• This reply was modified 1 year, 11 months ago by  homebrew01.

OwnerEmail VARCHAR(5),    Do you mean varchar(50) ?  Or longer ?

State    VARCHAR(50)  What values are allowed ? Is that better than CHAR(2) and validate against a State table ?

ZipCode...

• This reply was modified 1 year, 11 months ago by  homebrew01.
• This reply was modified 1 year, 11 months ago by  homebrew01.
• This reply was modified 1 year, 11 months ago by  homebrew01.

Can you run native SQL backups of T-Log and Database so you have some D.R. protection ?

Veritas doesn't show progress bar or other job information ?

What does SP_WHO2 show for the Veritas SPID ?

I have used this script, but may not help you if dm_exec_requests shows...

• This reply was modified 1 year, 12 months ago by  homebrew01.
• This reply was modified 1 year, 12 months ago by  homebrew01.

Maybe your transaction logs are not being backed up on the source database, so they keep growing.

Assuming the source database is production, a typical backup plan is full backup weekly,...

• This reply was modified 1 year, 12 months ago by  homebrew01.

Sounds similar to what I did a while back. It was several years ago, so not fresh in my memory.

You may not need the T-Logs in DEV, but they can be very important in PROD. So the place to start is where the databases originate and see if your...

You can prepare the restore with the settings and options with SSMS, but instead of running it, "Script to query window" and compare your T-SQL script with the SSMS generated...