MSSQL Mistake: files

Showing posts with label files. Show all posts

Monday, March 26, 2012

multi excel files to sql server

I am following the instruction in
http://www.sqldts.com/default.aspx?6,103,246,0,1 to loop thru a directory an
d
get multi excel files to sql.
excel files: same layout, in the same folder and going to the same sql table
I am using the transform data task for excel -> sql step. the problem is
that the package can only process the first file (the initial that I use to
setup the excel connection). The package dies on the 2nd file. I can see the
2nd file being pickup by the loop because the correct file name is in the
excel connection property and the global variable is updated to reference th
e
2nd file as well.
When I goto the transform data task properties and preview source, I get an
error. Error Source: Microsoft JET Database Engine.
Error Description: 'xxx$' is not a valid name. Make sure that it does not
include invalid characters or punctuation and that it is not too long
the file names are not too long. I changed it to be a.xls, b.xls, c.xls etc.
so what's wrong?a bit more info:
I noticed that there were always two selections (2 xxx$) in the transform
data task properties -> table/view dropdown. the one selected by default is
always wrong. I have to select the other one and re-do the transformation
then the whole thing would work again... but only once on one file..... I
would error back here again on the 2nd file...
How can I make the package see the correct file in the table/view dropdown'
"christy" wrote:

> I am following the instruction in
> http://www.sqldts.com/default.aspx?6,103,246,0,1 to loop thru a directory
and
> get multi excel files to sql.
> excel files: same layout, in the same folder and going to the same sql tab
le
> I am using the transform data task for excel -> sql step. the problem is
> that the package can only process the first file (the initial that I use t
o
> setup the excel connection). The package dies on the 2nd file. I can see t
he
> 2nd file being pickup by the loop because the correct file name is in the
> excel connection property and the global variable is updated to reference
the
> 2nd file as well.
> When I goto the transform data task properties and preview source, I get a
n
> error. Error Source: Microsoft JET Database Engine.
> Error Description: 'xxx$' is not a valid name. Make sure that it does not
> include invalid characters or punctuation and that it is not too long
> the file names are not too long. I changed it to be a.xls, b.xls, c.xls et
c.
> so what's wrong?

Multi data files, same drive/FG perf question

Hello. Say you have a SQL 7 database with 1 MDF and 3 NDF
files... all in the same filegroup and drive (and
folder). Beyond the question of WHY it's like that, other
then that's the way thigns were done in that area back in
the 6.5 device days... question...
Since SQL Server will split the data and indexes across
these 4 files evenly, I'd think things would perform
slower then if these were one file. Wouldn't this be a
type of fragmentation since the data/index is not in a
contigous disk area? THanks, BruceThe MDF is the Primary data file and the NDFs are Secondary files. There are
numerous reasons for this type of design. Performance, Securtiy.
1 example might be that you have some lookup tables that are all static, to
ensure nobody is able to change the data you can create a Read-Only data
file. All the lookup tables are then placed on the Read-Only data file
--
HTH
Ryan Waight, MCDBA, MCSE
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:5e2701c37d19$5668d0b0$a601280a@.phx.gbl...
> Hello. Say you have a SQL 7 database with 1 MDF and 3 NDF
> files... all in the same filegroup and drive (and
> folder). Beyond the question of WHY it's like that, other
> then that's the way thigns were done in that area back in
> the 6.5 device days... question...
> Since SQL Server will split the data and indexes across
> these 4 files evenly, I'd think things would perform
> slower then if these were one file. Wouldn't this be a
> type of fragmentation since the data/index is not in a
> contigous disk area? THanks, Bruce|||If the IO subsystem can handle the extra IO, it is possible for things to
run faster... SQL will automatically fire of separate, parallel IO threads
to handle queries, one for each of the data files... Even if you do not get
any performance improvement now, setting up multiple files in a filegroup
will allow you ( at a later time) install a new raid array, backup and
restore ( or sp+_attach) the database into the new raid array and get IO
parallelism...
So this setup could be the result of an *old way* thinker doing things the
6.5 way, OR a forward thinker planning for the future..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:5e2701c37d19$5668d0b0$a601280a@.phx.gbl...
> Hello. Say you have a SQL 7 database with 1 MDF and 3 NDF
> files... all in the same filegroup and drive (and
> folder). Beyond the question of WHY it's like that, other
> then that's the way thigns were done in that area back in
> the 6.5 device days... question...
> Since SQL Server will split the data and indexes across
> these 4 files evenly, I'd think things would perform
> slower then if these were one file. Wouldn't this be a
> type of fragmentation since the data/index is not in a
> contigous disk area? THanks, Bruce

