Re: sqlserver backup & recovery procedures
From: James (jsmart@ucwphilly.rr.com)
Date: 02/06/03
- Next message: Tom: "DTS fails when scheduled but not when run as a package"
- Previous message: Allan Mitchell: "Re: Access to the MDF file"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "James" <jsmart@ucwphilly.rr.com> Date: Thu, 6 Feb 2003 14:26:04 -0800
One other thing you may want to check is the security of
the database that you moved. Does the SA or any roles
have rights to the new database. This fixed my problem.
The only other thing would be hardcoded statements in any
SP's or USP's that were created with the sa username and
password inserted. Good luck to you.
>-----Original Message-----
>I'm not sure of state 42 - is there any other message to
the error?
>
>The only thing I can think of is that you are restoring
a database and the
>same paths do not exist on the new machine...but that's
not really a
>problem. You can go to the options tab and change the
paths for any/all of
>the files.
>
>As for question 2 - check out this page
>http://www.microsoft.com/sql/downloads/2000/sp3.asp and
specifically this
>text:
>Because SQL Server Service Packs are cumulative, SP3
includes all fixes from
>previously released Service Pack 1 (SP1) and Service
Pack 2 (SP2), and can
>be applied to an original installation or to one where
SP1 or SP2 was
>previously applied.
>
>hth,
>kt
>
>**** Please reply only on the newsgroups! Include
dml/ddl, when possible.
>Thanks ****
>Kimberly L. Tripp
>Principal Mentor, Solid Quality Learning
www.SolidQualityLearning.com
>President, SYSolutions, Inc. www.SQLSkills.com
>
>"thirumaran" <thirumaran@servion.com> wrote in message
>news:03ef01c2c876$09396e10$8ef82ecf@TK2MSFTNGXA04...
>>
>> dear sqlmaster
>>
>> i am new to sqldba
>>
>> [i have 2 questions ]
>>
>> question 1
>> ==========
>> I take backup daily using (sqlserver 2000)sql-
enterprise
>> manager =>select all task=>backup database =>specify
>> filename (backup done).
>> eg(filename => jan30)
>>
>> i copied this file to another system running sqlserver
>> 2000 (same os & ospatch as the system above) .
>> When i try to restore it using sql-enterprise
>> manegr=>restore=>device=>select the file .
>>
>> error:sqlserver odbc state 42...
>>
>> the backup i take is it an cold backup ?
>>
>> how to i take cold back and retore it on diffrent
systems
>> ruuning same windows 2000 server os .
>>
>> question 2
>> ============
>>
>> i have sqlserver 2000 running on windows 2000 server
(sp3)
>> no service packs had been installed for sqlserver 2000.
>> can i directly run sqlserver service pack3 . will it
not
>> affect the db in any way.
>>
>> thanks in advance
>> thirumaran
>
>
>.
>
- Next message: Tom: "DTS fails when scheduled but not when run as a package"
- Previous message: Allan Mitchell: "Re: Access to the MDF file"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
