backup problem

• surma.sql

  SSCommitted

  Points: 1552

  More actions

  August 2, 2012 at 2:19 pm

  #279814

  hello

  I have very wired problem

  I schedule my back up at 3:00 AM everyday.and it store backup to different server.

  now last 7-10 days I notice, there is one more schedule for same backup and dump into Virtual_Drive and its physical device name something like

  58e156c7-d753-4457-82b4-2a149c91e585

  44383b7d-5de6-4d40-95e7-078d6fb997c0

  da5051d4-eb95-43d3-9446-ea5a44ab8e16

  This number or name will keep changing everytime

  so what was this?

  please help me to understand.

  Thanks

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  August 2, 2012 at 2:28 pm

  #1521137

  surma.sql (8/2/2012)

  ---

  hello

  I have very wired problem

  I schedule my back up at 3:00 AM everyday.and it store backup to different server.

  now last 7-10 days I notice, there is one more schedule for same backup and dump into Virtual_Drive and its physical device name something like

  58e156c7-d753-4457-82b4-2a149c91e585

  44383b7d-5de6-4d40-95e7-078d6fb997c0

  da5051d4-eb95-43d3-9446-ea5a44ab8e16

  This number or name will keep changing everytime

  so what was this?

  please help me to understand.

  Thanks

  If the job is there somebody or something put it there. Check the job, try to figure out who owns it and what exactly does.

  Looks to me like somebody is taking a personal backup of the data.

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

• surma.sql

  SSCommitted

  Points: 1552

  More actions

  August 2, 2012 at 2:30 pm

  #1521138

  PaulB-TheOneAndOnly (8/2/2012)

  ---

  surma.sql (8/2/2012)

  ---

  hello

  I have very wired problem

  I schedule my back up at 3:00 AM everyday.and it store backup to different server.

  now last 7-10 days I notice, there is one more schedule for same backup and dump into Virtual_Drive and its physical device name something like

  58e156c7-d753-4457-82b4-2a149c91e585

  44383b7d-5de6-4d40-95e7-078d6fb997c0

  da5051d4-eb95-43d3-9446-ea5a44ab8e16

  This number or name will keep changing everytime

  so what was this?

  please help me to understand.

  Thanks

  If the job is there somebody or something put it there. Check the job, try to figure out who owns it and what exactly does.

  Looks to me like somebody is taking a personal backup of the data.

  ok, But that job runs everyday at 23:40 and i not seen any schedule job in SQL Server Agent.

  so this looks wired to me.

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  August 2, 2012 at 2:40 pm

  #1521141

  surma.sql (8/2/2012)

  ---

  PaulB-TheOneAndOnly (8/2/2012)

  ---

  surma.sql (8/2/2012)

  ---

  hello

  I have very wired problem

  I schedule my back up at 3:00 AM everyday.and it store backup to different server.

  now last 7-10 days I notice, there is one more schedule for same backup and dump into Virtual_Drive and its physical device name something like

  58e156c7-d753-4457-82b4-2a149c91e585

  44383b7d-5de6-4d40-95e7-078d6fb997c0

  da5051d4-eb95-43d3-9446-ea5a44ab8e16

  This number or name will keep changing everytime

  so what was this?

  please help me to understand.

  Thanks

  If the job is there somebody or something put it there. Check the job, try to figure out who owns it and what exactly does.

  Looks to me like somebody is taking a personal backup of the data.

  ok, But that job runs everyday at 23:40 and i not seen any schedule job in SQL Server Agent.

  so this looks wired to me.

  Check Windows scheduler.

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

• surma.sql

  SSCommitted

  Points: 1552

  More actions

  August 2, 2012 at 2:44 pm

  #1521143

  sorry but can you please tell me how to check that

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  August 2, 2012 at 2:45 pm

  #1521144

  disable sql server vss writer service.

  Alex S

• surma.sql

  SSCommitted

  Points: 1552

  More actions

  August 2, 2012 at 2:49 pm

  #1521147

  AlexSQLForums (8/2/2012)

  ---

  disable sql server vss writer service.

  Thanks Alex, But it already Stoped

• surma.sql

  SSCommitted

  Points: 1552

  More actions

  August 2, 2012 at 2:57 pm

  #1521153

  PaulB-TheOneAndOnly (8/2/2012)

  ---

  surma.sql (8/2/2012)

  ---

  PaulB-TheOneAndOnly (8/2/2012)

  ---

  surma.sql (8/2/2012)

  ---

  hello

  I have very wired problem

  I schedule my back up at 3:00 AM everyday.and it store backup to different server.

  now last 7-10 days I notice, there is one more schedule for same backup and dump into Virtual_Drive and its physical device name something like

  58e156c7-d753-4457-82b4-2a149c91e585

  44383b7d-5de6-4d40-95e7-078d6fb997c0

  da5051d4-eb95-43d3-9446-ea5a44ab8e16

  This number or name will keep changing everytime

  so what was this?

  please help me to understand.

  Thanks

  If the job is there somebody or something put it there. Check the job, try to figure out who owns it and what exactly does.

  Looks to me like somebody is taking a personal backup of the data.

  ok, But that job runs everyday at 23:40 and i not seen any schedule job in SQL Server Agent.

  so this looks wired to me.

  Check Windows scheduler.

  I check scheduler, There is nothing in their

  so what i need to do for this

  please help me for that

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  August 2, 2012 at 3:30 pm

  #1521161

  surma.sql (8/2/2012)

  ---

  I check scheduler, There is nothing in their

  so what i need to do for this

  Monitor the system at 23:40 - see from where the process is connecting to the system.

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

• andersg98

  SSCertifiable

  Points: 5180

  More actions

  August 2, 2012 at 3:43 pm

  #1521166

  is there an Maintenance plan set up?

• surma.sql

  SSCommitted

  Points: 1552

  More actions

  August 2, 2012 at 4:18 pm

  #1521176

  andersg98 (8/2/2012)

  ---

  is there an Maintenance plan set up?

  Yes the Maintainance Plan is good at running 3:00 am everyday

  and its physical device name is the disk address what i am pointing for backup

  but i don't know what is that 58e156c7-d753-4457-82b4-2a149c91e585 for physical device name(it called as virtual drive) which will running at 23:40 everyday.

  I can't see in the list of schedule.