Official document about restoring SQL Server 2000 logs to SQL 2K5

Hello,

I am trying to get a document, a technote or something, telling officially 
that the transactional logs of a SQL Server 2000 SP3 can be restored to a SQL 
Server 2005 SP3 database.

Did you see anything like that ? 

Thanks in advance,
Regards,

Vincent
0
Utf
3/22/2010 2:43:01 PM
sqlserver.server 1327 articles. 0 followers. Follow

4 Replies
574 Views

Similar Articles

[PageSpeed] 17

Hi
You can restore database backed up on SQL Server 2000 and restore on SQL 
Server 2005/2008

Are  you trying to log ship between SQL2K and SQL2005?


"Vincent D." <VincentD@discussions.microsoft.com> wrote in message 
news:197AF810-0295-442C-AB8F-794957C6869D@microsoft.com...
> Hello,
>
> I am trying to get a document, a technote or something, telling officially
> that the transactional logs of a SQL Server 2000 SP3 can be restored to a 
> SQL
> Server 2005 SP3 database.
>
> Did you see anything like that ?
>
> Thanks in advance,
> Regards,
>
> Vincent 


0
Uri
3/22/2010 2:50:35 PM
No can do (log backup, that is). Only database backup can be restore from 
lower to higher version.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Vincent D." <VincentD@discussions.microsoft.com> wrote in message 
news:197AF810-0295-442C-AB8F-794957C6869D@microsoft.com...
> Hello,
>
> I am trying to get a document, a technote or something, telling officially
> that the transactional logs of a SQL Server 2000 SP3 can be restored to a 
> SQL
> Server 2005 SP3 database.
>
> Did you see anything like that ?
>
> Thanks in advance,
> Regards,
>
> Vincent 

0
Tibor
3/22/2010 3:48:23 PM
Hi Uri,

Thanks for your answer.
In fact, I know that I can restore, I did a proof of concept, but my boss is 
looking for an official document that say it is supported by MS...
So if you saw something on MSDN... 

Regards,
Vincent

"Uri Dimant" wrote:

> Hi
> You can restore database backed up on SQL Server 2000 and restore on SQL 
> Server 2005/2008
> 
> Are  you trying to log ship between SQL2K and SQL2005?
> 
> 
> "Vincent D." <VincentD@discussions.microsoft.com> wrote in message 
> news:197AF810-0295-442C-AB8F-794957C6869D@microsoft.com...
> > Hello,
> >
> > I am trying to get a document, a technote or something, telling officially
> > that the transactional logs of a SQL Server 2000 SP3 can be restored to a 
> > SQL
> > Server 2005 SP3 database.
> >
> > Did you see anything like that ?
> >
> > Thanks in advance,
> > Regards,
> >
> > Vincent 
> 
> 
> .
> 
0
Utf
3/22/2010 3:51:01 PM
Just a side note. 

You may want to highlight to your boss the current status of the SQL2000 
life cycle as mainstream support ended quite some time ago:

http://support.microsoft.com/lifecycle/?p1=2852


Jon


"Vincent D." wrote:

> Hi Uri,
> 
> Thanks for your answer.
> In fact, I know that I can restore, I did a proof of concept, but my boss is 
> looking for an official document that say it is supported by MS...
> So if you saw something on MSDN... 
> 
> Regards,
> Vincent
> 
> "Uri Dimant" wrote:
> 
> > Hi
> > You can restore database backed up on SQL Server 2000 and restore on SQL 
> > Server 2005/2008
> > 
> > Are  you trying to log ship between SQL2K and SQL2005?
> > 
> > 
> > "Vincent D." <VincentD@discussions.microsoft.com> wrote in message 
> > news:197AF810-0295-442C-AB8F-794957C6869D@microsoft.com...
> > > Hello,
> > >
> > > I am trying to get a document, a technote or something, telling officially
> > > that the transactional logs of a SQL Server 2000 SP3 can be restored to a 
> > > SQL
> > > Server 2005 SP3 database.
> > >
> > > Did you see anything like that ?
> > >
> > > Thanks in advance,
> > > Regards,
> > >
> > > Vincent 
> > 
> > 
> > .
> > 
0
Utf
3/23/2010 10:50:01 AM
Reply:

