Re: Backing up MS-SQL without the TDP

2002-02-08 Thread Wholey, Joseph (TGA\\MLOL) 

If you have the space on the SQL server, use MS' built in feature to back it up 
locally, then back it with TSM and delete it.

-Original Message-
From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 2:31 PM
To: [EMAIL PROTECTED]
Subject: Backing up MS-SQL without the TDP

Has anyone got a working procedure they use to backup a server with MS-SQL
on it, without using the TDP ?  We can't afford to by any more licenses of
the TDP.

I realize there is an SC.EXE program that can be used to shut-down and
start the SQL process.

Any help would be appreciated.

Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: [EMAIL PROTECTED]  -  voice: 804-828-4807

Re: Backing up MS-SQL without the TDP

2002-02-08 Thread Zoltan Forray/AC/VCU 

This is what I am leaning towards.

However, simply stopping the service isn't enough. The tables are still
"in use".






Uwe Schreiber <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/08/2002 02:35 PM
Please respond to "ADSM: Dist Stor Manager"


To: [EMAIL PROTECTED]
        cc:
    Subject:Re: Backing up MS-SQL without the TDP


Hi,

you have the coice.

1. Make an online backup of your database to disk using the provided
machenism of SQL-Server,
and the backup will be during the normal scheduled backup.

or

2. Stop the Services for MS-SQL during a PRECOMMANDSCHEDULE. You can use
the mentioned SC.EXE tool
provided by the NT Resource Kit, scripted to stop the services.
After the offline-backup, use a POSTCOMMANDSCHEDULE. You can use the
SC.EXE tool, scripted to start the services.

Regards,
Uwe Schreiber





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08.02.2002 20:29
Please respond to ADSM-L


To: [EMAIL PROTECTED]
        bcc:
        Subject:Backing up MS-SQL without the TDP

Has anyone got a working procedure they use to backup a server with MS-SQL
on it, without using the TDP ?  We can't afford to by any more licenses of
the TDP.

I realize there is an SC.EXE program that can be used to shut-down and
start the SQL process.

Any help would be appreciated.

--
-- Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: [EMAIL PROTECTED]  -  voice: 804-828-4807

Re: Backing up MS-SQL without the TDP

2002-02-08 Thread Bruce Kamp 

Why not just use SQL's backup procedure & backup to local disc & then this
will be backed up when you do your file system backups?  I do this on a
couple of my smaller DB's


Bruce Kamp
Network Analyst II
Memorial Healthcare System
P: (954) 987-2020 x6008
E: [EMAIL PROTECTED]


-Original Message-
From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 2:31 PM
To: [EMAIL PROTECTED]
Subject: Backing up MS-SQL without the TDP

Has anyone got a working procedure they use to backup a server with MS-SQL
on it, without using the TDP ?  We can't afford to by any more licenses of
the TDP.

I realize there is an SC.EXE program that can be used to shut-down and
start the SQL process.

Any help would be appreciated.


Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: [EMAIL PROTECTED]  -  voice: 804-828-4807

Re: Backing up MS-SQL without the TDP

2002-02-08 Thread Joe Cascanette 

You can schedule SQL to create backups of your databases to a directory before TSM 
starts it backup (TSM can pick up the backup files). You can then restore the 
databases into a fresh copy of SQL if needed. Check the Microsoft site for procedures 
for this (restore from backup). This worked fine (abit longer to restore) in your DR 
testing.

We dont use TDP for SQL, again $$$ is a factor...

Joe Cascanette
The Cumis Group Limited

-Original Message-
From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 2:31 PM
To: [EMAIL PROTECTED]
Subject: Backing up MS-SQL without the TDP


Has anyone got a working procedure they use to backup a server with MS-SQL
on it, without using the TDP ?  We can't afford to by any more licenses of
the TDP.

I realize there is an SC.EXE program that can be used to shut-down and
start the SQL process.

Any help would be appreciated.

Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: [EMAIL PROTECTED]  -  voice: 804-828-4807

Backing up MS-SQL without the TDP

2002-02-08 Thread Zoltan Forray/AC/VCU 

Has anyone got a working procedure they use to backup a server with MS-SQL
on it, without using the TDP ?  We can't afford to by any more licenses of
the TDP.

I realize there is an SC.EXE program that can be used to shut-down and
start the SQL process.

Any help would be appreciated.

Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: [EMAIL PROTECTED]  -  voice: 804-828-4807

Re: Backing up MS-SQL without the TDP

2002-02-08 Thread Uwe Schreiber 

Hi,

you have the coice.

1. Make an online backup of your database to disk using the provided
machenism of SQL-Server,
and the backup will be during the normal scheduled backup.

or

2. Stop the Services for MS-SQL during a PRECOMMANDSCHEDULE. You can use
the mentioned SC.EXE tool
provided by the NT Resource Kit, scripted to stop the services.
After the offline-backup, use a POSTCOMMANDSCHEDULE. You can use the
SC.EXE tool, scripted to start the services.

Regards,
Uwe Schreiber





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08.02.2002 20:29
Please respond to ADSM-L


To: [EMAIL PROTECTED]
bcc:
Subject:Backing up MS-SQL without the TDP

Has anyone got a working procedure they use to backup a server with MS-SQL
on it, without using the TDP ?  We can't afford to by any more licenses of
the TDP.

I realize there is an SC.EXE program that can be used to shut-down and
start the SQL process.

Any help would be appreciated.

--
-- Zoltan Forray
Virginia Commonwealth University - University Computing Center
e-mail: [EMAIL PROTECTED]  -  voice: 804-828-4807