Cannot restore database: file

Showing posts with label file. Show all posts

Thursday, March 29, 2012

Can't compress (zip) DB backup - please help.

I am doing Backup - zip - ftp - unzip - restore of my database. Backup is
allways done without problems, but when I am trying to zip backup file (Send
to > Compressed Zip folder) I get the message "Compressed folder error -
file not found or no read permission" !!
However, I file IS there - it have about 3Gb. I have all permissions too - I
can rename or delete it. I have tried to compress with pkzip too. PkZip
succeeds, but then it is impossible to unzip that file. It sounds like some
security problem.
All that happens on:
- Windows 2003
- SQL Server 2000
Please help - give me just fingerpost where to look for answer.
--Whichever compression program you are using, check that they support files
larger than 2 Gig. If using WinZip, use the latest version as it supports
the Zip64 format, which handles files > 2 Gig in size. I believe WinRar
also supports files > 2 Gig. Not sure about PkZip.
Alternatively, you could try our product, MiniSQLBackup, which allows you to
create and restore directly to/from compressed files.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Try MiniSQLBackup
"Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
> I am doing Backup - zip - ftp - unzip - restore of my database. Backup is
> allways done without problems, but when I am trying to zip backup file
(Send
> to > Compressed Zip folder) I get the message "Compressed folder error -
> file not found or no read permission" !!
> However, I file IS there - it have about 3Gb. I have all permissions too -
I
> can rename or delete it. I have tried to compress with pkzip too. PkZip
> succeeds, but then it is impossible to unzip that file. It sounds like
some
> security problem.
> All that happens on:
> - Windows 2003
> - SQL Server 2000
> Please help - give me just fingerpost where to look for answer.
> --
>
>|||Yes, I have checked - I have compressed successfully and larger files than
3Gb. It seems somthing like SQL Server keeps backup locked for read...
--
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:%23RdPwZSXEHA.2408@.tk2msftngp13.phx.gbl...
> Whichever compression program you are using, check that they support files
> larger than 2 Gig. If using WinZip, use the latest version as it supports
> the Zip64 format, which handles files > 2 Gig in size. I believe WinRar
> also supports files > 2 Gig. Not sure about PkZip.
> Alternatively, you could try our product, MiniSQLBackup, which allows you
to
> create and restore directly to/from compressed files.
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backups? Try MiniSQLBackup
> "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
> > I am doing Backup - zip - ftp - unzip - restore of my database. Backup
is
> > allways done without problems, but when I am trying to zip backup file
> (Send
> > to > Compressed Zip folder) I get the message "Compressed folder error -
> > file not found or no read permission" !!
> > However, I file IS there - it have about 3Gb. I have all permissions
too -
> I
> > can rename or delete it. I have tried to compress with pkzip too. PkZip
> > succeeds, but then it is impossible to unzip that file. It sounds like
> some
> > security problem.
> >
> > All that happens on:
> > - Windows 2003
> > - SQL Server 2000
> >
> > Please help - give me just fingerpost where to look for answer.
> >
> > --
> >
> >
> >
> >
>|||Ok, you mean the built-in windows explorer compressor. I've tried it and I
get the same error whenever I try to compress ANY single file > 2 Gig in
size. The backup file can't possibly be locked if you can rename / delete
it as you mentioned in your first post.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
news:%23Mvdt1ZXEHA.3284@.TK2MSFTNGP12.phx.gbl...
> Yes, I have checked - I have compressed successfully and larger files
than
> 3Gb. It seems somthing like SQL Server keeps backup locked for read...
> --
>
> "Peter Yeoh" <nospam@.nospam.com> wrote in message
> news:%23RdPwZSXEHA.2408@.tk2msftngp13.phx.gbl...
> > Whichever compression program you are using, check that they support
files
> > larger than 2 Gig. If using WinZip, use the latest version as it
supports
> > the Zip64 format, which handles files > 2 Gig in size. I believe WinRar
> > also supports files > 2 Gig. Not sure about PkZip.
> >
> > Alternatively, you could try our product, MiniSQLBackup, which allows
you
> to
> > create and restore directly to/from compressed files.
> >
> > Peter Yeoh
> > http://www.yohz.com
> > Need smaller SQL2K backups? Try MiniSQLBackup
> >
> > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
> > > I am doing Backup - zip - ftp - unzip - restore of my database. Backup
> is
> > > allways done without problems, but when I am trying to zip backup file
> > (Send
> > > to > Compressed Zip folder) I get the message "Compressed folder
error -
> > > file not found or no read permission" !!
> > > However, I file IS there - it have about 3Gb. I have all permissions
> too -
> > I
> > > can rename or delete it. I have tried to compress with pkzip too.
PkZip
> > > succeeds, but then it is impossible to unzip that file. It sounds like
> > some
> > > security problem.
> > >
> > > All that happens on:
> > > - Windows 2003
> > > - SQL Server 2000
> > >
> > > Please help - give me just fingerpost where to look for answer.
> > >
> > > --
> > >
> > >
> > >
> > >
> >
> >
>|||Yes I know it can't be locked if I can rename / delete it - I mentioned that
because it is weird.
I don't get this error when compressing another file that have 6.2Gb - it is
compressed and decompressed OK.
--
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:uU3AyHaXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Ok, you mean the built-in windows explorer compressor. I've tried it and
I
> get the same error whenever I try to compress ANY single file > 2 Gig in
> size. The backup file can't possibly be locked if you can rename / delete
> it as you mentioned in your first post.
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backup files? Try MiniSQLBackup
>
> "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> news:%23Mvdt1ZXEHA.3284@.TK2MSFTNGP12.phx.gbl...
> > Yes, I have checked - I have compressed successfully and larger files
> than
> > 3Gb. It seems somthing like SQL Server keeps backup locked for read...
> >
> > --
> >
> >
> >
> > "Peter Yeoh" <nospam@.nospam.com> wrote in message
> > news:%23RdPwZSXEHA.2408@.tk2msftngp13.phx.gbl...
> > > Whichever compression program you are using, check that they support
> files
> > > larger than 2 Gig. If using WinZip, use the latest version as it
> supports
> > > the Zip64 format, which handles files > 2 Gig in size. I believe
WinRar
> > > also supports files > 2 Gig. Not sure about PkZip.
> > >
> > > Alternatively, you could try our product, MiniSQLBackup, which allows
> you
> > to
> > > create and restore directly to/from compressed files.
> > >
> > > Peter Yeoh
> > > http://www.yohz.com
> > > Need smaller SQL2K backups? Try MiniSQLBackup
> > >
> > > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > > news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
> > > > I am doing Backup - zip - ftp - unzip - restore of my database.
Backup
> > is
> > > > allways done without problems, but when I am trying to zip backup
file
> > > (Send
> > > > to > Compressed Zip folder) I get the message "Compressed folder
> error -
> > > > file not found or no read permission" !!
> > > > However, I file IS there - it have about 3Gb. I have all permissions
> > too -
> > > I
> > > > can rename or delete it. I have tried to compress with pkzip too.
> PkZip
> > > > succeeds, but then it is impossible to unzip that file. It sounds
like
> > > some
> > > > security problem.
> > > >
> > > > All that happens on:
> > > > - Windows 2003
> > > > - SQL Server 2000
> > > >
> > > > Please help - give me just fingerpost where to look for answer.
> > > >
> > > > --
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Sorry, I have no idea what may be wrong, though I'll be interested if you
find out why.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
news:u23OqVaXEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Yes I know it can't be locked if I can rename / delete it - I mentioned
that
> because it is weird.
> I don't get this error when compressing another file that have 6.2Gb - it
is
> compressed and decompressed OK.
> --
>
> "Peter Yeoh" <nospam@.nospam.com> wrote in message
> news:uU3AyHaXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > Ok, you mean the built-in windows explorer compressor. I've tried it
and
> I
> > get the same error whenever I try to compress ANY single file > 2 Gig in
> > size. The backup file can't possibly be locked if you can rename /
delete
> > it as you mentioned in your first post.
> >
> > Peter Yeoh
> > http://www.yohz.com
> > Need smaller SQL2K backup files? Try MiniSQLBackup
> >
> >
> > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > news:%23Mvdt1ZXEHA.3284@.TK2MSFTNGP12.phx.gbl...
> > > Yes, I have checked - I have compressed successfully and larger files
> > than
> > > 3Gb. It seems somthing like SQL Server keeps backup locked for read...
> > >
> > > --
> > >
> > >
> > >
> > > "Peter Yeoh" <nospam@.nospam.com> wrote in message
> > > news:%23RdPwZSXEHA.2408@.tk2msftngp13.phx.gbl...
> > > > Whichever compression program you are using, check that they support
> > files
> > > > larger than 2 Gig. If using WinZip, use the latest version as it
> > supports
> > > > the Zip64 format, which handles files > 2 Gig in size. I believe
> WinRar
> > > > also supports files > 2 Gig. Not sure about PkZip.
> > > >
> > > > Alternatively, you could try our product, MiniSQLBackup, which
allows
> > you
> > > to
> > > > create and restore directly to/from compressed files.
> > > >
> > > > Peter Yeoh
> > > > http://www.yohz.com
> > > > Need smaller SQL2K backups? Try MiniSQLBackup
> > > >
> > > > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > > > news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
> > > > > I am doing Backup - zip - ftp - unzip - restore of my database.
> Backup
> > > is
> > > > > allways done without problems, but when I am trying to zip backup
> file
> > > > (Send
> > > > > to > Compressed Zip folder) I get the message "Compressed folder
> > error -
> > > > > file not found or no read permission" !!
> > > > > However, I file IS there - it have about 3Gb. I have all
permissions
> > > too -
> > > > I
> > > > > can rename or delete it. I have tried to compress with pkzip too.
> > PkZip
> > > > > succeeds, but then it is impossible to unzip that file. It sounds
> like
> > > > some
> > > > > security problem.
> > > > >
> > > > > All that happens on:
> > > > > - Windows 2003
> > > > > - SQL Server 2000
> > > > >
> > > > > Please help - give me just fingerpost where to look for answer.
> > > > >
> > > > > --
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Now, I have tried with GZIP and it works OK. So, it could be because of
impotence of PKZip 2.5 and Compressor under Windows 2003 to compress files
larger than 2Gb. Strage bahaviour, because it work fine with Win2003 compr.
and file size 6,2 Gb.
However, with GZIP it works fine...
Thanks for answers Peter.
Regards,
Marko S
--
"Peter Yeoh" <nospam@.nospam.com> wrote in message
news:%233wsj%23aXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> Sorry, I have no idea what may be wrong, though I'll be interested if you
> find out why.
> Peter Yeoh
> http://www.yohz.com
> Need smaller SQL2K backup files? Try MiniSQLBackup
>
> "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> news:u23OqVaXEHA.3664@.TK2MSFTNGP12.phx.gbl...
> > Yes I know it can't be locked if I can rename / delete it - I mentioned
> that
> > because it is weird.
> > I don't get this error when compressing another file that have 6.2Gb -
it
> is
> > compressed and decompressed OK.
> >
> > --
> >
> >
> >
> > "Peter Yeoh" <nospam@.nospam.com> wrote in message
> > news:uU3AyHaXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > Ok, you mean the built-in windows explorer compressor. I've tried it
> and
> > I
> > > get the same error whenever I try to compress ANY single file > 2 Gig
in
> > > size. The backup file can't possibly be locked if you can rename /
> delete
> > > it as you mentioned in your first post.
> > >
> > > Peter Yeoh
> > > http://www.yohz.com
> > > Need smaller SQL2K backup files? Try MiniSQLBackup
> > >
> > >
> > > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > > news:%23Mvdt1ZXEHA.3284@.TK2MSFTNGP12.phx.gbl...
> > > > Yes, I have checked - I have compressed successfully and larger
files
> > > than
> > > > 3Gb. It seems somthing like SQL Server keeps backup locked for
read...
> > > >
> > > > --
> > > >
> > > >
> > > >
> > > > "Peter Yeoh" <nospam@.nospam.com> wrote in message
> > > > news:%23RdPwZSXEHA.2408@.tk2msftngp13.phx.gbl...
> > > > > Whichever compression program you are using, check that they
support
> > > files
> > > > > larger than 2 Gig. If using WinZip, use the latest version as it
> > > supports
> > > > > the Zip64 format, which handles files > 2 Gig in size. I believe
> > WinRar
> > > > > also supports files > 2 Gig. Not sure about PkZip.
> > > > >
> > > > > Alternatively, you could try our product, MiniSQLBackup, which
> allows
> > > you
> > > > to
> > > > > create and restore directly to/from compressed files.
> > > > >
> > > > > Peter Yeoh
> > > > > http://www.yohz.com
> > > > > Need smaller SQL2K backups? Try MiniSQLBackup
> > > > >
> > > > > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > > > > news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
> > > > > > I am doing Backup - zip - ftp - unzip - restore of my database.
> > Backup
> > > > is
> > > > > > allways done without problems, but when I am trying to zip
backup
> > file
> > > > > (Send
> > > > > > to > Compressed Zip folder) I get the message "Compressed folder
> > > error -
> > > > > > file not found or no read permission" !!
> > > > > > However, I file IS there - it have about 3Gb. I have all
> permissions
> > > > too -
> > > > > I
> > > > > > can rename or delete it. I have tried to compress with pkzip
too.
> > > PkZip
> > > > > > succeeds, but then it is impossible to unzip that file. It
sounds
> > like
> > > > > some
> > > > > > security problem.
> > > > > >
> > > > > > All that happens on:
> > > > > > - Windows 2003
> > > > > > - SQL Server 2000
> > > > > >
> > > > > > Please help - give me just fingerpost where to look for answer.
> > > > > >
> > > > > > --
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Glad it worked out for you.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
news:uaBSea1XEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Now, I have tried with GZIP and it works OK. So, it could be because of
> impotence of PKZip 2.5 and Compressor under Windows 2003 to compress files
> larger than 2Gb. Strage bahaviour, because it work fine with Win2003
compr.
> and file size 6,2 Gb.
> However, with GZIP it works fine...
> Thanks for answers Peter.
> Regards,
> Marko S
> --
>
> "Peter Yeoh" <nospam@.nospam.com> wrote in message
> news:%233wsj%23aXEHA.1888@.TK2MSFTNGP11.phx.gbl...
> > Sorry, I have no idea what may be wrong, though I'll be interested if
you
> > find out why.
> >
> > Peter Yeoh
> > http://www.yohz.com
> > Need smaller SQL2K backup files? Try MiniSQLBackup
> >
> >
> > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > news:u23OqVaXEHA.3664@.TK2MSFTNGP12.phx.gbl...
> > > Yes I know it can't be locked if I can rename / delete it - I
mentioned
> > that
> > > because it is weird.
> > > I don't get this error when compressing another file that have 6.2Gb -
> it
> > is
> > > compressed and decompressed OK.
> > >
> > > --
> > >
> > >
> > >
> > > "Peter Yeoh" <nospam@.nospam.com> wrote in message
> > > news:uU3AyHaXEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > > Ok, you mean the built-in windows explorer compressor. I've tried
it
> > and
> > > I
> > > > get the same error whenever I try to compress ANY single file > 2
Gig
> in
> > > > size. The backup file can't possibly be locked if you can rename /
> > delete
> > > > it as you mentioned in your first post.
> > > >
> > > > Peter Yeoh
> > > > http://www.yohz.com
> > > > Need smaller SQL2K backup files? Try MiniSQLBackup
> > > >
> > > >
> > > > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > > > news:%23Mvdt1ZXEHA.3284@.TK2MSFTNGP12.phx.gbl...
> > > > > Yes, I have checked - I have compressed successfully and larger
> files
> > > > than
> > > > > 3Gb. It seems somthing like SQL Server keeps backup locked for
> read...
> > > > >
> > > > > --
> > > > >
> > > > >
> > > > >
> > > > > "Peter Yeoh" <nospam@.nospam.com> wrote in message
> > > > > news:%23RdPwZSXEHA.2408@.tk2msftngp13.phx.gbl...
> > > > > > Whichever compression program you are using, check that they
> support
> > > > files
> > > > > > larger than 2 Gig. If using WinZip, use the latest version as
it
> > > > supports
> > > > > > the Zip64 format, which handles files > 2 Gig in size. I
believe
> > > WinRar
> > > > > > also supports files > 2 Gig. Not sure about PkZip.
> > > > > >
> > > > > > Alternatively, you could try our product, MiniSQLBackup, which
> > allows
> > > > you
> > > > > to
> > > > > > create and restore directly to/from compressed files.
> > > > > >
> > > > > > Peter Yeoh
> > > > > > http://www.yohz.com
> > > > > > Need smaller SQL2K backups? Try MiniSQLBackup
> > > > > >
> > > > > > "Marko S" <marko.NOsladoljevSPAM@.si.htnet.hr> wrote in message
> > > > > > news:uPOxN3QXEHA.2636@.TK2MSFTNGP10.phx.gbl...
> > > > > > > I am doing Backup - zip - ftp - unzip - restore of my
database.
> > > Backup
> > > > > is
> > > > > > > allways done without problems, but when I am trying to zip
> backup
> > > file
> > > > > > (Send
> > > > > > > to > Compressed Zip folder) I get the message "Compressed
folder
> > > > error -
> > > > > > > file not found or no read permission" !!
> > > > > > > However, I file IS there - it have about 3Gb. I have all
> > permissions
> > > > > too -
> > > > > > I
> > > > > > > can rename or delete it. I have tried to compress with pkzip
> too.
> > > > PkZip
> > > > > > > succeeds, but then it is impossible to unzip that file. It
> sounds
> > > like
> > > > > > some
> > > > > > > security problem.
> > > > > > >
> > > > > > > All that happens on:
> > > > > > > - Windows 2003
> > > > > > > - SQL Server 2000
> > > > > > >
> > > > > > > Please help - give me just fingerpost where to look for
answer.
> > > > > > >
> > > > > > > --
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Tuesday, March 27, 2012

