473,320 Members | 1,820 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Transfer from 2000 to 7.0 - what can be done?

I have a log file that went out of control (147GB), I feel that doing a shrink on the file/database would be time consuming so I am thinking of recreating the database from an imported version from our test server.

I know that data can flow from one SQL server to another without regard to the SQL server version but can tables, stored procedures and views export from a 2000 database and put back into a 7.0 database?

Thanks

--
Message posted via http://www.sqlmonster.com
Jul 23 '05 #1
4 1131
JD
I would think that you may want to find out why your log file grew the way
it. It is likely to happen again, thereby making it a waste of time to try
and restore from 2000 to 7.0. Is your data no good? If not then why waste
time doing restores?

Do you have a space issue with your hard drives? It may be better to leave
the log file alone. But that could depend on what type of processing your
database is doing?

You can schedule the shrinking of the database for off hours or low usage
time.

Just some thoughts.
"Jeffrey Sheldon via SQLMonster.com" <fo***@SQLMonster.com> wrote in message
news:02******************************@SQLMonster.c om...
I have a log file that went out of control (147GB), I feel that doing a shrink on the file/database would be time consuming so I am thinking of
recreating the database from an imported version from our test server.
I know that data can flow from one SQL server to another without regard to the SQL server version but can tables, stored procedures and views export
from a 2000 database and put back into a 7.0 database?
Thanks

--
Message posted via http://www.sqlmonster.com

Jul 23 '05 #2

"Jeffrey Sheldon via SQLMonster.com" <fo***@SQLMonster.com> wrote in message
news:02******************************@SQLMonster.c om...
I have a log file that went out of control (147GB), I feel that doing a
shrink on the file/database would be time consuming so I am thinking of
recreating the database from an imported version from our test server.

I know that data can flow from one SQL server to another without regard to
the SQL server version but can tables, stored procedures and views export
from a 2000 database and put back into a 7.0 database?

Thanks

--
Message posted via http://www.sqlmonster.com


You can't restore a SQL 2000 backup on a SQL 7 server, so you would have to
recreate all the objects (and remove or rewrite all references to any
2000-only syntax or features), then copy the data with DTS, bcp.exe or
whatever.

It would probably be much easier to work out why your log file is so large,
and just shrink it - if you're concerned about the time required, then you
can do it in several steps and/or scheduled for a quiet time:

http://support.microsoft.com/kb/317375/EN-US/
http://support.microsoft.com/default...&Product=sql2k

Simon
Jul 23 '05 #3
Thanks for the responses. I am trying to avoid the shrink file since there is no way to determine how long it will take a 157GB log file to shrink.

I will look at the links provided. We know why the log file grew and we have put a stop to it. Now it is just time to find to shrink it.

Thanks to all again.

Jeff

--
Message posted via http://www.sqlmonster.com
Jul 23 '05 #4
Jeffrey Sheldon via SQLMonster.com (fo***@SQLMonster.com) writes:
I have a log file that went out of control (147GB), I feel that doing a
shrink on the file/database would be time consuming so I am thinking of
recreating the database from an imported version from our test server.

I know that data can flow from one SQL server to another without regard
to the SQL server version but can tables, stored procedures and views
export from a 2000 database and put back into a 7.0 database?


You would have to script, and it could still fail, if you are using
features that are available on SQL7.

I haven't tried it, but wouldn't a backup of the database, and then restore
into a new one circumvent the problem? Once the copy is up, you can drop
the old database with its 147 GB log.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: BijuThomas | last post by:
Complicated - ASP/Security/data transfer/XML doubt In our company Head office we are hosting an intranet server in IIS (Windows 2000) , ASP and Sqlserver back end. We are maintaining our branch...
1
by: bwalke | last post by:
Hi all, I am fairly new to using triggers and was seeking some help from those that have experience with them. I am looking to transfer data from a SQL 2000 database to a Visual FoxPro database...
5
by: teser3 | last post by:
I would like to transfer an Outlook 2000 Event Calendar information into an Access 2000 database. Please advise if and how I can do this where after something is entered in the Event Calendar it...
0
by: Dr. Zharkov | last post by:
We have program Visual Basic .NET 2003 for construction of 3D-Graphics as a surface z=f (x, y). From VB .NET 2003 we want to transfer coordinates of this surface as myArrayVB (2000, 1) in myArrayVó...
5
by: Paul de Goede | last post by:
I set the Response.Filter in my aspnet application but I have noticed that if you do a Server.Transfer that the filter doesn't get called. And in actual fact the response is mostly empty. It seems...
3
by: Ken Varn | last post by:
I have Page1 that does a transfer to page2. When the user is done with Page2, there is a button on Page2 that they can press to bring them back to Page1. I use Server.Transfer to navigate from...
0
by: mandar | last post by:
Hi all, we have developed and application in which Mobile devices using Win CE talk to SQL server 2000 db. the applicaiton is developed in .net. using webservices i.e soap protocol data...
5
by: barien75 | last post by:
Does anyone know if there is a way to specify the file to transfer from? The files I need are all named the same with one small difference. Each one has the days date at the end of the file name....
0
by: peridian | last post by:
Hi, I have the below code to transfer code modules between Access database files. I have three problems, only one of which is annoying. a) How do you prevent the Save As box from appearing...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.