Friday, March 23, 2012

Mulit MDF Files Seperately Restore On SQL Server 2000

Hi there,
I have a question about backup restore. I have setup a database with 5 MDF
file located in different drive.
testdb_data1.MDF
testdb_data2.MDF (in USB drive)
testdb_data3.MDF
testdb_data4.MDF
testdb_data5.MDF
If the MDF file in USB drive fail (say I unplug it and replace with a new
USB drive), is that possible to restore this MDF file only in order to
recover the whole database? I have tried to backup all the MDF files but
fail to restore in this case.
Could anyone give me some hints on this question? Thanks in advance.
KennethAre you backup up the database files from Windows or using SQL Servers BACKUP command?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
> Hi there,
> I have a question about backup restore. I have setup a database with 5 MDF
> file located in different drive.
> testdb_data1.MDF
> testdb_data2.MDF (in USB drive)
> testdb_data3.MDF
> testdb_data4.MDF
> testdb_data5.MDF
> If the MDF file in USB drive fail (say I unplug it and replace with a new
> USB drive), is that possible to restore this MDF file only in order to
> recover the whole database? I have tried to backup all the MDF files but
> fail to restore in this case.
> Could anyone give me some hints on this question? Thanks in advance.
> Kenneth
>|||And are they in same file group? On which version of sql?
"Tibor Karaszi" wrote:
> Are you backup up the database files from Windows or using SQL Servers BACKUP command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
> > Hi there,
> >
> > I have a question about backup restore. I have setup a database with 5 MDF
> > file located in different drive.
> >
> > testdb_data1.MDF
> > testdb_data2.MDF (in USB drive)
> > testdb_data3.MDF
> > testdb_data4.MDF
> > testdb_data5.MDF
> >
> > If the MDF file in USB drive fail (say I unplug it and replace with a new
> > USB drive), is that possible to restore this MDF file only in order to
> > recover the whole database? I have tried to backup all the MDF files but
> > fail to restore in this case.
> >
> > Could anyone give me some hints on this question? Thanks in advance.
> >
> > Kenneth
> >
> >|||In sql2k, you can restore single file with sql backup/restore. But need to do
log restores to keep data integrity.
"Tibor Karaszi" wrote:
> Are you backup up the database files from Windows or using SQL Servers BACKUP command?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Black" <hoodworld@.hotmail.com> wrote in message news:uTvjY90yHHA.484@.TK2MSFTNGP06.phx.gbl...
> > Hi there,
> >
> > I have a question about backup restore. I have setup a database with 5 MDF
> > file located in different drive.
> >
> > testdb_data1.MDF
> > testdb_data2.MDF (in USB drive)
> > testdb_data3.MDF
> > testdb_data4.MDF
> > testdb_data5.MDF
> >
> > If the MDF file in USB drive fail (say I unplug it and replace with a new
> > USB drive), is that possible to restore this MDF file only in order to
> > recover the whole database? I have tried to backup all the MDF files but
> > fail to restore in this case.
> >
> > Could anyone give me some hints on this question? Thanks in advance.
> >
> > Kenneth
> >
> >

Mulit MDF Files Seperately Restore On SQL Server 2000

Friday, March 9, 2012

MSSQL2K5 Install Path

Hi,

How can I make MSSQL2K5 setup install everything in the install path I have
choosen - it keeps installing some files in %SystemRoot% ?

Thanks,

JMJean-Marc Blaise (nobody@.nowhere.com) writes:

Quote:

Originally Posted by

How can I make MSSQL2K5 setup install everything in the install path I
have choosen - it keeps installing some files in %SystemRoot% ?

If you just choose an alternate location at installation time, it's only
a minor part of the files that are relocated. Something like 1.6 GB ends
up on the system disk if you install everything.