Can''t change the Auto growth option on my Database

I'm currently using SQL Server 2005. Before I have set my database on unrestricted auto growth. But today, I have noticed that the Log file has been set to limit its growth to 2,097,152 MB. I have 160GB space for my log files, I just want to maximize the space for logs in my hard drive.

When I try to change the settings back to auto growth it still keeps on returning to its previous setting it is still set on 2,097,152 MB. What I did was :

Right Click on the Database - Properties - Files - Click the (...) - set the auto growth option to unrestricted - Click Ok

But when I checked log file, it is still set on 2,097,152MB.

Can some one help me change the settings of my Database.

I think its the maximum to which the log file can grow i.e upto 2 TB refer,

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=175549

even if you set it as unlimited it reverts to 2 TB i guess....it seems to be a bug with sp1 and is closed by design, even if you alter the filegrowth through scripts it doesnt revert

|||

Is there any querry / command that I can use to set the auto growth option on my log files? my real problem was giving the log files a different settings. My database was running for almost 1 year now. This is the first time that I saw this kind of error, well actually it doesnt return any error. It just doesn't accept the settings that I gave.

Having 160GB of Hard Disk space and my log file is being limited to just 2GB is very frustraiting (lol) Hope you guys can give me some ideas.

|||

the query is available in my previous post (link) i gave and they have clearly showed that you cannot change the settings through query either........go for SP2 but i am not sure it will yield the desired results....it was a bug with sp1

