Prev: Return 0 (zero) when null
Next: How to Use Powershell to Exec an "ALTER PROC" Script on EveryDB
From: yaro137 on 13 Apr 2010 04:38
I noticed that my server backup is running terribly slow at some
times. I suspect that this is somehow linked to SQL VSS Writer
service. Unfortunately I'm a complete newbie in SQL management and
couldn't figure out where to look to get to some logs or something
that would tell me what is that service doing. Any help?
yaro
From: Uri Dimant on 13 Apr 2010 05:30
yaro137
How big is the database? Do you run the backup during the day activities?


"yaro137" <yaro137(a)googlemail.com> wrote in message
news:d6806055-a6b3-4407-ba16-23bc946ef4d2(a)k33g2000yqc.googlegroups.com...
>I noticed that my server backup is running terribly slow at some
> times. I suspect that this is somehow linked to SQL VSS Writer
> service. Unfortunately I'm a complete newbie in SQL management and
> couldn't figure out where to look to get to some logs or something
> that would tell me what is that service doing. Any help?
> yaro


From: Tibor Karaszi on 13 Apr 2010 06:22
If you don't want the SQL Server databases to be part of your VSS backup,
then stop the SQL Server VSS service (and exclude the SQL Server database
files from the machine backup). And of course do backup of the SQL Server
database using traditional SQL Server backups.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"yaro137" <yaro137(a)googlemail.com> wrote in message
news:d6806055-a6b3-4407-ba16-23bc946ef4d2(a)k33g2000yqc.googlegroups.com...
> I noticed that my server backup is running terribly slow at some
> times. I suspect that this is somehow linked to SQL VSS Writer
> service. Unfortunately I'm a complete newbie in SQL management and
> couldn't figure out where to look to get to some logs or something
> that would tell me what is that service doing. Any help?
> yaro

From: Uri Dimant on 13 Apr 2010 06:48
Hi Tibor
I sent you email yesterday (at hotmail), can you please respond?

"Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote in
message news:%23TygKNv2KHA.5820(a)TK2MSFTNGP06.phx.gbl...
> If you don't want the SQL Server databases to be part of your VSS backup,
> then stop the SQL Server VSS service (and exclude the SQL Server database
> files from the machine backup). And of course do backup of the SQL Server
> database using traditional SQL Server backups.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
>
> "yaro137" <yaro137(a)googlemail.com> wrote in message
> news:d6806055-a6b3-4407-ba16-23bc946ef4d2(a)k33g2000yqc.googlegroups.com...
>> I noticed that my server backup is running terribly slow at some
>> times. I suspect that this is somehow linked to SQL VSS Writer
>> service. Unfortunately I'm a complete newbie in SQL management and
>> couldn't figure out where to look to get to some logs or something
>> that would tell me what is that service doing. Any help?
>> yaro
>


From: Tibor Karaszi on 13 Apr 2010 06:56
Hi Uri,

Landed in my junk folder for some reason. I just replied...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Uri Dimant" <urid(a)iscar.co.il> wrote in message
news:e#Vqqav2KHA.3568(a)TK2MSFTNGP04.phx.gbl...
> Hi Tibor
> I sent you email yesterday (at hotmail), can you please respond?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote
> in message news:%23TygKNv2KHA.5820(a)TK2MSFTNGP06.phx.gbl...
>> If you don't want the SQL Server databases to be part of your VSS backup,
>> then stop the SQL Server VSS service (and exclude the SQL Server database
>> files from the machine backup). And of course do backup of the SQL Server
>> database using traditional SQL Server backups.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>>
>> "yaro137" <yaro137(a)googlemail.com> wrote in message
>> news:d6806055-a6b3-4407-ba16-23bc946ef4d2(a)k33g2000yqc.googlegroups.com...
>>> I noticed that my server backup is running terribly slow at some
>>> times. I suspect that this is somehow linked to SQL VSS Writer
>>> service. Unfortunately I'm a complete newbie in SQL management and
>>> couldn't figure out where to look to get to some logs or something
>>> that would tell me what is that service doing. Any help?
>>> yaro
>>
>
>
 |  Next  |  Last
Pages: 1 2
Prev: Return 0 (zero) when null
Next: How to Use Powershell to Exec an "ALTER PROC" Script on EveryDB