If you change the registry value
HKEY_LOCAL_MACHINE/Software/Microsoft/Windows/CurrentVersion/ProgramFilesDir
you can force quite a lot to a second disk.

You still get some files in %SystemRoot%. As I recall, the main bulk of
this ends up in the Installer directory. I think you can change some
registry setting to have the Installer directory elsewhere, but I would
recommend that you think twice before you make this step. On a new
machine it may be less of an issue, but if you already have stuff there,
you may mess up other programs.

SP1 takes an even heavier toll on the Installer directory.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi Erland,

I will try to relocate ProgramFilesDir registry to install MSSQL2K5.

Great thanks for your explanations,

"Erland Sommarskog" <esquel@.sommarskog.sea crit dans le message de
news:Xns982DF0F452EC6Yazorman@.127.0.0.1...

Quote:

Originally Posted by

Jean-Marc Blaise (nobody@.nowhere.com) writes:

Quote:

Originally Posted by

How can I make MSSQL2K5 setup install everything in the install path I
have choosen - it keeps installing some files in %SystemRoot% ?

>
If you just choose an alternate location at installation time, it's only
a minor part of the files that are relocated. Something like 1.6 GB ends
up on the system disk if you install everything.
>
If you change the registry value
>

HKEY_LOCAL_MACHINE/Software/Microsoft/Windows/CurrentVersion/ProgramFilesDir

Quote:

Originally Posted by

you can force quite a lot to a second disk.
>
You still get some files in %SystemRoot%. As I recall, the main bulk of
this ends up in the Installer directory. I think you can change some
registry setting to have the Installer directory elsewhere, but I would
recommend that you think twice before you make this step. On a new
machine it may be less of an issue, but if you already have stuff there,
you may mess up other programs.
>
SP1 takes an even heavier toll on the Installer directory.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||Hi Erland,

The trick to change the registry value of ProgramFilesDir cannot work
because it breaks Outlook Express. In fact in the registries, you find hard
coded Program Files for programs as well as %ProgramFiles%. So I used some
tool to repartition my disk ...

I find the setup pretty uncomprehensible, you don't know exactly despite the
Disk Cost how much you will install in the system drive, and the path you
select. I encountered twice setup problems (abort or willing to report to
microsoft)... Basically, it seems to me I installed about 800 Mb on both
drives, not selecting Analysis Services.

Then, installing SP1 ... took me from the system drive about 1 Gb, but
moreover that annoys me is the time it takes to apply SP1: about 45 minutes.
I am very surprised and disappointed about all these disagrements, and I
find even Oracle has made much progress on there installation gui (using
Oracle 10gR2).

Do you have any comments on my feelings ?

Regards,

Jean-Marc

"Erland Sommarskog" <esquel@.sommarskog.sea crit dans le message de
news:Xns982DF0F452EC6Yazorman@.127.0.0.1...

Quote:

Originally Posted by

Jean-Marc Blaise (nobody@.nowhere.com) writes:

Quote:

Originally Posted by

How can I make MSSQL2K5 setup install everything in the install path I
have choosen - it keeps installing some files in %SystemRoot% ?

HKEY_LOCAL_MACHINE/Software/Microsoft/Windows/CurrentVersion/ProgramFilesDir

Quote:

Originally Posted by

|||Jean-Marc Blaise (nobody@.nowhere.com) writes:

Quote:

Originally Posted by

The trick to change the registry value of ProgramFilesDir cannot work
because it breaks Outlook Express. In fact in the registries, you find
hard coded Program Files for programs as well as %ProgramFiles%. So I
used some tool to repartition my disk ...

Sorry, I forgot to say that I know if it is supported to change
ProgramFilesDir. When I have tried this for SQL 2005 installations, it
has been virtual machines with very little on.

Still, I'm surprised that it would break Outlook Express. My hinch
is that ProgramFilesDir mainly serves as a default for new installations.
Once something has been installed, it should not be affected by
a change in ProgramFilesDir. But I am not in expert on Windows, so I
could be wrong on that point. (And I'm too coward to try the experiment
on my real machine. :-)

Quote:

Originally Posted by

