Re: SQL and VBS
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Wed, 11 Oct 2006 06:49:54 -0400
Backwards wrote:
Dont know if this is the right group for this but i'll ask anyway.
What u want to achive is a very simple backup solution which copies
our daily SQL2000 database files to a network share.
This works? Are you copying the database files (.mdf, .ldf)? If so, this
should not work. The files should be in use and attempts to copy them should
raise an error. Even if you are allowed to copy them, the copies should not
be usable. You would need to detach them from the database server before
copying to make them usable.
If you are copying the backup files (.bak, .trn) then that's another story.
This script runs on the server and just does a basic file copy.
The problem i have is we have 72 servers we want to roll this out to
but i have to change the network path for each one.
is there anyway to replace the added code to get the client computers
(where the backup files copy to) This setting is held in a table on
the SQL server.
Can i do a select statment to pick this value with the code below?
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.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Follow-Ups:
- Re: SQL and VBS
- From: Backwards
- Re: SQL and VBS
- References:
- SQL and VBS
- From: Backwards
- SQL and VBS
- Prev by Date: Re: Search text file
- Next by Date: Re: calling a batch file from a vbs script
- Previous by thread: SQL and VBS
- Next by thread: Re: SQL and VBS
- Index(es):
Relevant Pages
|
