Re: SQL and VBS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Backwards" <Andrew@xxxxxxxxxxxxxxxxxxxxxxx>
Date: 11 Oct 2006 15:33:24 -0700

If you are copying the backup files (.bak, .trn) then that's another story.

It is the .bak files so the copy works fine.

Why not? Are you familiar with ADO? are you familiar with creating a SELECT
statement? Where do we start? If we have to show you how to construct the
SELECT statement, then we need more details, such as the name of the
database, the name of the table, the name of the column that needs to be
queried, the name of the sql server.

i can write the SQL SELECT statment fine but i dont know how to add
this to my VBS.

.

Follow-Ups:
- Re: SQL and VBS
  - From: Bob Barrows [MVP]

References:
- SQL and VBS
  - From: Backwards
- Re: SQL and VBS
  - From: Bob Barrows [MVP]

Prev by Date: Send email alert when file is modified
Next by Date: Re: need help with Now()
Previous by thread: Re: SQL and VBS
Next by thread: Re: SQL and VBS
Index(es):
- Date
- Thread

Relevant Pages

Re: corrupted backup file
... is not automatic recovery work to be done, and SQL Server know that, SQL Server can re-create a ... Restore your latest clean backup or open a case with MS and see if they can help ... If that doesn't work and your backup files are corrupt, ...
(microsoft.public.sqlserver.server)
Re: Cant find log-shipping option
... I looked at a couple and simply went for the market leader on the assumption ... that they were less likely to go bust:) ... hand-crafted as SQL Server won't recognise the backup files. ... Paul Ibison SQL Server MVP, ...
(microsoft.public.sqlserver.replication)
Re: DB backup to UNC path failing
... Did you log in from the console of the SQL Server as the SQL Service ... That is the key element to test whether you can write backup files ... >>> we use a local path on the SQL cluster. ...
(microsoft.public.sqlserver.clustering)
Re: Maintenance did not delete old files
... How did you configure the MP to delete old backup files? ... Did you use a Maintenance Cleanup Task? ... I have a problem with maintenance plan that created on SQL server 2005 to take a full backup then delete old files that older than 10 hours. ... it is running well on taking the backup file, but it does not delete old backup files, I reviewed the folder security and make sure that the SQL Agent user has full control on that folder. ...
(microsoft.public.sqlserver.server)
Re: set password on backup file
... You can't do it natively in SQL Server, ... encrypt on the fly. ... other benefits too like reduced backup and restore times, ... backup files. ...
(microsoft.public.sqlserver.clients)