|||

But you aren't limited to 2 GB. You are limited to 2 TB.

2,097,152 MB = 2 TB (not 2 GB).

If you were trying to set it to a size greater than 2,097,152 MB, it wasn't an allowable value as you would have been trying to exceed the 2 GB max for a transaction log size.

-Sue

|||

If it is set to 2TB then why doest it now allow me to make any changes on my data? Sorry for the nooby questions and mistakes. I just dont want anything bad to happen on my database.

What are the solutions that I can make to change it back to normal?

|||

No problem on the noob questions...everyone starts there at some point.

Going back to your problem, what you really want to do is give some details on what the problem really is - all we have to go on is the auto growth and file size issue but in this post you said you can't make any changes to your data. Could you give us a step by step example of what issues you are running into, what the exact error number and messages are?

Thanks,

-Sue

Can't back up Encryption Key

I am trying to backup Encryption Key for my reporting service. Configuration tool, prompts for a encryption key file location and a strong password. When I provide the same and click OK, I get the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's (Exception from HRESULT: 0x80070A91)
End of inner exception stack trace
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)

I have tried with passwords with different combination but none of them seem to help. Any ideas?

It looks like your system has a password complexity filter installed. If you search on the error message, you will see a number of articles explaining how you can build and install one; I would check to see if that's the case first.

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