Similar Artilces:

Exchange & SMTP Logs
Hello, I am fairly new at Exchange 2003, I have a strong un*x background and have been using sendmail for quite sometime. I was wondering about log files with exchange. I have enabled SMTP logging which shows SMTP connections, where do I find the log that shows why an email has been rejected? Thanks! Chris c:\windows\system32\logfiles\ -- Thanks, Brian Desmond Windows Server MVP www.briandesmond.com "Chris Edwards" <chris@buythetruck.com> wrote in message news:Oh$LtTsSGHA.2088@TK2MSFTNGP14.phx.gbl... > Hello, > > I am fairly new at Exchange 2003, I ha...

Moving public folders on Exchange 5.5 to a new server in the same site.
All, I have 2 exchange 5.5 servers in the same site. I'm going to shut the orignal one down soon. What is the best way to move the public folders over to the public store on the new server? -- FastEddie Rockwell ---------------------------------- Check us out at: www.therockwells.net ----------------------------------- "Fast Eddie" <fasteddie@therockwells.net.no.spam.com> wrote in news:#1VO4cH$DHA.4072@tk2msftngp13.phx.gbl: > I have 2 exchange 5.5 servers in the same site. I'm going to shut the > orignal one down soon. What is the best way to move the publ...

Can I convert an Outlook 2000 PST to Outlook 2003
We have upgraded from Outlook 2000 to Outlook 2003. Is there a fast way to convert my old PST files to Outlook 2003 so that they are not limited to 2 GB size? I don't want to have to go through all of the folders on 30 computers and drag one folder at a time from the old file to the new file. Thanks, Joe I have had pretty good luck importing. Of course, when you import, you = will no longer have access to any custom forms, views, or Rules Wizard = rules.=20 --=20 Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.h...

tvdebug.log
how to delete the windows tvdebug.log? it keeps growing daily and is up to 753mb. WinXP Pro SP3 Herman R Standiford wrote: > how to delete the windows tvdebug.log? it keeps growing daily and > is up to 753mb. WinXP Pro SP3 That's not a Windows file. Uninstall ZoneAlarm and utilize the built-in Windows XP Firewall. Your computer will likely be faster, you'll be just as protected from outside dangers and you won't have these bizarre issues. -- Shenan Stanley MS-MVP -- How To Ask Questions The Smart Way http://www.catb.org/~esr/faqs/smart-q...

Simple XML Log
I want to receive an XML document via an aspx page and log the raw xml to a text file. I've been looking at this for a while and can't work out how to do it. Can someone tell me how to grab the raw xml text (once I've got the text I can do the logging bit) Thanks HHoulston wrote: > I want to receive an XML document via an aspx page and log the raw > xml to a text file. I've been looking at this for a while and can't > work out how to do it. Can someone tell me how to grab the raw xml > text (once I've got the text I can do the logging bit)? Assumin...

Exchange 2000/2003 Routing Problems
I recently added a new Exchange 2003 server to our 1 server Exchange 2000 org. I am able to send mail from the new Exchange 2003 server to the 2000 server. But when I send to the 2003 server the mail does not go delivered. I am assuming this is a routing issue. How can I troubleshoot this? Should each server be in a seperate routing group and use a routing group connector? They are currently i n the same routing group. Thanks, Forest In case anyone has this problem my STMP connector was setup to use a smart relay. I had to check the box that said attempt local delivery before using...

How can comments be inserted into a document ?
Can comments be inserted into a documents done in Publisher? If so, how? No..not automatically. You should be using Word. There is always the callouts in Autoshapes. -- Mary Sauer http://msauer.mvps.org/ "Susan" <Susan@discussions.microsoft.com> wrote in message news:E9195C75-EB38-45A2-ABA4-879C86988A9C@microsoft.com... > Can comments be inserted into a documents done in Publisher? If so, how? ...

Append to MS SQL 2005 table
I'm getting a key violation error whenever I try and append records from a table in Access to a table on a MS SQL 2005 database. The SQL db's table has an IID field which is the primary key for the table (and the only indexed field in the table) and I am NOT trying to append records to the IID field with my INSERT INTO tImport(...) statement. It is a clustered index if that makes any difference. Since I can't seem to add the table and write to it without an index field, does anyone have any ideas why I am getting the error message Is the IID field an Identity/Autonumber t...

