Prev: Return 0 (zero) when null
Next: How to Use Powershell to Exec an "ALTER PROC" Script on EveryDB
From: Uri Dimant on 13 Apr 2010 07:59
Yep, thanks


"Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote in
message news:OOdE7fv2KHA.5212(a)TK2MSFTNGP04.phx.gbl...
> 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
>>>
>>
>>


From: yaro137 on 13 Apr 2010 08:51
On 13 Apr, 12:59, "Uri Dimant" <u...(a)iscar.co.il> wrote:
> Yep, thanks
>
> "Tibor Karaszi" <tibor_please.no.email_kara...(a)hotmail.nomail.com> wrote in
> messagenews:OOdE7fv2KHA.5212(a)TK2MSFTNGP04.phx.gbl...
>
> > 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" <u...(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_kara...(a)hotmail.nomail.com> wrote
> >> in messagenews:%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" <yaro...(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

Well it's SBS backup that I use so it just backs up everything. Are
you saying that when the backup runs at some point it specifically
calls the SQL VSS Writer service to backup SQL rather than sticking
with Windows VSS? I'm not sure how to check the size of the database.
However it doesn't occur everyday. Most of the time when the backup
(Windows server backup) runs it's all fine. When I went into MS SQL
Management Studio Express I dug my way to find some sort of logs. I
found something under Management>SQL Server Logs. Now, whenever my
backup fails because the person responsible for swapping the drives
removes it before the backup finishes there is a new log in the SQL
Server Logs section that day. I can't view the logs as the only option
I get is to Refresh. If I disable the SQL VSS service will that affect
whatever backup is set up in SQL? Thanks
yaro
First  |  Prev  | 
Pages: 1 2
Prev: Return 0 (zero) when null
Next: How to Use Powershell to Exec an "ALTER PROC" Script on EveryDB