Can't back up Encryption Key

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

I have tried with passwords with different combination but none of them seem to help. Any ideas?

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

Can't back up Encryption Key

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

I have tried with passwords with different combination but none of them seem to help. Any ideas?

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

Can't Attach to DB File using SSMS

Hi all,

I have "SQL Server Express" as well as SSMS-E installed on the same machine. I am trying to get SSMS-E to connect to a database (i.e., an .MDF file) that resides in a folder on the desktop.

After establishing a connection to my "SQL Server Express" instance within SSMS-E, I right-click on "Databases", in the "Object Explorer" window and select "Attach..." and click the "Add..." button. The resulting dialog box opens in the directory:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" where I see several MDF files. But as I said, my MDF is not in this directory - it's on the desktop.

If I try to navigate to the proper directory on the desktop I see no MDF files. In fact, I cannot even navigate past my username -- that is, I cannot even navigate to the desktop, let alone folders on the desktop. I don't know why.

Of course I *could* put the MDF file in the SQL-E approved directory but shouldn't I just be able to navigate to it using SSMS-E? Incidentally, I *AM* able to connect to the database on my desktop if I use Visual Studio and I specify "UserInstance=true". Not specifying "UserInstance=true" results in this error:

An attempt to attach an auto-named database for file C:\Documents and Settings\Robin\Desktop\MyCompany.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Can someone explain what might be causing the problem with SSMS-E, and, for that matter, why it's necessary to specify "UserInstance=true" in Visual Studio?

Thanks so much. I hope these are not too many questions.

Robin

You are attempting to attach a file that is located in a 'protected' storage area -specifically your private 'Desktop'. That file would not be available to other users of the computer. You can attach it to a user instance since that user instance will be restricted for your use only and other users could not access it.

If you want to attach the file to the server, move the file from your 'Desktop' to a storage area accessible for all users of SQL Server.