Outlook 2000 Calendar Find won't work
When I try to use the "Find" command in Outlook 2000 Calendar I get a quick list of results then the screen clears to the "no items found" message. The "Find" command works in all other personal folders. Any idea what the problem is? ...

User's Mailboxes on same server and domain as CRM
Has anyone found a work around to the limitation that the CRM Exchange Router will only route mail from accounts that do not reside in your domain? In other words, if I use CRM as a helpdesk tool to support employees with in my organization, they can not send mail to helpdesk@mydomain.com and have that message routed to a queue w/ in CRM named helpdesk w/ the email address of helpdesk@mydomain.com -- Chris Meredith I am also interested as we would also like to use CRM as a helpdesk tool to support our employees. Darrell "Chris Meredith, CIO" <chris.meredith@allnettek.co...

how do I set up publisher 2000 to print business cards 10 per pag.
I can only get 4 on a page. When you are ready to print, in the print dialog, you will be able to change the page properties. Click page options, custom options, change the side margin to .75, change the top margin to .5, change the gaps to zero. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "yvette" <yvette@discussions.microsoft.com> wrote in message news:6D4E614E-3F33-456D-B7D9-E1A8CD452C13@microsoft.com... >I can only get 4 on a page. Here's I do it with Publisher 2000. File Page Setup Special Si...

SQL 2005 and CRM 3.0
Hi all Just want to know if it is possible to install MSCRM 3.0 on one server and use a SQL 2005 server that is a standalone server is not part of the CRM AD domain. Is that possible and if so how does one configure it. No, the SQL server simply must be in same AD domain as the CRM server "chodeva" <chodeva@gmail.com> wrote in message news:1182438284.428768.197020@k79g2000hse.googlegroups.com... > Hi all > > Just want to know if it is possible to install MSCRM 3.0 on one server > and use a SQL 2005 server that is a standalone server is not part of > the CRM ...

Outlook 2000 Error 550 Sender verify failed
Hello all We have one machine on our network that cannot send mail for some reason. Everytime this machine attempts to send mail using Outlook 2000 it fails, reporting the following error: "The message could not be sent because one of the recipients was rejected by the server. Server response: '550 Sender verify failed'. (Account: 'Fred', smtp server: 'relay.clara.net', error number: 0x8000ccc79)." It is not a simple matter of setting the authentication on the outgoing mail server, as all the other machines on the network (also using Outlook 2000) do...

publish chart to IIS Server
Right now i can publish my report to an interactive htm file. How do I publish it to say an IIS Server ? ...

Documentation about CRM 1.2 db structure
Does exist any documentation about CRM 1.2 modules and related underlying SQL tables? Does exist any documentation about mapping between CRM 1.2 SQL tables and CRM 3.0 SQL tables? Many thanks If you install data migration tool, there are some excel spreadsheet contains the fields for the given entity. I don't know if that's what you are looking for. In terms of the SQL table, CRM 1.2 and CRM 3.0 is similar. All the custom attribute will be in the extension table. E.g. AccountBase, AccountExtension. Hope this helps. Darren Liu Crowe Chizek and Company http://www.crowecrm.com On ...

SQL for list manipulation (a mess)
Hello, I have a set of queries which have taken on a life of their own! I don't believe there's room here for all the SQLs (nor would I wish that on anyone) but there has to be a simplier way to do this. I have a form (zfmMain) which has a listbox (lstEMainE), a toggle (tglECInactive) and subform (subfmMainE) with a listbox (lstECsubEc) with 8 or 9 columns dependeng on the selection in lstEMainE (specific Engagement or "*" - All), three toggles (tglECOpen, tglECHold, tglECClosed) and 8/9 label column headings (lblEC1…lblEC9). In VBA on the Click Event fo...

Outlook 2000 leaves messages in outbox when sent
I have a user with Windows XP Pro SP3, and Office 2000 Pro. Both are fully updated, including Office 2000 SP3. For some reason, whenever she sends a message in her Outlook, it shows TWO messages in the outbox for each one she's sending, and leaves one of them behind, empty except for the recipient information. Any suggestions on how to fix this? "Detect and Repair" doesn't work because it says it can't find a source for Office 2000 SP1 (which is apparently the original installation.) I realize that Office 2000 is no longer even supported under the "extended" /...

