Hello,
The datasourece in my report contains a date field, and the time portion of
this date field is showing up. Is there a format function that I can use in
the textbox or do I need to remove the time portion at the datasource level?
If there is some kind of formatting I can do in the textbox - what does that
look like? What is the syntax?
Thanks,
RichIn the textbox properties, format tab, format code, use 'd'. The format
codes are from .Net you can also use the format function if you need to
concatenate. The elipsi button shows more options.
Steve MunLeeuw
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:93FE2808-E8D0-4F74-BF11-B669FE2718D6@.microsoft.com...
> Hello,
> The datasourece in my report contains a date field, and the time portion
> of
> this date field is showing up. Is there a format function that I can use
> in
> the textbox or do I need to remove the time portion at the datasource
> level?
> If there is some kind of formatting I can do in the textbox - what does
> that
> look like? What is the syntax?
> Thanks,
> Rich|||Thanks. I will give that a try. Although, I did tweak the datasource a
little and added this which also does the trick (just not at the report level
is the thing):
convert(char(8), s.CurExpireDate, 1) CurExpireDate
which returns say - 10/18/06 format
where CurExpireDate was the datefield in my datasource.
May I ask what the syntax looks like using 'd' in the report textbox?
= ...Fields!CurExpireDate.Value
"Steve MunLeeuw" wrote:
> In the textbox properties, format tab, format code, use 'd'. The format
> codes are from .Net you can also use the format function if you need to
> concatenate. The elipsi button shows more options.
> Steve MunLeeuw
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:93FE2808-E8D0-4F74-BF11-B669FE2718D6@.microsoft.com...
> > Hello,
> >
> > The datasourece in my report contains a date field, and the time portion
> > of
> > this date field is showing up. Is there a format function that I can use
> > in
> > the textbox or do I need to remove the time portion at the datasource
> > level?
> >
> > If there is some kind of formatting I can do in the textbox - what does
> > that
> > look like? What is the syntax?
> >
> > Thanks,
> > Rich
>
>|||The expression in the textbox would the the same:
=Fields!CurExpireDate.Value
the textbox is applying the formatting to the contents of the textbox.
If you wanted to concatenate strings then the expression would look
something like this:
= "Generated on " & Format(Globals!ExecutionTime, "d")
Steve MunLeeuw
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:FCE38529-426A-41FC-88DD-EAF9974AB6ED@.microsoft.com...
> Thanks. I will give that a try. Although, I did tweak the datasource a
> little and added this which also does the trick (just not at the report
> level
> is the thing):
> convert(char(8), s.CurExpireDate, 1) CurExpireDate
> which returns say - 10/18/06 format
> where CurExpireDate was the datefield in my datasource.
> May I ask what the syntax looks like using 'd' in the report textbox?
> = ...Fields!CurExpireDate.Value
>
>
> "Steve MunLeeuw" wrote:
>> In the textbox properties, format tab, format code, use 'd'. The format
>> codes are from .Net you can also use the format function if you need to
>> concatenate. The elipsi button shows more options.
>> Steve MunLeeuw
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:93FE2808-E8D0-4F74-BF11-B669FE2718D6@.microsoft.com...
>> > Hello,
>> >
>> > The datasourece in my report contains a date field, and the time
>> > portion
>> > of
>> > this date field is showing up. Is there a format function that I can
>> > use
>> > in
>> > the textbox or do I need to remove the time portion at the datasource
>> > level?
>> >
>> > If there is some kind of formatting I can do in the textbox - what does
>> > that
>> > look like? What is the syntax?
>> >
>> > Thanks,
>> > Rich
>>|||Thank you for this information.
Rich
"Steve MunLeeuw" wrote:
> The expression in the textbox would the the same:
> =Fields!CurExpireDate.Value
> the textbox is applying the formatting to the contents of the textbox.
> If you wanted to concatenate strings then the expression would look
> something like this:
> = "Generated on " & Format(Globals!ExecutionTime, "d")
> Steve MunLeeuw
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:FCE38529-426A-41FC-88DD-EAF9974AB6ED@.microsoft.com...
> > Thanks. I will give that a try. Although, I did tweak the datasource a
> > little and added this which also does the trick (just not at the report
> > level
> > is the thing):
> >
> > convert(char(8), s.CurExpireDate, 1) CurExpireDate
> >
> > which returns say - 10/18/06 format
> >
> > where CurExpireDate was the datefield in my datasource.
> >
> > May I ask what the syntax looks like using 'd' in the report textbox?
> >
> > = ...Fields!CurExpireDate.Value
> >
> >
> >
> >
> > "Steve MunLeeuw" wrote:
> >
> >> In the textbox properties, format tab, format code, use 'd'. The format
> >> codes are from .Net you can also use the format function if you need to
> >> concatenate. The elipsi button shows more options.
> >>
> >> Steve MunLeeuw
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:93FE2808-E8D0-4F74-BF11-B669FE2718D6@.microsoft.com...
> >> > Hello,
> >> >
> >> > The datasourece in my report contains a date field, and the time
> >> > portion
> >> > of
> >> > this date field is showing up. Is there a format function that I can
> >> > use
> >> > in
> >> > the textbox or do I need to remove the time portion at the datasource
> >> > level?
> >> >
> >> > If there is some kind of formatting I can do in the textbox - what does
> >> > that
> >> > look like? What is the syntax?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>
Friday, March 30, 2012
How to exclude the collation property when scripting a table in SQL Server 2005
In Sequel Server 2000 when I used to script the creation of a table, it was
possible to go to the scripting options in SQL Query Analyser and switch off
the Include Collation statements.
However, I cannot seem to find this setting in SQL Server 2005 - can anyone
point me in the right direction as I do not want to include these statements
when I create a CREATE TABLE script.
Thanks in advance
AndyHi Andrew
If you use the scripting wizard there are configurable options that by
default do not include collations. Try right clicking on the management
branch rather than the table and choose the General Scripts option.
John
"Andrew Houghton" wrote:
> In Sequel Server 2000 when I used to script the creation of a table, it was
> possible to go to the scripting options in SQL Query Analyser and switch off
> the Include Collation statements.
> However, I cannot seem to find this setting in SQL Server 2005 - can anyone
> point me in the right direction as I do not want to include these statements
> when I create a CREATE TABLE script.
> Thanks in advance
> Andy
>
>
possible to go to the scripting options in SQL Query Analyser and switch off
the Include Collation statements.
However, I cannot seem to find this setting in SQL Server 2005 - can anyone
point me in the right direction as I do not want to include these statements
when I create a CREATE TABLE script.
Thanks in advance
AndyHi Andrew
If you use the scripting wizard there are configurable options that by
default do not include collations. Try right clicking on the management
branch rather than the table and choose the General Scripts option.
John
"Andrew Houghton" wrote:
> In Sequel Server 2000 when I used to script the creation of a table, it was
> possible to go to the scripting options in SQL Query Analyser and switch off
> the Include Collation statements.
> However, I cannot seem to find this setting in SQL Server 2005 - can anyone
> point me in the right direction as I do not want to include these statements
> when I create a CREATE TABLE script.
> Thanks in advance
> Andy
>
>
How to exclude read-only connections from DTC transactions?
Hi
I'm importing from an Access db into SQL 2005 using SSIS, and I want to execute the package inside a transaction so that I can rollback the import if I get an error. However, it seems the Access connection doesn't support DTC as I get the following error:
[Connection manager "MyConnection"] Error: The connection does not support enlisting in distributed transaction. The error goes away if I set the data flow task's TransactionOption to Supported rather than Required, but obviously I don't then get transactions.
Now, all I want to do is to read from the Access connection so I don't require it to be involved in the transaction. Is there any way I can tell SSIS this, so that it doesn't fall over? Or is there another way to achieve what I want?
On a side note - the read-only "SupportsDTCTransactions" property for the Access connection is set to True even though this is clearly not the case - would this be a bug?
[Also posted to microsoft.private.sqlserver2005.dts - I don't know which is the preferred forum - apologies]
Hi,
I got the same error when I tried to exclude from the distributed transaction a connection to an Excel source. So it seems to be a problem of Microsoft.Jet.OLEDB provider. I also inserted "OLE DB Services = -7;" in the connection string, but it didn't work.|||
|||
I'm importing from an Access db into SQL 2005 using SSIS, and I want to execute the package inside a transaction so that I can rollback the import if I get an error. However, it seems the Access connection doesn't support DTC as I get the following error:
[Connection manager "MyConnection"] Error: The connection does not support enlisting in distributed transaction. The error goes away if I set the data flow task's TransactionOption to Supported rather than Required, but obviously I don't then get transactions.
Now, all I want to do is to read from the Access connection so I don't require it to be involved in the transaction. Is there any way I can tell SSIS this, so that it doesn't fall over? Or is there another way to achieve what I want?
On a side note - the read-only "SupportsDTCTransactions" property for the Access connection is set to True even though this is clearly not the case - would this be a bug?
[Also posted to microsoft.private.sqlserver2005.dts - I don't know which is the preferred forum - apologies]
Hi,
I got the same error when I tried to exclude from the distributed transaction a connection to an Excel source. So it seems to be a problem of Microsoft.Jet.OLEDB provider. I also inserted "OLE DB Services = -7;" in the connection string, but it didn't work.|||
Were I in your shoes, I think I'd load into a temporary table (outside of the transaction), then, inside a transaction, load the real table with an "insert into select from" Execute SQL task.
|||Yeah, I can see that would work, but it'd be fairly inefficient once the data volumes get high. I suppose with Access as a source there's not much danger of that - but I wonder how many other data sources are affected by this?|||
There is same error in my projects. I import data from some dbf files to SQL Server 2005. And I must delete the data from Table A first, then import the data to that table. These two steps shoule be included in a transaction. But SSIS give the error like below:
Error: 0xC0014034 at Package, Connection manager "foxpro": The connection does not support enlisting in distributed transaction.
Error: 0xC0202009 at Package, Connection manager "foxpro": An OLE DB error has occurred. Error code: 0x8000FFFF.
Error: 0xC020801C at 导入CDWArea, OLE DB Source [1]: The AcquireConnection method call to the connection manager "foxpro" failed with error code 0xC0202009.
Error: 0xC004701A at 导入CDWArea, DTS.Pipeline: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC020801C
At the beginning, I use the conncetion driver of "Microsoft Jet 4.0", then I change it to "Visual Foxpro 9.0 ole db". But they are useless.
Anyone? Thansk!
How to exclude read-only connections from DTC transactions?
Hi
I'm importing from an Access db into SQL 2005 using SSIS, and I want to execute the package inside a transaction so that I can rollback the import if I get an error. However, it seems the Access connection doesn't support DTC as I get the following error:
[Connection manager "MyConnection"] Error: The connection does not support enlisting in distributed transaction. The error goes away if I set the data flow task's TransactionOption to Supported rather than Required, but obviously I don't then get transactions.
Now, all I want to do is to read from the Access connection so I don't require it to be involved in the transaction. Is there any way I can tell SSIS this, so that it doesn't fall over? Or is there another way to achieve what I want?
On a side note - the read-only "SupportsDTCTransactions" property for the Access connection is set to True even though this is clearly not the case - would this be a bug?
[Also posted to microsoft.private.sqlserver2005.dts - I don't know which is the preferred forum - apologies]
Hi,
I got the same error when I tried to exclude from the distributed transaction a connection to an Excel source. So it seems to be a problem of Microsoft.Jet.OLEDB provider. I also inserted "OLE DB Services = -7;" in the connection string, but it didn't work.|||
|||
I'm importing from an Access db into SQL 2005 using SSIS, and I want to execute the package inside a transaction so that I can rollback the import if I get an error. However, it seems the Access connection doesn't support DTC as I get the following error:
[Connection manager "MyConnection"] Error: The connection does not support enlisting in distributed transaction. The error goes away if I set the data flow task's TransactionOption to Supported rather than Required, but obviously I don't then get transactions.
Now, all I want to do is to read from the Access connection so I don't require it to be involved in the transaction. Is there any way I can tell SSIS this, so that it doesn't fall over? Or is there another way to achieve what I want?
On a side note - the read-only "SupportsDTCTransactions" property for the Access connection is set to True even though this is clearly not the case - would this be a bug?
[Also posted to microsoft.private.sqlserver2005.dts - I don't know which is the preferred forum - apologies]
Hi,
I got the same error when I tried to exclude from the distributed transaction a connection to an Excel source. So it seems to be a problem of Microsoft.Jet.OLEDB provider. I also inserted "OLE DB Services = -7;" in the connection string, but it didn't work.|||
Were I in your shoes, I think I'd load into a temporary table (outside of the transaction), then, inside a transaction, load the real table with an "insert into select from" Execute SQL task.
|||Yeah, I can see that would work, but it'd be fairly inefficient once the data volumes get high. I suppose with Access as a source there's not much danger of that - but I wonder how many other data sources are affected by this?|||
There is same error in my projects. I import data from some dbf files to SQL Server 2005. And I must delete the data from Table A first, then import the data to that table. These two steps shoule be included in a transaction. But SSIS give the error like below:
Error: 0xC0014034 at Package, Connection manager "foxpro": The connection does not support enlisting in distributed transaction.
Error: 0xC0202009 at Package, Connection manager "foxpro": An OLE DB error has occurred. Error code: 0x8000FFFF.
Error: 0xC020801C at 导入CDWArea, OLE DB Source [1]: The AcquireConnection method call to the connection manager "foxpro" failed with error code 0xC0202009.
Error: 0xC004701A at 导入CDWArea, DTS.Pipeline: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC020801C
At the beginning, I use the conncetion driver of "Microsoft Jet 4.0", then I change it to "Visual Foxpro 9.0 ole db". But they are useless.
Anyone? Thansk!
How to exclude read-only connections from DTC transactions?
Hi
I'm importing from an Access db into SQL 2005 using SSIS, and I want to execute the package inside a transaction so that I can rollback the import if I get an error. However, it seems the Access connection doesn't support DTC as I get the following error:
[Connection manager "MyConnection"] Error: The connection does not support enlisting in distributed transaction. The error goes away if I set the data flow task's TransactionOption to Supported rather than Required, but obviously I don't then get transactions.
Now, all I want to do is to read from the Access connection so I don't require it to be involved in the transaction. Is there any way I can tell SSIS this, so that it doesn't fall over? Or is there another way to achieve what I want?
On a side note - the read-only "SupportsDTCTransactions" property for the Access connection is set to True even though this is clearly not the case - would this be a bug?
[Also posted to microsoft.private.sqlserver2005.dts - I don't know which is the preferred forum - apologies]
Hi,
I got the same error when I tried to exclude from the distributed transaction a connection to an Excel source. So it seems to be a problem of Microsoft.Jet.OLEDB provider. I also inserted "OLE DB Services = -7;" in the connection string, but it didn't work.|||
|||
I'm importing from an Access db into SQL 2005 using SSIS, and I want to execute the package inside a transaction so that I can rollback the import if I get an error. However, it seems the Access connection doesn't support DTC as I get the following error:
[Connection manager "MyConnection"] Error: The connection does not support enlisting in distributed transaction. The error goes away if I set the data flow task's TransactionOption to Supported rather than Required, but obviously I don't then get transactions.
Now, all I want to do is to read from the Access connection so I don't require it to be involved in the transaction. Is there any way I can tell SSIS this, so that it doesn't fall over? Or is there another way to achieve what I want?
On a side note - the read-only "SupportsDTCTransactions" property for the Access connection is set to True even though this is clearly not the case - would this be a bug?
[Also posted to microsoft.private.sqlserver2005.dts - I don't know which is the preferred forum - apologies]
Hi,
I got the same error when I tried to exclude from the distributed transaction a connection to an Excel source. So it seems to be a problem of Microsoft.Jet.OLEDB provider. I also inserted "OLE DB Services = -7;" in the connection string, but it didn't work.|||
Were I in your shoes, I think I'd load into a temporary table (outside of the transaction), then, inside a transaction, load the real table with an "insert into select from" Execute SQL task.
|||Yeah, I can see that would work, but it'd be fairly inefficient once the data volumes get high. I suppose with Access as a source there's not much danger of that - but I wonder how many other data sources are affected by this?|||
There is same error in my projects. I import data from some dbf files to SQL Server 2005. And I must delete the data from Table A first, then import the data to that table. These two steps shoule be included in a transaction. But SSIS give the error like below:
Error: 0xC0014034 at Package, Connection manager "foxpro": The connection does not support enlisting in distributed transaction.
Error: 0xC0202009 at Package, Connection manager "foxpro": An OLE DB error has occurred. Error code: 0x8000FFFF.
Error: 0xC020801C at 导入CDWArea, OLE DB Source [1]: The AcquireConnection method call to the connection manager "foxpro" failed with error code 0xC0202009.
Error: 0xC004701A at 导入CDWArea, DTS.Pipeline: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC020801C
At the beginning, I use the conncetion driver of "Microsoft Jet 4.0", then I change it to "Visual Foxpro 9.0 ole db". But they are useless.
Anyone? Thansk!
sqlHow 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:
>
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:
>
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:
> 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:
> > 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|||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:
> 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
> >
> > 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|||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
> 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:
> > 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
> > >
> > > 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|||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...
> 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
>> 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:
>> > 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
>> > >
>> > > 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|||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:
> 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
> >
> > 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:
> >
> > > 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
> > > >
> > > > 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|||Hi Tom
Thx for Your answer
SP1 for SBS 2003 for now is not an option on this server, It's critical data
on him, and untill I'll not finish all tests of our internal applications -
its impossible. But it not the main problem.
I'd checked again what You was talking about.
Here is second screenshot:
http://selfmade.fromru.com/images/error2.JPG
There is no Databases was chosen for backup, from all server i need backup
few folders, System state and Exchange. But, with all do respect, I unable to
remove "v" from MS SQL folder, as You may see. Its grey, but still there. :)
Fow now I use few workarounds to backup my folders, but still status of
backup is uncompleted. It's acceptable, but need to be better. I am, of
couse, use Maintanance plans to backup folders with recent SQL server DB
backups.
But Is there any option or any other way to perform backup without SQL?
--
Best Regards
Denis Laskov
Arcnet Ltd, Israel
MCSE 2003
"Tom" 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...
> > 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
> >>
> >> 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:
> >>
> >> > 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
> >> > >
> >> > > 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
>
>|||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 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:
> > 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
> > >
> > > 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:
> > >
> > > > 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
> > > > >
> > > > > 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|||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...
> 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 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:
>> > 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
>> > >
>> > > 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:
>> > >
>> > > > 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
>> > > > >
>> > > > > 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|||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:
> 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 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:
> >
> > > 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
> > > >
> > > > 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:
> > > >
> > > > > 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
> > > > > >
> > > > > > 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
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:
> 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:
> > 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|||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:
> 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
> >
> > 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|||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
> 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:
> > 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
> > >
> > > 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|||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...
> 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
>> 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:
>> > 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
>> > >
>> > > 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|||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:
> 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
> >
> > 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:
> >
> > > 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
> > > >
> > > > 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|||Hi Tom
Thx for Your answer
SP1 for SBS 2003 for now is not an option on this server, It's critical data
on him, and untill I'll not finish all tests of our internal applications -
its impossible. But it not the main problem.
I'd checked again what You was talking about.
Here is second screenshot:
http://selfmade.fromru.com/images/error2.JPG
There is no Databases was chosen for backup, from all server i need backup
few folders, System state and Exchange. But, with all do respect, I unable to
remove "v" from MS SQL folder, as You may see. Its grey, but still there. :)
Fow now I use few workarounds to backup my folders, but still status of
backup is uncompleted. It's acceptable, but need to be better. I am, of
couse, use Maintanance plans to backup folders with recent SQL server DB
backups.
But Is there any option or any other way to perform backup without SQL?
--
Best Regards
Denis Laskov
Arcnet Ltd, Israel
MCSE 2003
"Tom" 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...
> > 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
> >>
> >> 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:
> >>
> >> > 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
> >> > >
> >> > > 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
>
>|||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 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:
> > 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
> > >
> > > 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:
> > >
> > > > 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
> > > > >
> > > > > 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|||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...
> 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 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:
>> > 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
>> > >
>> > > 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:
>> > >
>> > > > 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
>> > > > >
>> > > > > 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|||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:
> 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 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:
> >
> > > 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
> > > >
> > > > 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:
> > > >
> > > > > 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
> > > > > >
> > > > > > 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
Subscribe to:
Posts (Atom)