Showing posts with label win. Show all posts
Showing posts with label win. Show all posts

Monday, March 12, 2012

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.
Vito,
Check if sqlagent is running.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.
|||I'm sure you have verified this, but have you checked to make sure that the job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure that the job in question has a yes in the enabled column.
|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.Vito,
Check if sqlagent is running.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.|||I'm sure you have verified this, but have you checked to make sure that the
job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure
that the job in question has a yes in the enabled column.|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.Vito,
Check if sqlagent is running.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.|||I'm sure you have verified this, but have you checked to make sure that the job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure that the job in question has a yes in the enabled column.|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Friday, March 9, 2012

Schedule the shutdown selected clients.

Hi all,
We running a Win 2000 domain with XP sp2 clients.
I have been asked to find a way to shutdown selected clients on a Friday
evening. Is there any way to schedule this through a GPO?
I am considering configuring a script to run shutdown.exe in a batch file
but obviously this offers no way to control the process centrally. Does
anyone know of a better way?
Ideally I would like to save any documents left open before the shutdown.
All advice is greatly appreciated. Simon.Hi
This is the SQL Server NG, you may get a bettwer answer by posting this to
the .Windows.* NG.
Off the top of my head, look at http://www.microsoft.com/smserver/ and
http://www.microsoft.com/MOM/
Regards
Mike
"Simon" wrote:
> Hi all,
> We running a Win 2000 domain with XP sp2 clients.
> I have been asked to find a way to shutdown selected clients on a Friday
> evening. Is there any way to schedule this through a GPO?
> I am considering configuring a script to run shutdown.exe in a batch file
> but obviously this offers no way to control the process centrally. Does
> anyone know of a better way?
> Ideally I would like to save any documents left open before the shutdown.
> All advice is greatly appreciated. Simon.
>
>

Schedule the shutdown selected clients.

Hi all,
We running a Win 2000 domain with XP sp2 clients.
I have been asked to find a way to shutdown selected clients on a Friday
evening. Is there any way to schedule this through a GPO?
I am considering configuring a script to run shutdown.exe in a batch file
but obviously this offers no way to control the process centrally. Does
anyone know of a better way?
Ideally I would like to save any documents left open before the shutdown.
All advice is greatly appreciated. Simon.
Hi
This is the SQL Server NG, you may get a bettwer answer by posting this to
the .Windows.* NG.
Off the top of my head, look at http://www.microsoft.com/smserver/ and
http://www.microsoft.com/MOM/
Regards
Mike
"Simon" wrote:

> Hi all,
> We running a Win 2000 domain with XP sp2 clients.
> I have been asked to find a way to shutdown selected clients on a Friday
> evening. Is there any way to schedule this through a GPO?
> I am considering configuring a script to run shutdown.exe in a batch file
> but obviously this offers no way to control the process centrally. Does
> anyone know of a better way?
> Ideally I would like to save any documents left open before the shutdown.
> All advice is greatly appreciated. Simon.
>
>

Schedule the shutdown selected clients.

Hi all,
We running a Win 2000 domain with XP sp2 clients.
I have been asked to find a way to shutdown selected clients on a Friday
evening. Is there any way to schedule this through a GPO?
I am considering configuring a script to run shutdown.exe in a batch file
but obviously this offers no way to control the process centrally. Does
anyone know of a better way?
Ideally I would like to save any documents left open before the shutdown.
All advice is greatly appreciated. Simon.Hi
This is the SQL Server NG, you may get a bettwer answer by posting this to
the .Windows.* NG.
Off the top of my head, look at http://www.microsoft.com/smserver/ and
http://www.microsoft.com/MOM/
Regards
Mike
"Simon" wrote:

> Hi all,
> We running a Win 2000 domain with XP sp2 clients.
> I have been asked to find a way to shutdown selected clients on a Friday
> evening. Is there any way to schedule this through a GPO?
> I am considering configuring a script to run shutdown.exe in a batch file
> but obviously this offers no way to control the process centrally. Does
> anyone know of a better way?
> Ideally I would like to save any documents left open before the shutdown.
> All advice is greatly appreciated. Simon.
>
>