I find the setup pretty uncomprehensible, you don't know exactly despite
the Disk Cost how much you will install in the system drive, and the
path you select. I encountered twice setup problems (abort or willing to
report to microsoft)... Basically, it seems to me I installed about 800
Mb on both drives, not selecting Analysis Services.

I have shoehorned in SQL 2005 on virtual machines with low disk space,
and I don't recall any major mismatch with Disk Cost. But it goes without
saying that if Disk Cost says that you will have one megabyte left, you
should do some cleanup just in case.

Quote:

Originally Posted by

Then, installing SP1 ... took me from the system drive about 1 Gb, but
moreover that annoys me is the time it takes to apply SP1: about 45
minutes. I am very surprised and disappointed about all these
disagrements, and I find even Oracle has made much progress on there
installation gui (using Oracle 10gR2).

Yes, the SP1 takes up too much space on the system disk. It saves a lot
of install packages, but most packages are saved twice. Add to that a
PatchCache. Some of this stuff has to do with roiling back a service
pack, but you cannot roll back SP1.

I have a feeling that the SP1 setup was a bit rashed, because they
wanted to get Database Mirroring out of the door. There are a couple
bugs filed on the SP1 setup (including more than one from yours truly),
and I think several have been resolved as "looking into fix for SP2".

In any case, it is quite clear that if you are of the school that
the system drive should be small, you should re-think, because that is
not Microsoft's approach, but it appears they will continute to cram
things into Windows/Installer, and force thing into ProgramFilesDir.

No problem for the ProgramFilesDir, I just keep posted so that people are
aware of some side effects :-).

Regarding the disk cost, it's confusing, let me tell why: you choose for
example Client Components / and the first sub choice. This gives you about
47 Mb. Then, going to Disk Cost, it says: 467 Mb ! Yeah, about 10 times. I
figure out that this is linked to the temporary files, msi file saved ...
And when you install only this, it seems to install many things: Workstation
Components for instance (at least it sets up some things related to this
area); the setup even tells "Removing applications", and you see your disk
storage decrease...

I know that the installer has some habit to copy twice (sometimes 3 times)
the package: I experimented one time the impossibility to remove anything
from my computer and had to play with registries to get back control of my C
drive. In not so old times, 5 Gb were fine on C: drive, now you should use
at least 20 gb to be safe. Unfortunately, on my labtop, I cannot reformat,
so am unable to install MSSQL2K5, and keep the old MSSQL2K.

Regards,

"Erland Sommarskog" <esquel@.sommarskog.sea crit dans le message de
news:Xns9832D1FC7B328Yazorman@.127.0.0.1...

Quote:

Originally Posted by

Jean-Marc Blaise (nobody@.nowhere.com) writes:

Quote:

Originally Posted by

The trick to change the registry value of ProgramFilesDir cannot work
because it breaks Outlook Express. In fact in the registries, you find
hard coded Program Files for programs as well as %ProgramFiles%. So I
used some tool to repartition my disk ...

>
Sorry, I forgot to say that I know if it is supported to change
ProgramFilesDir. When I have tried this for SQL 2005 installations, it
has been virtual machines with very little on.
>
Still, I'm surprised that it would break Outlook Express. My hinch
is that ProgramFilesDir mainly serves as a default for new installations.
Once something has been installed, it should not be affected by
a change in ProgramFilesDir. But I am not in expert on Windows, so I
could be wrong on that point. (And I'm too coward to try the experiment
on my real machine. :-)
>

Quote:

Originally Posted by

I find the setup pretty uncomprehensible, you don't know exactly despite
the Disk Cost how much you will install in the system drive, and the
path you select. I encountered twice setup problems (abort or willing to
report to microsoft)... Basically, it seems to me I installed about 800
Mb on both drives, not selecting Analysis Services.

>
I have shoehorned in SQL 2005 on virtual machines with low disk space,
and I don't recall any major mismatch with Disk Cost. But it goes without
saying that if Disk Cost says that you will have one megabyte left, you
should do some cleanup just in case.
>

Quote:

Originally Posted by

Then, installing SP1 ... took me from the system drive about 1 Gb, but
moreover that annoys me is the time it takes to apply SP1: about 45
minutes. I am very surprised and disappointed about all these
disagrements, and I find even Oracle has made much progress on there
installation gui (using Oracle 10gR2).

