How to exclude from NTBACKUP SQL server?

Hello All
On my server when I use ntbackup, i recieve error:
MSDEWriter has reported a VSS error 0x800423f4.
Its problem known by Microsoft, workaround is:
http://support.microsoft.com/kb/828481/ (but it now work for me)
So question is - how may I exclude from ntbackup checklist SQL server?
Thanks
--
Best Regards
Denis Laskov
Arcnet Ltd, Israel
MCSE 2003Hi
Is this not a case of when you set up the backup to exclude the directory
where the data and log files exist, but include the directory where the
backup of the data has been located?
John
"Denis Laskov" wrote:

> Hello All
> On my server when I use ntbackup, i recieve error:
> MSDEWriter has reported a VSS error 0x800423f4.
> Its problem known by Microsoft, workaround is:
> http://support.microsoft.com/kb/828481/ (but it now work for me)
> So question is - how may I exclude from ntbackup checklist SQL server?
> Thanks
> --
> Best Regards
> Denis Laskov
> Arcnet Ltd, Israel
> MCSE 2003|||Not sure I'am understand You
I need option to uncheck SQL from ntbackup list of object, but it's hidden
or something.
Is there any option to backup selected folders and System State without
backing up SQL server?
thx
--
Best Regards
Denis Laskov
Arcnet Ltd, Israel
MCSE 2003
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Is this not a case of when you set up the backup to exclude the directory
> where the data and log files exist, but include the directory where the
> backup of the data has been located?
> John
> "Denis Laskov" wrote:
>|||Hi Denis
I don't only have XP to go on at the moment, but when you set up the backup
you can select options to backup selected files/folders, this will give you
are tree view and you check what you wish to backup. Prior to your job
running you will need to backup the databases possibly using osql and a
script that issues a BACKUP command.
If you are issuing your NTBACKUP command from a batch file then you can
specify the files to backup in the selection file "@.bks file name", for more
on this look at the windows help by issuing the command NTBACKUP /?
John
"Denis Laskov" wrote:
[vbcol=seagreen]
> Not sure I'am understand You
> I need option to uncheck SQL from ntbackup list of object, but it's hidden
> or something.
> Is there any option to backup selected folders and System State without
> backing up SQL server?
> thx
> --
> Best Regards
> Denis Laskov
> Arcnet Ltd, Israel
> MCSE 2003
>
> "John Bell" wrote:
>|||Hi John
Thanks for Your paition.
Here is Screenshot of ntbackup window:
http://selfmade.fromru.com/images/error.JPG
I cannot find here SQL server selection.
SQL have it's own Maintanance plan Backup so I don't need it in regular
backup.
Best Regards
Denis Laskov
Arcnet Ltd, Israel
MCSE 2003
"John Bell" wrote:
[vbcol=seagreen]
> Hi Denis
> I don't only have XP to go on at the moment, but when you set up the backu
p
> you can select options to backup selected files/folders, this will give yo
u
> are tree view and you check what you wish to backup. Prior to your job
> running you will need to backup the databases possibly using osql and a
> script that issues a BACKUP command.
> If you are issuing your NTBACKUP command from a batch file then you can
> specify the files to backup in the selection file "@.bks file name", for mo
re
> on this look at the windows help by issuing the command NTBACKUP /?
>
> John
> "Denis Laskov" wrote:
>|||Hello
First thing you should do is to apply Service pack 1 on windows 2003. This
will resolve your problem (http://support.microsoft.com/kb/828481/ ). Well,
it did on my server. There is no more "Reverting to non-shadow copy backup
mode" error. NTbackup can now make a snapshot af all databases and make a
backup. If you don't want to apply SP1 then you have to exclude all SQL
databases from NTbackup (C:\program files\microsoft SQL server\mssql\data is
default location if I remember right) and change their recovery model to
simple. You won't see SQL like you see Exchange in NTbackup tree, you need
to exclude folders where your databases are located.
Don't forget to backup your databases from SQL (SQL jobs, maintenance plans)
and include those backups in NT backup.
Tom
"Denis Laskov" <DenisLaskov@.discussions.microsoft.com> wrote in message
news:5D9210D0-CB5F-492C-B108-4411C48623FC@.microsoft.com...[vbcol=seagreen]
> Hi John
> Thanks for Your paition.
> Here is Screenshot of ntbackup window:
> http://selfmade.fromru.com/images/error.JPG
> I cannot find here SQL server selection.
> SQL have it's own Maintanance plan Backup so I don't need it in regular
> backup.
> --
> Best Regards
> Denis Laskov
> Arcnet Ltd, Israel
> MCSE 2003
>
> "John Bell" wrote:
>|||Hi Denis
To add to Tom's reply, currently you don't seem to have anything selected.
If you want all the C drive to be backed up check next to the C drive, if yo
u
only want part of the drive to be backed up then expand the C drive by
clicking the '+' sign next to it and select what you want at that level.
Expand each level to be more granular.
John
"Denis Laskov" wrote:
[vbcol=seagreen]
> Hi John
> Thanks for Your paition.
> Here is Screenshot of ntbackup window:
> http://selfmade.fromru.com/images/error.JPG
> I cannot find here SQL server selection.
> SQL have it's own Maintanance plan Backup so I don't need it in regular
> backup.
> --
> Best Regards
> Denis Laskov
> Arcnet Ltd, Israel
> MCSE 2003
>
> "John Bell" wrote:
>|||John Hi
Thx for your pation
Please review my answer to Tom with Screenshot of D: drive - MS SqL folder.
Thanks
--
Best Regards
Denis Laskov
Arcnet Ltd, Israel
MCSE 2003
"John Bell" wrote:
[vbcol=seagreen]
> Hi Denis
> To add to Tom's reply, currently you don't seem to have anything selected.
> If you want all the C drive to be backed up check next to the C drive, if
you
> only want part of the drive to be backed up then expand the C drive by
> clicking the '+' sign next to it and select what you want at that level.
> Expand each level to be more granular.
> John
> "Denis Laskov" wrote:
>|||What happens if you select "Microsoft SQL Server" folder to select it and
then click on it again do clear it off? Is it gray again or is it cleared?
But that won't help you with http://support.microsoft.com/kb/828481/
problem. If any of the databases od D drive is not in simple recovery model
than NTbackup will switch to non-shadow copy backup mode. That means that if
you have any system files or any other open files on D drive, they will
probably won't be backed up and you will get errors in backup log.
Tom
"Denis Laskov" <DenisLaskov@.discussions.microsoft.com> wrote in message
news:C50FE487-A583-49B7-B024-8F8445D5C65D@.microsoft.com...[vbcol=seagreen]
> John Hi
> Thx for your pation
> Please review my answer to Tom with Screenshot of D: drive - MS SqL
> folder.
> Thanks
> --
> Best Regards
> Denis Laskov
> Arcnet Ltd, Israel
> MCSE 2003
>
> "John Bell" wrote:
>|||Hi
This may be a permissions thing, although if you go through the backup
wizard and choose the advanced options after selecting the backup device,
there is an option to disable shadow copy backup, which may be the issue if
not selected.
John
"Denis Laskov" wrote:
[vbcol=seagreen]
> John Hi
> Thx for your pation
> Please review my answer to Tom with Screenshot of D: drive - MS SqL folder
.
> Thanks
> --
> Best Regards
> Denis Laskov
> Arcnet Ltd, Israel
> MCSE 2003
>
> "John Bell" wrote:
>