stoping and starting SQL Server

[marlene]

Does anyone use PeopleSoft and SQL?
I am doing tape backups with Seagate.
Seagate hangs sometimes.
I am planning on writing a command to shut off SQL server then restart it.
i am having trouble with writing the .BAT File
so far:
--start of bat
NET STOP MSSQLServer
NET STOP SQLExecutive
<<call to backup software>> -- (my problem)
net start server
net start executive
-- end of bat
any help would be appreciated
thanks
marlene

[Don Romano]

Does Seagate have a SQL Server component/agent to do database backups or are you just backing up a backup disk device to tape. (Backing up an OS file)

I am not sure why you are shutting down SQL Server because:

If Seagate has a client component/agent to backup SQL Server than I assume SQL Server would have to be running.

or

You would be doing the backup of the database to a backup disk device and using Seagate to backup the disk device. I don`t believe that SQL Server locks the backup disk device files when it is running.

Backing up the regular database devices is of limited value. If you want a database backup then use the database backup tools and create real database backups versus just backing up the operating system files.

Any idea why Seagate hangs? If you are trying to backup the actual data device files and it`s stalling (because they are locked while SQL Server is running) you can either exclude them from the backup (assuming you are backing up a backup device) or you can do what you were doing and shut down SQL Server and back them up.

What is your question about stopping and starting SQLExecutive and MSSQLServer? Later in our bat code in your note you call SQLExecutive `executive` and MSSQLServer `server` but I assume you were just tying it in that way for the note. (Won`t start with those names) :-)

Don

On 8/12/98 10:21:14 AM, marlene wrote:
> Does anyone use PeopleSoft and SQL?
I am doing
> tape backups with Seagate.
Seagate hangs
> sometimes.
I am planning on writing a command to
> shut off SQL server then restart it.
i am having
> trouble with writing the .BAT File
so far:

> --start of bat
NET STOP
> MSSQLServer
NET STOP SQLExecutive

> <<call to backup software>> -- (my problem)

> net start server
net start executive

> -- end of bat
any help would be
> appreciated
thanks
marlene