>
Yes, the SP1 takes up too much space on the system disk. It saves a lot
of install packages, but most packages are saved twice. Add to that a
PatchCache. Some of this stuff has to do with roiling back a service
pack, but you cannot roll back SP1.
>
I have a feeling that the SP1 setup was a bit rashed, because they
wanted to get Database Mirroring out of the door. There are a couple
bugs filed on the SP1 setup (including more than one from yours truly),
and I think several have been resolved as "looking into fix for SP2".
>
In any case, it is quite clear that if you are of the school that
the system drive should be small, you should re-think, because that is
not Microsoft's approach, but it appears they will continute to cram
things into Windows/Installer, and force thing into ProgramFilesDir.
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||Jean-Marc Blaise (nobody@.nowhere.com) writes:

Quote:

Originally Posted by

Yeah, that part which says "this compoent requires xx MB on your hard
disk" is about useless. You have to go to Disk Cost to see the actual
effect.

I guess the basic problem is that the cost for a feature depends very
much on which other features you install. For instance, if I go to
Add/Remove Programs, it tells me that Microsoft Visual Studio Team
Suite for Database Professionals - ENU (a.k.a DataDude) takes up 799 MB.
Maybe that would be true, if DataDude was the only Visual Studio thing
I had installed, but it's just an add on, which I have installed
separately. (DataDude is a VS component that is still in beta.)

Quote:

Originally Posted by

In not so old times, 5 Gb were fine on C: drive, now you should use
at least 20 gb to be safe. Unfortunately, on my labtop, I cannot reformat,
so am unable to install MSSQL2K5, and keep the old MSSQL2K.

If unpatitioned disk to spare, keep in mind that you can add a partition
as a mount point, so you could move for instance C:\Windows\Installer
out from the system disk.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

MSSQL2k retrive data from xml

Hello
I have mssql 2k there database and few XML files. I try get data from XML
files and insert into database. How to do that using DTS'
AJAHello AJA,