Sunday, March 25, 2012

cant append multiple Diff backups to same file?...

I run two different types of backups on the same database.
A monthly full and nightly diffs appending to the same full file - file 'A'
A weekly full with 10 min trans log backups appending to same file - file
'B'- during working hours.
2 strategies, 2 backup files.
These are new strats that have gone live this week - tuesday in fact. The
monthly and weekly both ran fine on tuesday as did the nightly diff and all
the TS backups througout the day. last night - Weds - the nightly diff faile
d
with the following error:
"
Executed as user: <USERNAME>. Cannot perform a differential backup for
database "objectstore", because a current database backup does not exist.
Perform a full database backup by reissuing BACKUP DATABASE, omitting the
WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE
is
terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
"
Whilst the error is perfectly legible I dont understand what its implying -
cant I add multiple Diff backups to the same full backup OR is my weekly / 1
0
mins on the same database (but to a diff backup file) ballsing things up for
me somehow? If this is the case how come everything ran fine on tuesday nigh
t?
Any help gets beers.
THanks
Alastair Jones.I shoudl add that the chronology of the backups is as follows:
monthly init @. 7am first tues of month to file A
weekly init @. 7.30 Am tuesdays to file B
nightly diff to file A @. 2215 nightly
TL backups to file B every 10 mins
"Methodology" wrote:

> I run two different types of backups on the same database.
> A monthly full and nightly diffs appending to the same full file - file 'A
'
> A weekly full with 10 min trans log backups appending to same file - file
> 'B'- during working hours.
> 2 strategies, 2 backup files.
> These are new strats that have gone live this week - tuesday in fact. The
> monthly and weekly both ran fine on tuesday as did the nightly diff and al
l
> the TS backups througout the day. last night - Weds - the nightly diff fai
led
> with the following error:
> "
> Executed as user: <USERNAME>. Cannot perform a differential backup for
> database "objectstore", because a current database backup does not exist.
> Perform a full database backup by reissuing BACKUP DATABASE, omitting the
> WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABA
SE is
> terminating abnormally. [SQLSTATE 42000] (Error 3013). The step faile
d.
> "
>
> Whilst the error is perfectly legible I dont understand what its implying
-
> cant I add multiple Diff backups to the same full backup OR is my weekly /
10
> mins on the same database (but to a diff backup file) ballsing things up f
or
> me somehow? If this is the case how come everything ran fine on tuesday ni
ght?
> Any help gets beers.
> THanks
> Alastair Jones.
>

cant append multiple Diff backups to same file?...

I run two different types of backups on the same database.
A monthly full and nightly diffs appending to the same full file - file 'A'
A weekly full with 10 min trans log backups appending to same file - file
'B'- during working hours.
2 strategies, 2 backup files.
These are new strats that have gone live this week - tuesday in fact. The
monthly and weekly both ran fine on tuesday as did the nightly diff and all
the TS backups througout the day. last night - Weds - the nightly diff failed
with the following error:
"
Executed as user: <USERNAME>. Cannot perform a differential backup for
database "objectstore", because a current database backup does not exist.
Perform a full database backup by reissuing BACKUP DATABASE, omitting the
WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE is
terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
"
Whilst the error is perfectly legible I dont understand what its implying -
cant I add multiple Diff backups to the same full backup OR is my weekly / 10
mins on the same database (but to a diff backup file) ballsing things up for
me somehow? If this is the case how come everything ran fine on tuesday night?
Any help gets beers.
THanks
Alastair Jones.I shoudl add that the chronology of the backups is as follows:
monthly init @. 7am first tues of month to file A
weekly init @. 7.30 Am tuesdays to file B
nightly diff to file A @. 2215 nightly
TL backups to file B every 10 mins
"Methodology" wrote:
> I run two different types of backups on the same database.
> A monthly full and nightly diffs appending to the same full file - file 'A'
> A weekly full with 10 min trans log backups appending to same file - file
> 'B'- during working hours.
> 2 strategies, 2 backup files.
> These are new strats that have gone live this week - tuesday in fact. The
> monthly and weekly both ran fine on tuesday as did the nightly diff and all
> the TS backups througout the day. last night - Weds - the nightly diff failed
> with the following error:
> "
> Executed as user: <USERNAME>. Cannot perform a differential backup for
> database "objectstore", because a current database backup does not exist.
> Perform a full database backup by reissuing BACKUP DATABASE, omitting the
> WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE is
> terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
> "
>
> Whilst the error is perfectly legible I dont understand what its implying -
> cant I add multiple Diff backups to the same full backup OR is my weekly / 10
> mins on the same database (but to a diff backup file) ballsing things up for
> me somehow? If this is the case how come everything ran fine on tuesday night?
> Any help gets beers.
> THanks
> Alastair Jones.
>

cant append multiple Diff backups to same file?...

I run two different types of backups on the same database.
A monthly full and nightly diffs appending to the same full file - file 'A'
A weekly full with 10 min trans log backups appending to same file - file
'B'- during working hours.
2 strategies, 2 backup files.
These are new strats that have gone live this week - tuesday in fact. The
monthly and weekly both ran fine on tuesday as did the nightly diff and all
the TS backups througout the day. last night - Weds - the nightly diff failed
with the following error:
"
Executed as user: <USERNAME>. Cannot perform a differential backup for
database "objectstore", because a current database backup does not exist.
Perform a full database backup by reissuing BACKUP DATABASE, omitting the
WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE is
terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
"
Whilst the error is perfectly legible I dont understand what its implying -
cant I add multiple Diff backups to the same full backup OR is my weekly / 10
mins on the same database (but to a diff backup file) ballsing things up for
me somehow? If this is the case how come everything ran fine on tuesday night?
Any help gets beers.
THanks
Alastair Jones.
I shoudl add that the chronology of the backups is as follows:
monthly init @. 7am first tues of month to file A
weekly init @. 7.30 Am tuesdays to file B
nightly diff to file A @. 2215 nightly
TL backups to file B every 10 mins
"Methodology" wrote:

