Hi,
I use MSDE with latest service pack. As you may know MSDE is not Volume
Shadow Copy aware. I have a backup software which requires me to stop MSDE
before it can properly backup the none-vss-aware (volume shadow copy)
database.
I need to remotely send a command to stop MSDE before starting the backup,
anyone knows the command string I need to use?
Thank you

On Jun 17, 12:25 pm, Vic Abrahamian
<VicAbraham...@discussions.microsoft.com> wrote:
> Hi,
> I use MSDE with latest service pack. As you may know MSDE is not Volume
> Shadow Copy aware. I have a backup software which requires me to stop MSDE
> before it can properly backup the none-vss-aware (volume shadow copy)
> database.
> I need to remotely send a command to stop MSDE before starting the backup,
> anyone knows the command string I need to use?
> Thank you

You really should be doing SQL backups not filesystem backups of SQL
databases. Set your backup software to ignore .MDF, .NDF, and .LDF
files.
Use SQL to back up the databases to a backup location on disk. Then
let your backup software back those up. I doubt a file system restore
will get you what you need in a production setting.

Just for knowledge, stopping and starting SQL with the CMD prompt


rem stop sql
rem stop sql agent first
net stop sqlagent
net stop sqlservr


rem start sql
rem start sql agent last
net start sqlservr
net start sqlagent



Look into "net stop" and "net start" if it is being done locally.
Create a batch file to stop it, and another to restart it after the
backup. If it's remote there's a program called SC.

See below

http://www.itnewsgroups.net/group/mi...topic4164.aspx

Good luck!

David Hay

Thank you, we do backup the MSDE database using OSQL.
But I'm trying to do a symantec system recover type backup which creates a
complete image of the drive and to do it properly it requires the MSDE to be
stopped.
I have one question:
the commands below, are they arun on the server or can I do it remotely by
typing the server name? For example:

net stop sqlservr \\MSDE_SERVER_Name

thank you

"David Hay" wrote:

> On Jun 17, 12:25 pm, Vic Abrahamian
> <VicAbraham...@discussions.microsoft.com> wrote:
> > Hi,
> > I use MSDE with latest service pack. As you may know MSDE is not Volume
> > Shadow Copy aware. I have a backup software which requires me to stop MSDE
> > before it can properly backup the none-vss-aware (volume shadow copy)
> > database.
> > I need to remotely send a command to stop MSDE before starting the backup,
> > anyone knows the command string I need to use?
> > Thank you
>
> You really should be doing SQL backups not filesystem backups of SQL
> databases. Set your backup software to ignore .MDF, .NDF, and .LDF
> files.
> Use SQL to back up the databases to a backup location on disk. Then
> let your backup software back those up. I doubt a file system restore
> will get you what you need in a production setting.
>
> Just for knowledge, stopping and starting SQL with the CMD prompt
>
>
> rem stop sql
> rem stop sql agent first
> net stop sqlagent
> net stop sqlservr
>
>
> rem start sql
> rem start sql agent last
> net start sqlservr
> net start sqlagent
>
>
>
> Look into "net stop" and "net start" if it is being done locally.
> Create a batch file to stop it, and another to restart it after the
> backup. If it's remote there's a program called SC.
>
> See below
>
> http://www.itnewsgroups.net/group/mi...topic4164.aspx
>
> Good luck!
>
> David Hay
>

Download the netsvc file from

http://www.petri.co.il/download_free_reskit_tools.htm

Put it in system or system32

then you will need a batch file like this

rem to stop sql
netsvc "sqlserveragent" \\targetserver /stop
netsvc "mssqlserver" \\targetserver /stop


rem perform backup

rem to start sql
netsvc "sqlserveragent" \\targetserver /start
netsvc "mssqlserver" \\targetserver /start

Or you can use the net stop / net start commands via the local task
scheduler.

Hope that s.

David