Can not connect to some tables with seagate crystal report

Seagate crystal reports:
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL
Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.
I can connect to other tables in same database. One thing that is different
in the tables which i can not connect is that its name is like (Application
Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of table
cause connection issue or its a permission issue?
ontario, canada
SQL server 2000 enterprise edition. The problem is with the table name.
Somehow crystal report does not accept table name with "."
Does anyone know a wayaround.
ontario, canada
"db" wrote:

> Seagate crystal reports:
> When i am trying to attach a table to seagate crystal report i am getting
> this error:
> Database Error: [Microsoft][ODBC SQL Server Driver][SQL
> Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
> I can connect to other tables in same database. One thing that is different
> in the tables which i can not connect is that its name is like (Application
> Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of table
> cause connection issue or its a permission issue?
>
> --
> ontario, canada
|||"db" <db@.discussions.microsoft.com> wrote in message
news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> SQL server 2000 enterprise edition. The problem is with the table name.
> Somehow crystal report does not accept table name with "."
> Does anyone know a wayaround.
> --
> ontario, canada
Rename the table? Create/use a view with a name that Crystal likes? Or
perhaps post on a newsgroup that is specific to crystal reports. You do
know that Seagate is no longer involved with Crystal Reports and hasn't been
for some years - that would indicate you are using an old (and perhaps
unsupported) version.
|||Views works.
Thanks
"Scott Morris" wrote:

> "db" <db@.discussions.microsoft.com> wrote in message
> news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> Rename the table? Create/use a view with a name that Crystal likes? Or
> perhaps post on a newsgroup that is specific to crystal reports. You do
> know that Seagate is no longer involved with Crystal Reports and hasn't been
> for some years - that would indicate you are using an old (and perhaps
> unsupported) version.
>
>

Can not connect to some tables with seagate crystal report

Seagate crystal reports:
When i am trying to attach a table to seagate crystal report i am getting
this error:
Database Error: [Microsoft][ODBC SQL Server Driver][SQL
Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not ex
ist or
access denied.
I can connect to other tables in same database. One thing that is different
in the tables which i can not connect is that its name is like (Application
Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of tabl
e
cause connection issue or its a permission issue?
ontario, canadaSQL server 2000 enterprise edition. The problem is with the table name.
Somehow crystal report does not accept table name with "."
Does anyone know a wayaround.
--
ontario, canada
"db" wrote:

> Seagate crystal reports:
> When i am trying to attach a table to seagate crystal report i am getting
> this error:
> Database Error: [Microsoft][ODBC SQL Server Driver][SQL
> Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or
> access denied.
> I can connect to other tables in same database. One thing that is differen
t
> in the tables which i can not connect is that its name is like (Applicatio
n
> Name.dbo.samplecounty-etp.etp.Emp_Qualifications). Can naming syntex of ta
ble
> cause connection issue or its a permission issue?
>
> --
> ontario, canada|||"db" <db@.discussions.microsoft.com> wrote in message
news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> SQL server 2000 enterprise edition. The problem is with the table name.
> Somehow crystal report does not accept table name with "."
> Does anyone know a wayaround.
> --
> ontario, canada
Rename the table? Create/use a view with a name that Crystal likes? Or
perhaps post on a newsgroup that is specific to crystal reports. You do
know that Seagate is no longer involved with Crystal Reports and hasn't been
for some years - that would indicate you are using an old (and perhaps
unsupported) version.|||Views works.
Thanks
"Scott Morris" wrote:

> "db" <db@.discussions.microsoft.com> wrote in message
> news:6013B66D-ECA6-4B76-8480-B72E5ED7DC47@.microsoft.com...
> Rename the table? Create/use a view with a name that Crystal likes? Or
> perhaps post on a newsgroup that is specific to crystal reports. You do
> know that Seagate is no longer involved with Crystal Reports and hasn't be
en
> for some years - that would indicate you are using an old (and perhaps
> unsupported) version.
>
>

Can not attach SQL Server 2005 Express database

I got the folllowin error while trying to attach database. The directory is there...

TITLE: Locate Database Files - H001335\SQLEXPRESS

C:\Documents and Settings\Administrator.H001335\My Documents\Visual Studio 2005\WebSites\Import\App_Data
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

BUTTONS:

OK

Moving thread to a more appropriate forum.|||where is it?|||please help, no idea why I can't attach this database|||Make sure you do not have VS open (as server manager creates a connection to sql server), and try stopping and restarting the sqlserver agen service. Then try to attach the database. Is the nme the same as the db name? You may need to copy over the log file aswell (daname_log.ldf).|||

Are you using "User Instance=True" in your connection string?

If so, you need to make sure that the user who is running the task has appropriate permissions to access files in that directory (by the looks ASPNET might be the user).

If you're not, then I try running the the sql server service as "Local System" instead of the default "Network Service", or give "Network Service" appropriate permissions for that location.

|||Yes you are right, seems this was related to the user ASP.NEt not having enough rights in the directory...

Can not attach SQL Server 2005 Express database

I got the folllowin error while trying to attach database. The directory is there...

TITLE: Locate Database Files - H001335\SQLEXPRESS

C:\Documents and Settings\Administrator.H001335\My Documents\Visual Studio 2005\WebSites\Import\App_Data
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

BUTTONS:

OK

Moving thread to a more appropriate forum.|||where is it?|||please help, no idea why I can't attach this database|||Make sure you do not have VS open (as server manager creates a connection to sql server), and try stopping and restarting the sqlserver agen service. Then try to attach the database. Is the nme the same as the db name? You may need to copy over the log file aswell (daname_log.ldf).|||

Are you using "User Instance=True" in your connection string?

If so, you need to make sure that the user who is running the task has appropriate permissions to access files in that directory (by the looks ASPNET might be the user).

If you're not, then I try running the the sql server service as "Local System" instead of the default "Network Service", or give "Network Service" appropriate permissions for that location.

|||Yes you are right, seems this was related to the user ASP.NEt not having enough rights in the directory...sql

Can not attach SQL Server 2005 Express database

I got the folllowin error while trying to attach database. The directory is there...

TITLE: Locate Database Files - H001335\SQLEXPRESS

C:\Documents and Settings\Administrator.H001335\My Documents\Visual Studio 2005\WebSites\Import\App_Data
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

BUTTONS:

OK

Moving thread to a more appropriate forum.|||where is it?|||please help, no idea why I can't attach this database|||Make sure you do not have VS open (as server manager creates a connection to sql server), and try stopping and restarting the sqlserver agen service. Then try to attach the database. Is the nme the same as the db name? You may need to copy over the log file aswell (daname_log.ldf).|||

Are you using "User Instance=True" in your connection string?

If so, you need to make sure that the user who is running the task has appropriate permissions to access files in that directory (by the looks ASPNET might be the user).

If you're not, then I try running the the sql server service as "Local System" instead of the default "Network Service", or give "Network Service" appropriate permissions for that location.

|||Yes you are right, seems this was related to the user ASP.NEt not having enough rights in the directory...

Can not attach msde2000 db into sql express

I have side by side msde2000 and sqlexpress installed. I need to move a db that has been detached from msde2000 and where it works perfectly fine into sql express. After I select the .mdf file to attach I get this error:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'LTBAHIA\SQLEXPRESS'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x55555551). It occurred during a read of page (1:97) in database ID 6 at offset 0x000000000c2000 in file 'C:\Memo2005\Diary\MEMO\bin\MEMOsql.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Converting database 'MEMOsql' from version 539 to the current version 611.
Database 'MEMOsql' running the upgrade step from version 539 to version 551. (Microsoft SQL Server, Error: 824)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=824&LinkId=20476

BUTTONS:

OK

Thanks for any help,

Luis

The error is indicating a corruption of your databasefile. Could you run the suggested DBCC CHECKDB?

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||The database is either not consistent or was not shutdown down / dettached the right way. Attach the database to SQL Server 2000 again, run CHECKDB, dettach is with either a command or the GUI and run attach it on the SQL Server Express, once beginning the attach process, the server will do an automatic conversion process which will need the database is a concistent state. if this does not work, try to make a backup on the SQL 2k database and restore it on the 2k5 (Express) server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I have been trying to run CHECKDB but since it requires to have sql server in single user mode I have not been able to do it. If I start from a comand console with sqlservr -m and then I go to

Query Analyzer and try to connect to the server it refuses because it is in single user mode. It seems like a catch 22. Is there a way to start sql server in single user mode from within Sql Analyzer or Enterprise? Or better, how can I do the CHECKDB without running in these problems.

Thanks,

Luis

|||

Unless you do not use any REPAIR commands you do not have to have the db in single user mode only. If you want to set the USER DATABASE in single user mode, you do not have to start the server in single user mode. Just use the command

EXEC sp_dboption 'DATABASENAME', 'single user', 'TRUE'

-Or (for sql 2k5)

ALTER DATABASE DbName SET SINGLE_USER

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thank you very much Jens. After a few tries it worked and now I have the DB converted.

Luis

Can not attach MDF from HDS LUN

Hi..

We are trying to attach a database (MDF File without LDF File) in SQL2K SP4

MDF File is in HDS (Hitachi Data Storage) Lun or SAN Storage.

When we try attach the MDF File, we are getting an error. The error message is :

" Error 1813: Could not open new database 'Test'. CREATE DATABASE is aborted.

Device activation error. The physical file name 'F:\SQLData\Test_log.ldf' maybe incorrect "

When We try attach the MDF File, but We move the MDF File into Local Hard Drive (Drive C:), then We success to attached the MDF File and the LDF File is automaticlly generated without error.

i'm waiting for the solution

Thank's.

Brgds,

Dwiharto

How did you attach it? Try using sp_attach_single_file_db stored procedure instead.

Whether the data file resides on the SAN or not should not matter here.|||

I had try it before, but it is still doesn't working and still had same error message.

btw thanks for ur advice.

maybe u can tell me another way?

Thank's a lot Friend ...

|||Can you post the exact attach statement.|||

the statement :

sp_attach_single_file_db @.dbname = 'test',
@.physname = 'F:\SQLData\Test.mdf'

Thank's..

|||

The statement looks valid. (F:\) is a locally attached SAN, right? If this is a network attached san, you need to turn on trace flag (1807). Also, does the account used to start sqlserver service has full right to the SAN?

Can not attach mdf 2005 file into sqlserver 2000

hello all.
I have a database file in sqlserver 2005 mode, i set it's compatiblity to sqlserver 2000 (80) but i cant attach it in sqlserver 2000.
My host only support sqlserver 2000!

I need any help to convert or attach it!
Thank all!

Sadly to say: you can not attach a SQL2005 database to a SQL2000 instance even you set the compatiblity to sqlserver 2000 (80). I'm afraid you have create a new database with exact the same schema in SQL2000, and transfer data from the original database to the new one. You can get the scripts for creating the objects of the same schemas by right clicking the objects in Management Studio.

|||

Thank!

Sql 2005 is so bad! No server is using it now!

Can not attach database,

Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.

My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,

I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.

if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.

Pleace help me.

Thanks.

It appears that you have a corrupted database file (.MDF), and have been attempting to use a 3rd-party data recovery tool to extract as much data as possible from the damaged database. Is this correct?

It also appears that your disk is likely damaged. Can I assume that you've replaced it?

The primary response in this situation would always be to restore the database from backup. When is your most recent database backup from? Without a valid backup, there's unfortunately not much you can do.

sql

Can multiple workstations running SQL 2005 Server Express attach to the same database files on a

Can multiple instances of SQL 2005 Express attach to the same database files on a network share? I have seen this done before with MSDE where the database files are stored on the server, but instead of having a SQL server running on the network and then connecting to it, only the database files exist on the network share and the users connect through MSDE running on the local machine. Is this possible with SQL2005Express? I do not have the ability to share an SQL instance from one workstation to another nor do I have the ability to install an instance on the corporate server. Is it as simple as creating the database and storing the files on the share then attaching the database to the SQL Instance on each workstation?

No and No. You can only attach a database file to a single instance at a time and SQL Express does not support attaching files from a remote source, only local drives.

Mike

|||

As Michael indicated, that is not possible -and it is not possible with MSDE either.

You will have to install a SQL Server Express somewhere, and that will also be the location for the data files. I suggest that you communicate and negotiate with your network admins, and of course, get the 'clients' involved too.

Otherwise, you will be limited to using an Access *.mdb file -which can be stored on a file server.

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon
SQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon
|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
SimonSQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Sorry - forgot to mention that if you have any remote logins, then you may
get an error. If so, you need to drop those before you can drop the
servername.
Apologies for the incomplete first response - was just running to the coffee
machine - it's that time of the day
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon|||Some thoughts here:
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Simon Harvey" <nothanks@.hotmail.com> wrote in message news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx
.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is
> it "name agnostic"?
> Many thanks
> Simon

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
SimonSQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Sorry - forgot to mention that if you have any remote logins, then you may
get an error. If so, you need to drop those before you can drop the
servername.
Apologies for the incomplete first response - was just running to the coffee
machine - it's that time of the day :)
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon|||Some thoughts here:
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Simon Harvey" <nothanks@.hotmail.com> wrote in message news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is
> it "name agnostic"?
> Many thanks
> Simon

can I pull a sql 2000 datafile into sql express ?

Can I do this with a sql 2000 database
http://www.cryer.co.uk/brian/sqlserver/howto_movedatabasefile.htm

then attach sql express to this mdf ?

hi,

BitShift wrote:

Can I do this with a sql 2000 database
http://www.cryer.co.uk/brian/sqlserver/howto_movedatabasefile.htm

then attach sql express to this mdf ?

no, but you can do the contrary, attach the mdf (+ ldf) to SQLExpress

regards

|||So whats the best way to export tables and data from a sql 2K db and import /recreate it in sqlexpress ? I have a sql2k database on a server and id like to pull it down and work against it locally.|||

hi,

just perform a backup->copy->restore or a sp_detach_db->copy->CREATE DATABASE xx FOR ATTACH (sp_attach_db has been deprecated in SQL Server 2005, but still usable), http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp

then you have to modify the compatibility level of the attached database to 9, http://msdn2.microsoft.com/en-us/library/ms178653.aspx, modify the database owner to a valid user, http://msdn2.microsoft.com/en-us/library/ms178630.aspx and finally regenerate database user's tables statistics with full scan, http://msdn2.microsoft.com/en-us/library/ms187348.aspx, as SQL Server 2005 implements different algorithm on them..

regards

|||i did the first step.... i tried to attach a database... but then poof!!! i had a message in my console the msg 601 ''could not continue scan with nolock due to data movement''

i did install the recommended fix exe, the 2000 sP4.. but it still appears.

please help me out, i can't attach an existing sql2k database to my dev express.. wat am i gonna do? im desperate.
|||

hi,

actually I've only seen this exception related to DML operations and not with RESTORE tasks..

but let's wait for Mike to jump in...

regards

|||i still dont get it... how do i restore a database that is backed up from sql2k to sql express?

the sql express that i am talking about is the one that is included in the Microsoft Visual Web Developer 2005...

i don't see an option that i can restore a certain backup database. is my only way to restore is to access the tui console > sqlcmd -S .\sqlexpress?

how, how?!?! im so noob.

tnx|||hey! i got it... ^_^

i used

BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GO


from: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp

thanx PO!!

God bless

can I pull a sql 2000 datafile into sql express ?

Can I do this with a sql 2000 database
http://www.cryer.co.uk/brian/sqlserver/howto_movedatabasefile.htm

then attach sql express to this mdf ?

hi,

BitShift wrote:

Can I do this with a sql 2000 database
http://www.cryer.co.uk/brian/sqlserver/howto_movedatabasefile.htm

then attach sql express to this mdf ?

no, but you can do the contrary, attach the mdf (+ ldf) to SQLExpress

regards

|||So whats the best way to export tables and data from a sql 2K db and import /recreate it in sqlexpress ? I have a sql2k database on a server and id like to pull it down and work against it locally.|||

hi,

just perform a backup->copy->restore or a sp_detach_db->copy->CREATE DATABASE xx FOR ATTACH (sp_attach_db has been deprecated in SQL Server 2005, but still usable), http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp

then you have to modify the compatibility level of the attached database to 9, http://msdn2.microsoft.com/en-us/library/ms178653.aspx, modify the database owner to a valid user, http://msdn2.microsoft.com/en-us/library/ms178630.aspx and finally regenerate database user's tables statistics with full scan, http://msdn2.microsoft.com/en-us/library/ms187348.aspx, as SQL Server 2005 implements different algorithm on them..

regards

|||i did the first step.... i tried to attach a database... but then poof!!! i had a message in my console the msg 601 ''could not continue scan with nolock due to data movement''

i did install the recommended fix exe, the 2000 sP4.. but it still appears.

please help me out, i can't attach an existing sql2k database to my dev express.. wat am i gonna do? im desperate.
|||

hi,

actually I've only seen this exception related to DML operations and not with RESTORE tasks..

but let's wait for Mike to jump in...

regards

|||i still dont get it... how do i restore a database that is backed up from sql2k to sql express?

the sql express that i am talking about is the one that is included in the Microsoft Visual Web Developer 2005...

i don't see an option that i can restore a certain backup database. is my only way to restore is to access the tui console > sqlcmd -S .\sqlexpress?

how, how?!?! im so noob.

tnx|||hey! i got it... ^_^

i used

BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'
RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'
GO


from: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp

thanx PO!!

God bless