> I run two different types of backups on the same database.
> A monthly full and nightly diffs appending to the same full file - file 'A'
> A weekly full with 10 min trans log backups appending to same file - file
> 'B'- during working hours.
> 2 strategies, 2 backup files.
> These are new strats that have gone live this week - tuesday in fact. The
> monthly and weekly both ran fine on tuesday as did the nightly diff and all
> the TS backups througout the day. last night - Weds - the nightly diff failed
> with the following error:
> "
> Executed as user: <USERNAME>. Cannot perform a differential backup for
> database "objectstore", because a current database backup does not exist.
> Perform a full database backup by reissuing BACKUP DATABASE, omitting the
> WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE is
> terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
> "
>
> Whilst the error is perfectly legible I dont understand what its implying -
> cant I add multiple Diff backups to the same full backup OR is my weekly / 10
> mins on the same database (but to a diff backup file) ballsing things up for
> me somehow? If this is the case how come everything ran fine on tuesday night?
> Any help gets beers.
> THanks
> Alastair Jones.
>

Can't add stored procedure to SQL Express

I select New Stored Procedure from the context menu of the stored procedure
tab in my database, and it procedes to makes a file called SQLQuery1.sql and
saves it as a file, but doesn't add it to the list of my stored procedures...
How do I add it? What am I doing wrong? I see no method of importing the sql
file into my database...
Any help appreciated
Stored procedures are created by executing the statement(s) in the
SQLQuery1.sql file. You don't mention what interface you're using (e.g.
Visual Studio, SQL Server Management Studio, etc.), but you should have an
EXECUTE button somewhere on the toolbar. With the file open, click EXECUTE.
Assuming no errors were encountered the stored procedure is created in the
database. You can keep the file that contains the CREATE PROC statement or
not depending on your needs.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"BLiTZWiNG" <BLiTZWiNG@.discussions.microsoft.com> wrote in message
news:273B5E46-FCBE-4D90-A5C6-7A37ADDC1CE9@.microsoft.com...
>I select New Stored Procedure from the context menu of the stored procedure
> tab in my database, and it procedes to makes a file called SQLQuery1.sql
> and
> saves it as a file, but doesn't add it to the list of my stored
> procedures...
> How do I add it? What am I doing wrong? I see no method of importing the
> sql
> file into my database...
> Any help appreciated
|||Thanks for that. I'm using the Managment Studio CTP (not sure if there is a
release version of it). Anyway, Execute worked for me. I never thought to
Execute it because the SP relies on parameters to execute, so without some
test data I just figured Execute would fail and do nothing else. It did not
seem obvious to me though that the Execute command would add the SP to the
database.
"Gail Erickson [MS]" wrote:

> Stored procedures are created by executing the statement(s) in the
> SQLQuery1.sql file. You don't mention what interface you're using (e.g.
> Visual Studio, SQL Server Management Studio, etc.), but you should have an
> EXECUTE button somewhere on the toolbar. With the file open, click EXECUTE.
> Assuming no errors were encountered the stored procedure is created in the
> database. You can keep the file that contains the CREATE PROC statement or
> not depending on your needs.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> "BLiTZWiNG" <BLiTZWiNG@.discussions.microsoft.com> wrote in message
> news:273B5E46-FCBE-4D90-A5C6-7A37ADDC1CE9@.microsoft.com...
>
>
|||> I never thought to
> Execute it because the SP relies on parameters to execute, so without some
> test data I just figured Execute would fail and do nothing else. It did
> not
> seem obvious to me though that the Execute command would add the SP to the
> database.
Okay, I can understand how you would think that. It's important to
understand that when you use the Execute button, only the statement or
statements in the query window are executed. In your case, the T-SQL
statement CREATE PROCEDURE is executed, but the statements could also have
been INSERT, DELETE, ALTER PROCEDURE, or any other T-SQL statement.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"BLiTZWiNG" <BLiTZWiNG@.discussions.microsoft.com> wrote in message
news:AFF3E778-449C-4D24-9DD5-2D7E3B70D5B9@.microsoft.com...[vbcol=seagreen]
> Thanks for that. I'm using the Managment Studio CTP (not sure if there is
> a
> release version of it). Anyway, Execute worked for me. I never thought to
> Execute it because the SP relies on parameters to execute, so without some
> test data I just figured Execute would fail and do nothing else. It did
> not
> seem obvious to me though that the Execute command would add the SP to the
> database.
> "Gail Erickson [MS]" wrote:

Tuesday, March 20, 2012

can't access MSDE database after setup

I can't log in with osql. My setup config file is as below.
[Options]
INSTANCENAME=NetSDK
SECURITYMODE=SQL
SAPWD=mypassword
It seems to install and run (green arrow in service bar after giving
it
myservername\NetSDK). Then I try this:
osql -U sa
Password: 'I give mypassword here
[Shared Memory]SQL Server does not exists or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What does this mean? Am I missing something basic? I would really like
to use MSDE, but it seems broken or I just don't have enough
information.
Please cc to jhestess@.yahoo.com. Thanks in advance.
John Estess
El Paso, Texas
This may be a problem with ports or other things. Try these:
"Potential causes of the "SQL Server Does Not Exist or Access Denied" error message"
http://support.microsoft.com/default...06&Product=sql
http://support.microsoft.com/?id=287932
http://support.microsoft.com/default.aspx?kbid=814130
Mark Ferguson
"John Estess" wrote:

