xp cmdshell: folder

Showing posts with label folder. Show all posts

Monday, March 26, 2012

Problem removing old back up files....

I am having problems with removing the update files from a folder. When
a do a new backup, I want it to overwrite the old backup files with the
new one. Apparently the code I am using is wrong. Any suggestions?Hi,
Would you be able to post your code so that people can see if they can
see anything with it or if it's fine?
If you are using BACKUP statements then you have to add "INIT" to the
"WITH" section. This will overwrite whatever backup device (e.g. the
file name) that you specify in the statement. For example:
BACKUP DATABASE Test_DB
TO DISK = 'C:\Test_DB_Backup.bak'
WITH INIT
WIll overwrite the previous contents of Test_DB_Backup.bak. Note that
there are some caveats with using INIT (namely that it won't overwrite
in certain situations) but these are described in SQL Server Books
Online in the topic about the BACKUP statement.
Hope that helps a bit|||EXECUTE master.dbo.xp_sqlmaint N'-PlanID
88FF9022-F638-4939-99FF-2FD57140382C -Rpt "C:\Program Files\Microsoft
SQL Server\MSSQL\LOG\<Backup Sever Name> Backup4.txt" -DelTxtRpt 2WEEKS
-WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "\\<Backup Server
Name>\Backup Do Not Touch\<SQL Server Name>" -DelBkUps 1DAYS
-CrBkSubDir -BkExt "BAK"'
There is the one we are using.|||OK, I see...There is an Database Maintenance Plan in place that will
take a backup of the desired database and delete backups older than one
day.
I don't believe that the sqlmaint utility (the utility that will be
called by xp_sqlmaint) has a switch that orders backups to be
overwritten. If you want to take backups but overwrite them each day
then you'll probably need to define your own SQL Server Agent job that
executes the following T-SQL as per whatever schedule you desire:
BACKUP DATABASE <DB_Name>
TO DISK = '<Path Of Backup File (includes the file name)>'
WITH INIT -- Force an overwrite most of the time (some caveats as
described in Books Online)
BTW, I think that generally it is a good idea to keep a few backup
files just in case something goes wrong with the backup you are
currently taking there is something to fall back on.
Hope that helps a bit

Wednesday, March 21, 2012

Problem opening MSDB folder under Stored Packages

I am able to connect to Integration Services in MSSMS. However, when I try to expand and click on MSDB under Stored Packages, I get a Login Timeout expired error. I get this error both locally, and remotely. Error message suggested "does not allow remote connections", but I checked Surface Area Configuration, and remote connection is already enabled. Moreover, I get the same error even when connecting locally.

any ideas?
Do you have a default instance of SQL Server installed in that machine?|||No, it's a clustersql

Saturday, February 25, 2012

Problem installing SP2

)
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
807fe1c" target="_blank">http://groups.google.com/group/micr...
807fe1c
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo..

)
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>|||cheers john,
I went throo the files (slow friday

) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> cf807fe1c" target="_blank">http://groups.google.com/group/micr...r />
cf807fe1c
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday

) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>|||hi john,
worked great - sorted it all today,

cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>

Problem installing SP2

)
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>
|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
[url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo..

)
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>
|||cheers john,
I went throo the files (slow friday

) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> [url]http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506% 22#fc225bccf807fe1c[/url]
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>
|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday

Problem installing SP2