Two Domains
Due to a company merger we have two Active Directory forests and one Exchange 2003 server - the problem is that I can not share a mail box or contact list between users. I get an access denied if I try to share the mail box with an other user. When I try and trust the two ADs I get errors on the RPC server? The staff logon to SYSTEM A and the mail server is on SYSTEM B - both systems have the same staff IDs and LOGIN information. =?Utf-8?B?Sm9lIEI=?= <Joe B@discussions.microsoft.com> wrote in news:1DC34E1C-6D90-49B2-BC06-44FDC4B2BABC@microsoft.com: > Due to a company merger...

Server Busy
Hi, I have some problem which completely I don't have idea what is that. When I try to open Nero program I'm getting message: '[image: http://img59.imageshack.us/img59/9379/4444444444444444444u.jpg]' (http://img59.imageshack.us/i/4444444444444444444u.jpg/) Can someone tell me what is problem and how to avoid it ? I press Switch to .... or Retry and nothing change. -- zungul Try NERO Support http://www.nero.com/enu/support.html Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist Small...

Exchange Server Public Calendar & iPhone
We have an exchange server at work. I can view my personal calendars on my iPhone. Is there anyway to view the public calendar on my iPhone also? Thanks for any help! "Elizabeth Reynolds" <ElizabethReynolds@discussions.microsoft.com> wrote in message news:9997D826-9CAD-4A07-91C5-18889EC1FF46@microsoft.com... > We have an exchange server at work. I can view my personal calendars on my > iPhone. Is there anyway to view the public calendar on my iPhone also? Ask the question in an iPhone forum. This one deals with neither Exchange nor iPhones, on...

Audit log for 1 field
Hi. I am trying to create an audit log for a "tasks" database.I used Allen Browne's code and got it working on a very simple test database. When I try to do the exact thing in my production database, it gets stuck at: 'Remove any cancelled update still in the tmp table. Set db = DBEngine(0)(0) sSQL = "DELETE FROM " & sAudTmpTable & ";" db.Execute sSQL My production form has alot on it (combo lookups, date pickers, option groups, and some code behind some text boxes, etc). Would this affect it? I'm really only intereste...

Outlook Client "Problem communicating with CRM Server...
I have installed the light Desktop Outlook Client on a notebook. Everything works fine after the installation. Now the user wants a notebook client with local MSDE - so I�ve deinstalled the light client an installed the notebook client. I specifed the URL (not the IP) for the CRM server during the client installation. When I launch Outlook now I get the following error - "There is a problem communicating with the Microsoft CRM server. The server might be unavailable. Try again later. If the problem persists, contact your system administrator." Then it tells me that it cannot lo...

Install new Country/Region client for GP10 on terminal server
I have a 2008 Terminal Server with a US GP10 client installed. I need to install the UK&Ireland Client for our UK office. I created an installer package from the Feature Pack 1 DVD with the installation pointing to c:\Program Files (x86)\Microsoft Dynamics\GP$UK and using the UK language setting. When I run the installer it acts like it's installing but when finished, nothing has been installed. I do have to run utilities before I can log in to the US client. What am I missing? Thanks, DavidF. When you say "nothing has been installed", do you mean there are no file...

Unknow Error during restore
I am trying to restore the data from one system to another. When I attempt the restore it seems as if everything is going fine until I get a unknown error and the data is not updated. Please help. First, what data are you restoring? Dynamics? Company Databases? Transaction Logs? Second, on the target system, was Dyanics GP already installed? -- Richard L. Whaley Author / Consultant / MVP Documentation for Software Users For help learning and better using Dynamics GP,... check out our books at http://www.AccoladePublications.com "Lisa" wrote: > I am trying to restor...

Display after reinstallation
Good evening, SAfter re installation on Win 2000 which has gone ok, the portfolio page only displays on half of the page for some reason. There are no handles or grips to pull down or resize. The other pages are all ok from what I can see. Any ideas guys/ gals on how to correct this? Thanks in advance ...