> I can't log in with osql. My setup config file is as below.
> [Options]
> INSTANCENAME=NetSDK
> SECURITYMODE=SQL
> SAPWD=mypassword
> It seems to install and run (green arrow in service bar after giving
> it
> myservername\NetSDK). Then I try this:
> osql -U sa
> Password: 'I give mypassword here
> [Shared Memory]SQL Server does not exists or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What does this mean? Am I missing something basic? I would really like
> to use MSDE, but it seems broken or I just don't have enough
> information.
> Please cc to jhestess@.yahoo.com. Thanks in advance.
> John Estess
> El Paso, Texas
>
|||hi John,
"John Estess" <jhestess@.yahoo.com> ha scritto nel messaggio
news:136cf350.0406250942.1417a8a7@.posting.google.c om...
> I can't log in with osql. My setup config file is as below.
> [Options]
> INSTANCENAME=NetSDK
> SECURITYMODE=SQL
> SAPWD=mypassword
> It seems to install and run (green arrow in service bar after giving
> it
> myservername\NetSDK). Then I try this:
> osql -U sa
> Password: 'I give mypassword here
> [Shared Memory]SQL Server does not exists or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What does this mean? Am I missing something basic? I would really like
> to use MSDE, but it seems broken or I just don't have enough
> information.
> Please cc to jhestess@.yahoo.com. Thanks in advance.
> John Estess
> El Paso, Texas
try
c:\>osql -Smyservername\NetSDK -Usa -Pyour_pwd
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Monday, March 19, 2012

cannt remove data file from user database

We are running SQL server 2003 with SP3. I'm trying to
shrink a data files with the emptyfile option so I can
eventually remove the file using the alter database
command. However, I get the following error message when I
run the alter database command:

Error: the file PRADATA4 cannot be removed because it is
not empty.

The file that I'm trying to remove still has 62 extents on it.
I looked MS Knowledge base 254253 and 279511 on this problem but they say it is corrected by SQL server 7.0 with service pack 3.
commands that I'm running are as follows:

1) USE PRA
DBCC TRACEON(8901)
DBCC SHRINKFILE ('PRADATA4', EMPTYFILE)
DBCC TRACEOFF(8901)

2) USE PRA
GO
ALTERDATABASE PRA
REMOVE FILE PRADATA4
GO

Can anyone help?

ThanksYou are shrinking one file, but removing another. This sounds like a sub-optimal approach to me.

-PatP|||Originally posted by Pat Phelan
You are shrinking one file, but removing another. This sounds like a sub-optimal approach to me.

-PatP
sorry,I write error,the commands are:
1) USE PRA
DBCC TRACEON(8901)
DBCC SHRINKFILE ('PRADATA4', EMPTYFILE)
DBCC TRACEOFF(8901)

2) USE PRA
GO
ALTERDATABASE PRA
REMOVE FILE PRADATA4
GO|||First make sure there are no open transactions that are stopping this piece of data from being moved and ensure to try with trace flags as specified in one of the KBAs.|||Originally posted by Satya
First make sure there are no open transactions that are stopping this piece of data from being moved and ensure to try with trace flags as specified in one of the KBAs.

How to check open transactions?Use sp_who2?|||DBCC OPENTRAN and refer to books online for more information.|||Originally posted by Satya
DBCC OPENTRAN and refer to books online for more information.
Hi Satya:
Yesterday , I restarted our database service,and used DBCC OPENTRAN to check there are no open transactions,but we still cann't remove the PRADATA4 from database.

Thanks|||Books Online (BOL) documents the REMOVE FILE option of ALTER DATABASE, but BOL doesn't tell you that you first need to run SHRINKFILE('file_name', EMPTYFILE). This command shrinks the file to 0MB of space used and ensures that you've removed all the objects from the file.|||Originally posted by Satya
Books Online (BOL) documents the REMOVE FILE option of ALTER DATABASE, but BOL doesn't tell you that you first need to run SHRINKFILE('file_name', EMPTYFILE). This command shrinks the file to 0MB of space used and ensures that you've removed all the objects from the file.
Hi Satya:
Thanks for your help,I have used KB 324432 to resolve the problem.

Sunday, March 11, 2012

Cannot view log for SQL Agent job (SQL2005)

Hi,
I've set up jobs and output files in SQL2005. When the job is completed, I
would like to check the output file by clicking VIEW button. However, the
button is grey-out.
The owner of the job is sa. What is other permission I missed ?
Thanks.Hi Johnny
"Johnny" wrote:
> Hi,
> I've set up jobs and output files in SQL2005. When the job is completed, I
> would like to check the output file by clicking VIEW button. However, the
> button is grey-out.
> The owner of the job is sa. What is other permission I missed ?
> Thanks.
According to Books Online it is not available in SQL 2005
From Books Online:
View
In Microsoft SQL Server 2005, this button is disabled for viewing output
files. Instead, use Notepad to view job step output files. In Microsoft SQL
Server 2000, this launches Notepad to view the output file.
John|||Hi John,
Thank you. Why leave the button there ?
Regards,
Johnny
"John Bell" wrote:
> Hi Johnny
> "Johnny" wrote:
> > Hi,
> >
> > I've set up jobs and output files in SQL2005. When the job is completed, I
> > would like to check the output file by clicking VIEW button. However, the
> > button is grey-out.
> >
> > The owner of the job is sa. What is other permission I missed ?
> >
> > Thanks.
> According to Books Online it is not available in SQL 2005
> From Books Online:
> View
> In Microsoft SQL Server 2005, this button is disabled for viewing output
> files. Instead, use Notepad to view job step output files. In Microsoft SQL
> Server 2000, this launches Notepad to view the output file.
>
> John
>|||Hi Johnny
"Johnny" wrote:
> Hi John,
> Thank you. Why leave the button there ?
> Regards,
> Johnny
> "John Bell" wrote:
> > According to Books Online it is not available in SQL 2005
> >
> > From Books Online:
> >
> > View
> > In Microsoft SQL Server 2005, this button is disabled for viewing output
> > files. Instead, use Notepad to view job step output files. In Microsoft SQL
> > Server 2000, this launches Notepad to view the output file.
> >
> >
> > John
> >
I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
will bring up the log file in Notepad!!!!
John|||Yes, I always check the output file for any jobs in SQL2000 Agent job.
"John Bell" wrote:
> Hi Johnny
> "Johnny" wrote:
> > Hi John,
> >
> > Thank you. Why leave the button there ?
> >
> > Regards,
> > Johnny
> >
> > "John Bell" wrote:
> >
> > > According to Books Online it is not available in SQL 2005
> > >
> > > From Books Online:
> > >
> > > View
> > > In Microsoft SQL Server 2005, this button is disabled for viewing output
> > > files. Instead, use Notepad to view job step output files. In Microsoft SQL
> > > Server 2000, this launches Notepad to view the output file.
> > >
> > >
> > > John
> > >
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John|||"John Bell" wrote:
> I guess that if you are looking at a SQL 2000 instance of SQL Agent then it
> will bring up the log file in Notepad!!!!
> John
And it does!!
John