> I have mssql 2k there database and few XML files. I try get data
> from XML
> files and insert into database. How to do that using DTS'
Here's about a dozen ideas:
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||>> I have mssql 2k there database and few XML files. I try get data
> Here's about a dozen ideas:
> http://www.perfectxml.com/articles/xml/importxmlsql.asp
Yes i watched there and:
OPENXML does not work because to big file 10+MB or maybe anyone have idea
how to prepare_document using text variable? code which i found opened max
1,5MB xml file
Microsoft Visual Basic no have so can no make project using VB
I was intrested to use this one "DTS ActiveX Script & MSXML 4.0 DOM". I
tried, installed MSXML and copied code but it does not work.
Succesfully execution but no records in destination tables.
I have no idea what was wrong :(
Best Regards
AJA|||Hello AJA,
One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
look seriously at SQL Server 2005's SSIS bits. Much better for working with
XML.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||> One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
> look seriously at SQL Server 2005's SSIS bits. Much better for working
> with XML.
The problem is I can no change MSSQL to 2005 because its not my software.
So i'm looking how to solve it in MSSQL 2k.
Best Regards
AJA|||Hello,
Check out SQLXML technology
:http://msdn2.microsoft.com/en-us/library/aa225763(SQL.80).aspx.
I hope this helps.
Regards,
--
Monica Frintu
"AJA" wrote:

> Hello
> I have mssql 2k there database and few XML files. I try get data from XM
L
> files and insert into database. How to do that using DTS'
>
> AJA
>

MSSQL2k retrive data from xml

Hello
I have mssql 2k there database and few XML files. I try get data from XML
files and insert into database. How to do that using DTS?
AJA
Hello AJA,

> I have mssql 2k there database and few XML files. I try get data
> from XML
> files and insert into database. How to do that using DTS?
Here's about a dozen ideas:
http://www.perfectxml.com/articles/xml/importxmlsql.asp
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||>> I have mssql 2k there database and few XML files. I try get data
> Here's about a dozen ideas:
> http://www.perfectxml.com/articles/xml/importxmlsql.asp
Yes i watched there and:
OPENXML does not work because to big file 10+MB or maybe anyone have idea
how to prepare_document using text variable? code which i found opened max
1,5MB xml file
Microsoft Visual Basic no have so can no make project using VB
I was intrested to use this one "DTS ActiveX Script & MSXML 4.0 DOM". I
tried, installed MSXML and copied code but it does not work.
Succesfully execution but no records in destination tables.
I have no idea what was wrong

Best Regards
AJA
|||Hello AJA,
One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
look seriously at SQL Server 2005's SSIS bits. Much better for working with
XML.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/
|||> One thing that I'll suggest is that you get off of SQL Server 2000 DTS and
> look seriously at SQL Server 2005's SSIS bits. Much better for working
> with XML.
The problem is I can no change MSSQL to 2005 because its not my software.
So i'm looking how to solve it in MSSQL 2k.
Best Regards
AJA
|||Hello,
Check out SQLXML technology
:http://msdn2.microsoft.com/en-us/library/aa225763(SQL.80).aspx.
I hope this helps.
Regards,
Monica Frintu
"AJA" wrote:

> Hello
> I have mssql 2k there database and few XML files. I try get data from XML
> files and insert into database. How to do that using DTS?
>
> AJA
>

Wednesday, March 7, 2012

mssql2005

how do I bring files from mssql2000 to mssql2005? A BAK from 2000 doesnt
seem to work as it did in mssql97 & 2000
thanks,
Raul Rego
NJPIES> A BAK from 2000 doesnt seem to work as it did in mssql97 & 2000
It should do. You can both restore a 2000 backup into 2005 and also attach a
2000 database (mdf etc
files) into 2005. What error message do you get?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"news.microsoft.com" <jjkgr@.hotmail.com> wrote in message
news:u0s8ppDzGHA.4232@.TK2MSFTNGP04.phx.gbl...
> how do I bring files from mssql2000 to mssql2005? A BAK from 2000 doesnt
seem to work as it did
> in mssql97 & 2000
> thanks,
> Raul Rego
> NJPIES
>

mssql2005

how do I bring files from mssql2000 to mssql2005? A BAK from 2000 doesnt
seem to work as it did in mssql97 & 2000
thanks,
Raul Rego
NJPIES> A BAK from 2000 doesnt seem to work as it did in mssql97 & 2000
It should do. You can both restore a 2000 backup into 2005 and also attach a 2000 database (mdf etc
files) into 2005. What error message do you get?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"news.microsoft.com" <jjkgr@.hotmail.com> wrote in message
news:u0s8ppDzGHA.4232@.TK2MSFTNGP04.phx.gbl...
> how do I bring files from mssql2000 to mssql2005? A BAK from 2000 doesnt seem to work as it did
> in mssql97 & 2000
> thanks,
> Raul Rego
> NJPIES
>

MSSQL.3

On one server the report services folder exists here;
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer
On another server it exists here;
C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting
Services\ReportServer
Why MSSQL.3 on one and MSSQL.4 on the other?
Thanx in advance ,
GregOn Aug 29, 11:32 am, "SurferJoe" <Surfer...@.newsgroup.nospam> wrote:
> On one server the report services folder exists here;
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportServer
> On another server it exists here;
> C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting
> Services\ReportServer
> Why MSSQL.3 on one and MSSQL.4 on the other?
> Thanx in advance ,
> Greg
This is common when you have a different number of SQL Server Services
installed (i.e., if you have the SQL Server Database Engine,
Integration Services and Reporting Services installed on one server,
SSRS might be in MSSQL.3; whereas, if you have the SQL Server Database
Engine, Integration Services, Analysis Services and Reporting Services
installed on the other server, SSRS might be in MSSQL.4). Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Saturday, February 25, 2012

MSSQL Server Recovery

Hi,
The Windows 2000 Server (that has MSSQL Server installed) is corrupted.
Can anybody tell me how I can make the existing SQL data files work in
another Windows 2000 Server?
What should I do?
Thanks & Regards,
KSHi KS !
You've got the data and log file ?
I've got the german EM, so don't know the exact names
of the menu items in english version of EM, but i'll try.
On your new SQL-Server EM:
Right-Click on Databases -> All Tasks -> Attach DB
then choose your mdf-file, and that's it. (Hope so!)
Hope these instructions help.
Let me know about it.
Best regards,|||Can you give us some indication on the status of your
server i.e. is it accessable.
Can you also give us some indication of your backups and
any replication.
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan
>--Original Message--
>Hi,
>The Windows 2000 Server (that has MSSQL Server
installed) is corrupted.
>Can anybody tell me how I can make the existing SQL data
files work in
>another Windows 2000 Server?
>What should I do?
>Thanks & Regards,
>KS
>
>.
>|||Smuddi wrote:
> Hi KS !
> You've got the data and log file ?
> I've got the german EM, so don't know the exact names
> of the menu items in english version of EM, but i'll try.
> On your new SQL-Server EM:
> Right-Click on Databases -> All Tasks -> Attach DB
> then choose your mdf-file, and that's it. (Hope so!)
> Hope these instructions help.
> Let me know about it.
> Best regards,
hi,
That's ok but you'll still have orfan users. Drop and create database users
again!
regards,
Zarko|||Hello KS
Assuming you have all database files (including system databases - master,
msdb), you should follow the steps below :
1. Install SQL Server to the same location on the second server (as your
old server)
2. Apply the same service pack and/or hotfix that you had on your old
server.
3. Stop SQL Server services and replace all database files with the ones
that you had from your old server.
Remember the above step may not work correctly if you do not have the
system database file level backups. If this condition was a result of file
system corruption and the database files were copied after the corruption,
its possible that they may be corrupted too. So the above steps may not
work.
If you only have the user database files, follow the step in the article
below :
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
There is also a section in the above article regarding recovering orphaned
logins.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi,
Due to I cannot log into Windows 2000 Server (installed by
ex-administrator),
I need to install a new Windows 2000 Server.
And transfer the existing data files to the new machine.
Regards,
KS
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:136701c48c22$49618100$a501280a@.phx.gbl...
> Can you give us some indication on the status of your
> server i.e. is it accessable.
> Can you also give us some indication of your backups and
> any replication.
> Peter
> "It's true hard work never killed anybody, but I figure,
> why take the chance?"
> Ronald Reagan
>
> >--Original Message--
> >Hi,
> >
> >The Windows 2000 Server (that has MSSQL Server
> installed) is corrupted.
> >
> >Can anybody tell me how I can make the existing SQL data
> files work in
> >another Windows 2000 Server?
> >
> >What should I do?
> >
> >Thanks & Regards,
> >KS
> >
> >
> >.
> >

Monday, February 20, 2012

MS-SQL one .NDF file missing How to Recover/Rebuild DB?

Dear All,
SOS Please Help.
I have a MS-SQL DB with 4 .ndf files. One (first) .ndf file is missing.
somehow got deleted??. Is there any way can rebuild my DB.

The .MDF and .LDF files are in tact.
Please help asap.

Dhumbak

*** Sent via Developersdex http://www.developersdex.com ***It depends what this NDF was created for in the first place. If it was
storing indexes then you can rebuild these indexes. If it was data and
you have no backup on the filegroup then you probably lost your data in
loosing the NDF.

Dhungu Dhumbak wrote:

Quote:

Originally Posted by

Dear All,
SOS Please Help.
I have a MS-SQL DB with 4 .ndf files. One (first) .ndf file is missing.
somehow got deleted??. Is there any way can rebuild my DB.
>
The .MDF and .LDF files are in tact.
Please help asap.
>
Dhumbak
>
*** Sent via Developersdex http://www.developersdex.com ***

Monday, March 26, 2012

multi excel files to sql server

Multi data files, same drive/FG perf question

Friday, March 23, 2012

Mulit MDF Files Seperately Restore On SQL Server 2000

Mulit MDF Files Seperately Restore On SQL Server 2000

Mulit MDF Files Seperately Restore On SQL Server 2000

Friday, March 9, 2012

MSSQL2K5 Install Path

MSSQL2k retrive data from xml

MSSQL2k retrive data from xml

Wednesday, March 7, 2012

mssql2005

mssql2005

MSSQL.3

Saturday, February 25, 2012

MSSQL Server Recovery

MSSQL Server Recovery

MSSQL Server Recovery

Monday, February 20, 2012

MS-SQL one .NDF file missing How to Recover/Rebuild DB?

MSSQL Mistake

Blog Archive

About Me