Cant take Backups

Hi
I have Database in SQL-Server2000 size is 1.37 GB i am tryn to take backup followin are the problems:-
1. Maintainence Plan for Backup Fails for DB
2. Jobs fails for Backup

--> I goto SQL Server Logs Error message is Operating system error 23(Data error (cyclic redundancy check).)

--> Now i am tryin Backup using command :-
Backup Database 'DB1' To Disk ='Path' followin error occurs:-
"Nonrecoverable I/O error occurred on file"

--> Now i am doing back-up directly from Enterprise Manager following error message occurs same error comes

Whats surprising Jobs, maintainence plan, Backup for other database is working perfectly, i checked HDD doesnt have any bad blocks etc. i have even changed path for Backups but still only for these database it gives problem

With Regards

Have you issued a DBCC CHECKDB against the database?

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

Can't start SQL Server 2000

We are trying to move msdb, model and master. We added the -c -m and -T3608
to the startup parameters. When we try to restart SQL fails to start. The
error is that it cannot find master database and will not start. We cannot
get back into Enterprise Manager to reset the startup parameters. How can
we reset the parameters and, more importantly, restart SQL Server?
Thanks very much in advance.First step is to look in SQL Servers errorlog file for the reason why SQL Server won't start.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Moishe Much" <MoisheMuch@.discussions.microsoft.com> wrote in message
news:C69EDED1-03A5-4B92-B5D4-DFE80C2B1A19@.microsoft.com...
> We are trying to move msdb, model and master. We added the -c -m and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We cannot
> get back into Enterprise Manager to reset the startup parameters. How can
> we reset the parameters and, more importantly, restart SQL Server?
> Thanks very much in advance.
>|||> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
The parameters for a default SQL 2000 instance are in the registry under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters
If it SQL Server can't find master at startup, you probably didn't specify
the correct master database path parameter.
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Moishe Much" <MoisheMuch@.discussions.microsoft.com> wrote in message
news:C69EDED1-03A5-4B92-B5D4-DFE80C2B1A19@.microsoft.com...
> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
> Thanks very much in advance.
>

Can't start SQL Server 2000

We are trying to move msdb, model and master. We added the -c -m and -T3608
to the startup parameters. When we try to restart SQL fails to start. The
error is that it cannot find master database and will not start. We cannot
get back into Enterprise Manager to reset the startup parameters. How can
we reset the parameters and, more importantly, restart SQL Server?
Thanks very much in advance.
> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
The parameters for a default SQL 2000 instance are in the registry under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\ MSSQLServer\Parameters
If it SQL Server can't find master at startup, you probably didn't specify
the correct master database path parameter.
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Moishe Much" <MoisheMuch@.discussions.microsoft.com> wrote in message
news:C69EDED1-03A5-4B92-B5D4-DFE80C2B1A19@.microsoft.com...
> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
> Thanks very much in advance.
>
sql

Can't install SQL Express

It fails because it can't find sqlncli.msi. I looked in the temp directory and it was there

Log excerpt:
User policy value 'SearchOrder' is 'nmu'
MSI (s) (B4:A4) [20:53:04:843]: User policy value 'DisableMedia' is 0
MSI (s) (B4:A4) [20:53:04:843]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (B4:A4) [20:53:04:843]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Looking for sourcelist for product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Adding {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Now checking product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Media is enabled for product.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Trying source c:\3a0fb7a85678459f3572f2\setup\.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 2203 2: c:\3a0fb7a85678459f3572f2\setup\sqlncli.msi 3: -2147287037
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Processing net source list.
MSI (s) (B4:A4) [20:53:04:859]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:04:859]: SOURCEMGMT: Processing media source list.
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Trying media source E:\.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 2203 2: E:\sqlncli.msi 3: -2147287038
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Processing URL source list.
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: Note: 1: 1706 2: 3: sqlncli.msi
MSI (s) (B4:A4) [20:53:05:921]: SOURCEMGMT: Failed to resolve source
MSI (s) (B4:A4) [20:54:31:734]: Product: Microsoft SQL Server Native Client -- Error 1706. An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.I found an old post that led me to the solution. The proposed solution was to extract the files from SQLEXPR and install SQLNativeClient by hand and then un-install it. When I ran the .msi file, it found an apparent stealth installed SQLNativeClient (Add/Remove did not show it).

Installation completed

Rusty