Cannot view log data

I created a perfmon counter log with some SQL server counters and started
the log and ran it for a few minutes and then decided to view the log file
that I created ( .blg) . I could not see anything. Did i do it right ? I
created the log and was viewing it from the same perfmon toolHassan
Did you add the same counters to perfom monitor.
BTW , what is version of the server? (NT or Windows 2000 Server ,etc)
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O3nV6n0eDHA.2364@.TK2MSFTNGP09.phx.gbl...
> I created a perfmon counter log with some SQL server counters and started
> the log and ran it for a few minutes and then decided to view the log file
> that I created ( .blg) . I could not see anything. Did i do it right ? I
> created the log and was viewing it from the same perfmon tool
>
>

cannot view

Thought I edited a previous post but apparently not. The cannot view problem is with a png file inserted on a start page of a web site. Other Gif and Jpeg files are viewable with IE and Mozilla but not the png file.

Your post is marked as a question but there is no question in it. How can we help?

Thanks
Laurentiu

|||Sorry for the confusion as I am a new user to these boards and didn't get the post in place as I intended. We've placed some banner ads from sponsors on our web site and I cannot view them with IE. The ones that are there in either Gif or Jpeg are viewable but we have one in png and I cannot see it. This same banner is on another site in Germany and I cannot view that one either. I've also tried other browsers such as Mozilla and get the same results. I'm of the opinion there is a setting in XP or my Norton 2005 program that may be causing the problem but so far have not been able to find it. Any help would be greatly appreciated.|||

I'd like to help but I don't know the answer to your question - this is a SQL Server newsgroup focused on security. Someone may know the answer to this, but it's a safer bet to post to an appropriate newsgroup.
To venture a guess, you may need to convert the image to a supported format or you may need to upgrade your IE browser.

For figuring out why IE does not display the PNG banner, you should check the IE newsgroups from the link below:

http://www.microsoft.com/windows/ie/support/newsgroups/default.mspx

Search for threads that discuss PNG issues and if you don't find an answer to your question on those newsgroups, then I suggest that you post your question again there.

Thanks
Laurentiu

|||thank you for your help in guiding me to the correct board to post my question.

Tim

Cannot use the OUTPUT option when passing a constant to a stored p

Hi,
I'm trying to export a text column into a text file using the bcp command
but I keep getting the error message in the subject line. So I checked the
database properties and didn't find anything.
My Code:
bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" out
"I:\sttr\STTRLabsIn.txt" -c -T
go
Does anyone know why I am getting this message?
Much Appreciated,
ChiekoError message? Wish I could see it.
ML|||Since your BCP source is a query rather than a table/view, you need to
specify 'queryout' instead of 'out'.
Hope this helps.
Dan Guzman
SQL Server MVP
"chieko" <chieko@.discussions.microsoft.com> wrote in message
news:A82B768C-9367-447E-81DE-8EBFFAFBD62C@.microsoft.com...
> Hi,
> I'm trying to export a text column into a text file using the bcp command
> but I keep getting the error message in the subject line. So I checked the
> database properties and didn't find anything.
> My Code:
> bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
> WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" out
> "I:\sttr\STTRLabsIn.txt" -c -T
> go
> Does anyone know why I am getting this message?
> Much Appreciated,
> Chieko
>

Thursday, March 29, 2012

Can't compress (zip) DB backup - please help.

Can't compress (zip) DB backup - please help.

Can't compress (zip) DB backup - please help.

Tuesday, March 27, 2012

Can''t change the Auto growth option on my Database

Can't back up Encryption Key

Can't back up Encryption Key

Can't back up Encryption Key

Can't Attach to DB File using SSMS

Sunday, March 25, 2012

cant append multiple Diff backups to same file?...

cant append multiple Diff backups to same file?...

cant append multiple Diff backups to same file?...

Can't add stored procedure to SQL Express

Tuesday, March 20, 2012

can't access MSDE database after setup

Monday, March 19, 2012

cannt remove data file from user database

Sunday, March 11, 2012

Cannot view log for SQL Agent job (SQL2005)

Cannot view log for SQL Agent job (SQL2005)

Cannot view log for SQL Agent job (SQL2005)

Cannot view log data

cannot view

Cannot use the OUTPUT option when passing a constant to a stored p

Cannot restore database

Blog Archive

About Me