having an issue installing sp2, ive looked around for other solutions but
none apply, the permissions are fine for that folder.
seems a fairly common problem too, is there a definitive answer ?
cheers
mark
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to
modify security permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 29506
MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
(64-bit) -- Error 29506. SQL Server Setup failed to modify security
permissions on file C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
the account and domain running SQL Server Setup exist, that the account
running SQL Server Setup has administrator privileges, and that exists on
the destination drive.
Error 29506. SQL Server Setup failed to modify security permissions on file
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
Administrator. To proceed, verify that the account and domain running SQL
Server Setup exist, that the account running SQL Server Setup has
administrator privileges, and that exists on the destination drive.
<EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is 0
Action ended 08:54:08: InstallFinalize. Return value 3.Hi Mark
Have you checked the acls on the files within the directory?
Have you excluded database files/directories from any anti-virus software
being used?
Have you switched of the indexing service?
John
"luna" <luna_s@.themoon.com> wrote in message
news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
> having an issue installing sp2, ive looked around for other solutions but
> none apply, the permissions are fine for that folder.
> seems a fairly common problem too, is there a definitive answer ?
> cheers
> mark
>
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
> Error Number : 29506
> Error Description : MSP Error: 29506 SQL Server Setup failed to
> modify security permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
>
> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
> Error Code: 29506
> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
> permissions on file C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify that
> the account and domain running SQL Server Setup exist, that the account
> running SQL Server Setup has administrator privileges, and that exists on
> the destination drive.
> Error 29506. SQL Server Setup failed to modify security permissions on
> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
> Administrator. To proceed, verify that the account and domain running SQL
> Server Setup exist, that the account running SQL Server Setup has
> administrator privileges, and that exists on the destination drive.
> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
> 0
> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||hi jonh,
ive not checked all the individual files in the directory, the directory
owner is administrator tho ?
is there a easy way to list the acls on the files ? (ive a few to go throo..
:) )
indexing is off and no AV pointing to that directory, so i suspect some file
in the dir
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
> Hi Mark
> Have you checked the acls on the files within the directory?
> Have you excluded database files/directories from any anti-virus software
> being used?
> Have you switched of the indexing service?
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions but
>> none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed to
>> modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running SQL
>> Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback' is
>> 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>|||Hi Mark
There seems to be some issue with Backup exec files (which start with a $)
if you searched google you could find out more, it may be that you only need
to delete these files. For example:
http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
To see the ACLs right click the file and look on the security tab. Using the
advanced options will allow you to take ownerships if necessary which was
one method that stopped the issue.
John
"luna" <luna_s@.themoon.com> wrote in message
news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
> hi jonh,
> ive not checked all the individual files in the directory, the directory
> owner is administrator tho ?
> is there a easy way to list the acls on the files ? (ive a few to go
> throo.. :) )
> indexing is off and no AV pointing to that directory, so i suspect some
> file in the dir
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus software
>> being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed to
>> modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running
>> SQL Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>|||cheers john,
I went throo the files (slow friday :) ) there was a few without
administrator privs, so ive added admin to them
ill give it another go, when the server isn't busy
cheers
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
> Hi Mark
> There seems to be some issue with Backup exec files (which start with a $)
> if you searched google you could find out more, it may be that you only
> need to delete these files. For example:
> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
> To see the ACLs right click the file and look on the security tab. Using
> the advanced options will allow you to take ownerships if necessary which
> was one method that stopped the issue.
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the directory
>> owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and that
>> exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for user
>> Administrator. To proceed, verify that the account and domain running
>> SQL Server Setup exist, that the account running SQL Server Setup has
>> administrator privileges, and that exists on the destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
>> 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>|||That is probably good then! Let us know how it goes!
John
"luna" <luna_s@.themoon.com> wrote in message
news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
> cheers john,
> I went throo the files (slow friday :) ) there was a few without
> administrator privs, so ive added admin to them
> ill give it another go, when the server isn't busy
> cheers
> mark
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>> Hi Mark
>> There seems to be some issue with Backup exec files (which start with a
>> $) if you searched google you could find out more, it may be that you
>> only need to delete these files. For example:
>> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
>> To see the ACLs right click the file and look on the security tab. Using
>> the advanced options will allow you to take ownerships if necessary which
>> was one method that stopped the issue.
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the directory
>> owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions on
>> file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for
>> user Administrator. To proceed, verify that the account and domain
>> running SQL Server Setup exist, that the account running SQL Server
>> Setup has administrator privileges, and that exists on the
>> destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback' is
>> 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value 'DisableRollback'
>> is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>>
>|||hi john,
worked great - sorted it all today, :)
cheers again and happy new year
mark
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:epLt4paSIHA.1204@.TK2MSFTNGP03.phx.gbl...
> That is probably good then! Let us know how it goes!
> John
> "luna" <luna_s@.themoon.com> wrote in message
> news:NG8dj.23854$KC3.23654@.newsfe6-gui.ntli.net...
>> cheers john,
>> I went throo the files (slow friday :) ) there was a few without
>> administrator privs, so ive added admin to them
>> ill give it another go, when the server isn't busy
>> cheers
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:OeKJG9VSIHA.2376@.TK2MSFTNGP02.phx.gbl...
>> Hi Mark
>> There seems to be some issue with Backup exec files (which start with a
>> $) if you searched google you could find out more, it may be that you
>> only need to delete these files. For example:
>> http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/93cd42f8c13621c5/fc225bccf807fe1c?hl=en&lnk=st&q=%22Error%3A+29506%22#fc225bccf807fe1c
>> To see the ACLs right click the file and look on the security tab. Using
>> the advanced options will allow you to take ownerships if necessary
>> which was one method that stopped the issue.
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:D06dj.23803$KC3.6006@.newsfe6-gui.ntli.net...
>> hi jonh,
>> ive not checked all the individual files in the directory, the
>> directory owner is administrator tho ?
>> is there a easy way to list the acls on the files ? (ive a few to go
>> throo.. :) )
>> indexing is off and no AV pointing to that directory, so i suspect some
>> file in the dir
>> mark
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:uRNcdfTSIHA.4128@.TK2MSFTNGP06.phx.gbl...
>> Hi Mark
>> Have you checked the acls on the files within the directory?
>> Have you excluded database files/directories from any anti-virus
>> software being used?
>> Have you switched of the indexing service?
>> John
>> "luna" <luna_s@.themoon.com> wrote in message
>> news:b93dj.28827$yZ4.4945@.newsfe4-gui.ntli.net...
>> having an issue installing sp2, ive looked around for other solutions
>> but none apply, the permissions are fine for that folder.
>> seems a fairly common problem too, is there a definitive answer ?
>> cheers
>> mark
>>
>> Product : Database Services (MSSQLSERVER)
>> Product Version (Previous): 3042
>> Product Version (Final) :
>> Status : Failure
>> Log File : C:\Program Files\Microsoft SQL
>> Server\90\Setup
>> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
>> Error Number : 29506
>> Error Description : MSP Error: 29506 SQL Server Setup failed
>> to modify security permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>>
>> MSI (s) (CC!4C) [08:54:08:674]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:674]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:690]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:690]: Note: 1: 2262 2: Error 3: -2147287038
>> Error Code: 29506
>> MSI (s) (CC!4C) [08:54:08:785]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:785]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Transforming table Error.
>> MSI (s) (CC!4C) [08:54:08:800]: Note: 1: 2262 2: Error 3: -2147287038
>> MSI (s) (CC!4C) [08:54:08:800]: Product: Microsoft SQL Server 2005
>> (64-bit) -- Error 29506. SQL Server Setup failed to modify security
>> permissions on file C:\Program Files\Microsoft SQL
>> Server\MSSQL.1\MSSQL\Data\ for user Administrator. To proceed, verify
>> that the account and domain running SQL Server Setup exist, that the
>> account running SQL Server Setup has administrator privileges, and
>> that exists on the destination drive.
>> Error 29506. SQL Server Setup failed to modify security permissions
>> on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ for
>> user Administrator. To proceed, verify that the account and domain
>> running SQL Server Setup exist, that the account running SQL Server
>> Setup has administrator privileges, and that exists on the
>> destination drive.
>> <EndFunc Name='LaunchFunction' Return='29506' GetLastError='0'>
>> MSI (s) (CC:00) [08:54:08:800]: User policy value 'DisableRollback'
>> is 0
>> MSI (s) (CC:00) [08:54:08:800]: Machine policy value
>> 'DisableRollback' is 0
>> Action ended 08:54:08: InstallFinalize. Return value 3.
>>
>>
>>
>>
>

Monday, March 26, 2012

Problem removing old back up files....

Wednesday, March 21, 2012

Problem opening MSDB folder under Stored Packages

Saturday, February 25, 2012

Problem installing SP2

Problem installing SP2

Problem installing SP2

xp cmdshell

Blog Archive

About Me