473,387 Members | 1,464 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,387 software developers and data experts.

sql data recovery?

crs
To the point....

My company received a disc containing our last year's database
information from the online company that we use for our documentation(
They use SQL ). Only thing is, we are a small business and do not have
a "server", therefore we do not have sql server, therefore we can't get
our documentation off of the disc. The thing is, we're being
accredited next week and I need this information for accreditation
purposes. I need to know if there is another option to retrieve this
information without purchasing Microsoft Server and SQL Server.

any advice / help would be much appreciated.

CRS

Dec 1 '06 #1
6 1491
What files are on the CD? Are you sure they are SQL Server files?

SQL Express is a free version of SQL Server 2005. It has limits, but
there is a good chance your need for a database server falls within
them. It can be downloaded from the Microsoft web site. Include the
SQL Server Express Toolkit if you try this.

You may still have serious issues with getting AT your data - this is
a database, not a front end application - but it is a step.

Roy Harvey
Beacon Falls, CT

On 1 Dec 2006 11:55:17 -0800, "crs" <cl***********@gmail.comwrote:
>To the point....

My company received a disc containing our last year's database
information from the online company that we use for our documentation(
They use SQL ). Only thing is, we are a small business and do not have
a "server", therefore we do not have sql server, therefore we can't get
our documentation off of the disc. The thing is, we're being
accredited next week and I need this information for accreditation
purposes. I need to know if there is another option to retrieve this
information without purchasing Microsoft Server and SQL Server.

any advice / help would be much appreciated.

CRS
Dec 1 '06 #2
crs
Thanks for the quick reply.

the only thing on the disc is one .bak file

Roy Harvey wrote:
What files are on the CD? Are you sure they are SQL Server files?

SQL Express is a free version of SQL Server 2005. It has limits, but
there is a good chance your need for a database server falls within
them. It can be downloaded from the Microsoft web site. Include the
SQL Server Express Toolkit if you try this.

You may still have serious issues with getting AT your data - this is
a database, not a front end application - but it is a step.

Roy Harvey
Beacon Falls, CT

On 1 Dec 2006 11:55:17 -0800, "crs" <cl***********@gmail.comwrote:
To the point....

My company received a disc containing our last year's database
information from the online company that we use for our documentation(
They use SQL ). Only thing is, we are a small business and do not have
a "server", therefore we do not have sql server, therefore we can't get
our documentation off of the disc. The thing is, we're being
accredited next week and I need this information for accreditation
purposes. I need to know if there is another option to retrieve this
information without purchasing Microsoft Server and SQL Server.

any advice / help would be much appreciated.

CRS
Dec 1 '06 #3
On 1 Dec 2006 12:41:12 -0800, "crs" <cl***********@gmail.comwrote:
>Thanks for the quick reply.

the only thing on the disc is one .bak file
So once you have SQL Server running, you will have to use the RESTORE
command.

Roy
Dec 1 '06 #4

"Roy Harvey" <ro********@snet.netwrote in message
news:g0********************************@4ax.com...
On 1 Dec 2006 12:41:12 -0800, "crs" <cl***********@gmail.comwrote:
>>Thanks for the quick reply.

the only thing on the disc is one .bak file

So once you have SQL Server running, you will have to use the RESTORE
command.
Note if the DB is over 4GB in size SQL Express won't work.

But it's possible you may be able to use a 120 day trial version if you just
need to get the data out once and that's it.

Roy

Dec 2 '06 #5
crs
But it's possible you may be able to use a 120 day trial version if you just
need to get the data out once and that's it.

Roy
Thanks for the trial idea, worked like a charm. I was able to beat my
deadline by 4 hours.
Thanks!

Dec 6 '06 #6

"crs" <cl***********@gmail.comwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...
>But it's possible you may be able to use a 120 day trial version if you
just
need to get the data out once and that's it.

Roy

Thanks for the trial idea, worked like a charm. I was able to beat my
deadline by 4 hours.

See... that's 4 hours now you can spend with pizza, beer and some wings!

Thanks!

Dec 7 '06 #7

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

Similar topics

3
by: Alfred Wallace | last post by:
I work on a debian server. with apache doocroot: /home/web. unfortunatly, the other admin creates a user with /home/web default directory, and then deletes the user... /home/web doesn't exists...
0
by: Author Tarun Tyagi | last post by:
Hi! I am glad to introduce World's First Book on Professional Data Recovery Programming. Book also Includes a FREE CD, which contains complete Source Codes of all the software/Programs described...
1
by: Author Tarun Tyagi | last post by:
Hi! I am glad to introduce World's First Book on Professional Data Recovery Programming. Book also Includes a FREE CD, which contains complete Source Codes of all the software/Programs described...
0
by: Author Tarun Tyagi | last post by:
Hi, I am a Data Recovery Specialist and Professional Data Recovery Software Developer in New Delhi. I've placed the Complete SOURCE CODE of One of my Data Recovery Software for Sale (for...
10
by: xixi | last post by:
i have db2 udb v8.1 on windows 64 bit 2003 server, after db2 server start , i found this in the db2diag.log, is this error? 2004-05-05-15.28.30.780000 Instance:DB2 Node:000...
0
by: Author Tarun Tyagi | last post by:
Hi! I am glad to introduce World's First Book on Professional Data Recovery Programming. Book also Includes a FREE CD, which contains complete Source Codes of all the software/Programs described...
1
by: Author Tarun Tyagi | last post by:
Hi! I am glad to introduce World's First Book on Professional Data Recovery Programming. Book also Includes a FREE CD, which contains complete Source Codes of all the software/Programs described...
0
by: Winder | last post by:
Computer Data Recovery Help 24/7 Data recovering tools and services is our focus. We will recover your data in a cost effective and efficient manner. We recover all operating systems and media....
5
by: Roger | last post by:
backup log testdb with truncate_only DBCC SHRINKFILE (testdb_log, 100) WITH NO_INFOMSGS backup database testdb to disk = '\\DC01\Backups\DB01\testdb.bak' with init and does the shrinkfile...
1
by: =?Utf-8?B?UkIncw==?= | last post by:
My eMachine when boot up, will ask "Press F11 for recovery". I just leave it and it will boot to WinXP. this eMachine just died. I hooked up its HD as slave to other computer, try to move my own...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.