Wednesday, March 7, 2012
Operating System Upgrade
We are running SQL Server 7 on NT Server.
I am responsible for an upgrade path which will migrate to Windows 2000 Server and SQL Server 2000.
The upgrade will take place in steps with the operating system done first.
Is there any documentation describing the recommended methodology for performing such an upgrade ?
Are there any known problems to watch out for ?
I know theses are general questions but I would rather be aware of best prctices or potential problems before I start.
Any help gratefully received,
Den.
Have a look at
http://www.sqlteam.com/item.asp?ItemID=9066
http://www.sqlteam.com/item.asp?ItemID=9465
Query plans will change so some SQL may go faster others slower.
Paul
"Den" <anonymous@.discussions.microsoft.com> wrote in message
news:4CB242DE-4818-4E1E-AC3C-21D962AADDDC@.microsoft.com...
> Hi,
> We are running SQL Server 7 on NT Server.
> I am responsible for an upgrade path which will migrate to Windows 2000
Server and SQL Server 2000.
> The upgrade will take place in steps with the operating system done first.
> Is there any documentation describing the recommended methodology for
performing such an upgrade ?
> Are there any known problems to watch out for ?
> I know theses are general questions but I would rather be aware of best
prctices or potential problems before I start.
> Any help gratefully received,
> Den.
Operating System Upgrade
We are running SQL Server 7 on NT Server.
I am responsible for an upgrade path which will migrate to Windows 2000 Serv
er and SQL Server 2000.
The upgrade will take place in steps with the operating system done first.
Is there any documentation describing the recommended methodology for perfor
ming such an upgrade ?
Are there any known problems to watch out for ?
I know theses are general questions but I would rather be aware of best prct
ices or potential problems before I start.
Any help gratefully received,
Den.Have a look at
http://www.sqlteam.com/item.asp?ItemID=9066
http://www.sqlteam.com/item.asp?ItemID=9465
Query plans will change so some SQL may go faster others slower.
Paul
"Den" <anonymous@.discussions.microsoft.com> wrote in message
news:4CB242DE-4818-4E1E-AC3C-21D962AADDDC@.microsoft.com...
> Hi,
> We are running SQL Server 7 on NT Server.
> I am responsible for an upgrade path which will migrate to Windows 2000
Server and SQL Server 2000.
> The upgrade will take place in steps with the operating system done first.
> Is there any documentation describing the recommended methodology for
performing such an upgrade ?
> Are there any known problems to watch out for ?
> I know theses are general questions but I would rather be aware of best
prctices or potential problems before I start.
> Any help gratefully received,
> Den.
Operating System Upgrade
We are running SQL Server 7 on NT Server
I am responsible for an upgrade path which will migrate to Windows 2000 Server and SQL Server 2000
The upgrade will take place in steps with the operating system done first
Is there any documentation describing the recommended methodology for performing such an upgrade
Are there any known problems to watch out for
I know theses are general questions but I would rather be aware of best prctices or potential problems before I start
Any help gratefully received
Den.Have a look at
http://www.sqlteam.com/item.asp?ItemID=9066
http://www.sqlteam.com/item.asp?ItemID=9465
Query plans will change so some SQL may go faster others slower.
Paul
"Den" <anonymous@.discussions.microsoft.com> wrote in message
news:4CB242DE-4818-4E1E-AC3C-21D962AADDDC@.microsoft.com...
> Hi,
> We are running SQL Server 7 on NT Server.
> I am responsible for an upgrade path which will migrate to Windows 2000
Server and SQL Server 2000.
> The upgrade will take place in steps with the operating system done first.
> Is there any documentation describing the recommended methodology for
performing such an upgrade ?
> Are there any known problems to watch out for ?
> I know theses are general questions but I would rather be aware of best
prctices or potential problems before I start.
> Any help gratefully received,
> Den.
Saturday, February 25, 2012
Operating system error code 3(The system cannot find the path specified.).
I use Bulk insert to put data to myTable.
When the SQL server is in local machin, it works well. But when I put
the data in a sql server situated not locally, then I get a error
message like this:
Could not bulk insert because file 'C:\Data\2003
txtfiles\abif_20031130.txt' could not be opened. Operating system
error code 3(The system cannot find the path specified.).
BULK INSERT myTable
FROM 'C:\Data\2003 txtfiles\abif_20031130.txt'
with (
-- codepage = ' + char(39) + 'ACP' + char(39) + ',
fieldterminator = ';',
rowterminator = '\n',
keepnulls,
maxerrors=0)
Someone can explan me what the error shows up
Thanks in advance
- Loi -The location of the file is relative to the SQL Server on which the BULK
INSERT command runs. To import a file from another machine, specify an UNC
path rather than use drive letters. For example:
BULK INSERT myTable
FROM '\\MyOtherServer\MyShare\Data\2003 txtfiles\abif_20031130.txt'
Note that the SQL Server service account needs permissions to the share.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Loi" <votanloi@.hotmail.com> wrote in message
news:af9512d5.0406030313.73ed644b@.posting.google.c om...
> Hi All,
> I use Bulk insert to put data to myTable.
> When the SQL server is in local machin, it works well. But when I put
> the data in a sql server situated not locally, then I get a error
> message like this:
> Could not bulk insert because file 'C:\Data\2003
> txtfiles\abif_20031130.txt' could not be opened. Operating system
> error code 3(The system cannot find the path specified.).
> BULK INSERT myTable
> FROM 'C:\Data\2003 txtfiles\abif_20031130.txt'
> with (
> -- codepage = ' + char(39) + 'ACP' + char(39) + ',
> fieldterminator = ';',
> rowterminator = '\n',
> keepnulls,
> maxerrors=0)
> Someone can explan me what the error shows up
> Thanks in advance
> - Loi -|||Hi Dan,
Thanks for your reply.
It does not work yet.
A next question:
SQL Server service account needs permissions to the share.
In my case SQL server is setup following:
In the security tab: Authentication - SQL server and windows.
Startup sevice account - system account.
Can somebody give me any hints
Regards
- Loi -
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message news:<laEvc.20183$Tn6.12968@.newsread1.news.pas.earthlink .net>...
> The location of the file is relative to the SQL Server on which the BULK
> INSERT command runs. To import a file from another machine, specify an UNC
> path rather than use drive letters. For example:
> BULK INSERT myTable
> FROM '\\MyOtherServer\MyShare\Data\2003 txtfiles\abif_20031130.txt'
> Note that the SQL Server service account needs permissions to the share.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Loi" <votanloi@.hotmail.com> wrote in message
> news:af9512d5.0406030313.73ed644b@.posting.google.c om...
> > Hi All,
> > I use Bulk insert to put data to myTable.
> > When the SQL server is in local machin, it works well. But when I put
> > the data in a sql server situated not locally, then I get a error
> > message like this:
> > Could not bulk insert because file 'C:\Data\2003
> > txtfiles\abif_20031130.txt' could not be opened. Operating system
> > error code 3(The system cannot find the path specified.).
> > BULK INSERT myTable
> > FROM 'C:\Data\2003 txtfiles\abif_20031130.txt'
> > with (
> > -- codepage = ' + char(39) + 'ACP' + char(39) + ',
> > fieldterminator = ';',
> > rowterminator = '\n',
> > keepnulls,
> > maxerrors=0)
> > Someone can explan me what the error shows up
> > Thanks in advance
> > - Loi -|||> Startup sevice account - system account.
Try using a domain account rather than the local system account and ensure
the account has permissions to the share.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Loi Tan Vo" <loi.tan.vo@.fnh.no> wrote in message
news:73f04281.0406040358.5a342f93@.posting.google.c om...
> Hi Dan,
> Thanks for your reply.
> It does not work yet.
> A next question:
> SQL Server service account needs permissions to the share.
> In my case SQL server is setup following:
> In the security tab: Authentication - SQL server and windows.
> Startup sevice account - system account.
> Can somebody give me any hints
> Regards
> - Loi -
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:<laEvc.20183$Tn6.12968@.newsread1.news.pas.earthlink .net>...
> > The location of the file is relative to the SQL Server on which the BULK
> > INSERT command runs. To import a file from another machine, specify an
UNC
> > path rather than use drive letters. For example:
> > BULK INSERT myTable
> > FROM '\\MyOtherServer\MyShare\Data\2003 txtfiles\abif_20031130.txt'
> > Note that the SQL Server service account needs permissions to the share.
> > --
> > Hope this helps.
> > Dan Guzman
> > SQL Server MVP
> > "Loi" <votanloi@.hotmail.com> wrote in message
> > news:af9512d5.0406030313.73ed644b@.posting.google.c om...
> > > Hi All,
> > > > I use Bulk insert to put data to myTable.
> > > When the SQL server is in local machin, it works well. But when I put
> > > the data in a sql server situated not locally, then I get a error
> > > message like this:
> > > > Could not bulk insert because file 'C:\Data\2003
> > > txtfiles\abif_20031130.txt' could not be opened. Operating system
> > > error code 3(The system cannot find the path specified.).
> > > > BULK INSERT myTable
> > > FROM 'C:\Data\2003 txtfiles\abif_20031130.txt'
> > > with (
> > > -- codepage = ' + char(39) + 'ACP' + char(39) + ',
> > > fieldterminator = ';',
> > > rowterminator = '\n',
> > > keepnulls,
> > > maxerrors=0)
> > > > Someone can explan me what the error shows up
> > > > Thanks in advance
> > > - Loi -