Showing posts with label box. Show all posts
Showing posts with label box. Show all posts

Thursday, March 29, 2012

attach files to new box

sql2k sp3
Is there a way to attach the files of a db to a newly
created box? No backups as these are QA db's not
production.
TIA, ChrisR
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:c6fe01c48a03$56389420$a401280a@.phx.gbl...
> sql2k sp3
> Is there a way to attach the files of a db to a newly
> created box? No backups as these are QA db's not
> production.
Assuming that these files are now in use by SQL Server there are several
methods. You can detach the database, copy the *.mdf & *.ldf file to the new
server and reattach the files. Or, use the BACKUP command, then RESTORE on
your target server.
The following reference covers your options fairly well:
http://support.microsoft.com/default...b;en-us;314546
Steve

attach files to new box

sql2k sp3
Is there a way to attach the files of a db to a newly
created box? No backups as these are QA db's not
production.
TIA, ChrisR"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:c6fe01c48a03$56389420$a401280a@.phx.gbl...
> sql2k sp3
> Is there a way to attach the files of a db to a newly
> created box? No backups as these are QA db's not
> production.
Assuming that these files are now in use by SQL Server there are several
methods. You can detach the database, copy the *.mdf & *.ldf file to the new
server and reattach the files. Or, use the BACKUP command, then RESTORE on
your target server.
The following reference covers your options fairly well:
http://support.microsoft.com/defaul...kb;en-us;314546
Steve

attach files to new box

sql2k sp3
Is there a way to attach the files of a db to a newly
created box? No backups as these are QA db's not
production.
TIA, ChrisR"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:c6fe01c48a03$56389420$a401280a@.phx.gbl...
> sql2k sp3
> Is there a way to attach the files of a db to a newly
> created box? No backups as these are QA db's not
> production.
Assuming that these files are now in use by SQL Server there are several
methods. You can detach the database, copy the *.mdf & *.ldf file to the new
server and reattach the files. Or, use the BACKUP command, then RESTORE on
your target server.
The following reference covers your options fairly well:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
Steve

Tuesday, March 27, 2012

Attach database between different sort orders

Hi,

Just wanted to check. I've got a SQL 7.0 box on NT4 with about 40 databases (each about 500Mb-1Gb) which I want to move to SQL2000.

The main problem is, the 7.0 box was built with a sort order not officially supported by the finance software that uses the databases, so I want to build the SQL2000 box with the default sort orders and character sets.

I've done this in a test environment by copying the .mdf files accross and attaching them to the SQL2000 box, and this all seems to work. But is this advisable, and will there be any problems?

Thanks for the help!!It does?

How are you doing the migration?

Dump and Restore...I didn't think it would work...Never did for me...

I know there are reasons, but WHY (for the love of god) do people install with other than the default collation..|||Yeah, it works, basically just by taking the current database offline, copying the .mdf and .ldf files to the new server, and attaching the database.

Backup / restore won't work, as it gives sort order errors...

As for why not have a defaul sort order, I don't know - just ask whoever built the original server!!

So given that I've got it to work, is this a good idea, or should I DTS the data accross (which would take a lot longer!)?|||If there are different sort orders, you can setup the new server with old server's configuration and use BACKUP/RESTORE method.

If not DTS is only way to get the data out from source database.|||Yeah, but I actually WANT to change the sort order to the default.

If DTS is the best way of doing this rather than the way I've desribed above, is there any way of setting the DTS package not to get logged, as this is a pain when migrating a large database...

Cheers!

Sunday, March 25, 2012

attach 2005 db on 2000

I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
there any way to do this if I no longer have sql 2005 running? I detached
and saved the db, but I don't have 2005 running anywhere anymore.
Thanks, Andre
"Andre" <no@.spam.com> wrote in
news:#p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl:

> I have a sql 2005 beta 2 db that I need to move back to a sql 2000
> box. Is there any way to do this if I no longer have sql 2005
> running? I detached and saved the db, but I don't have 2005 running
> anywhere anymore.
Unfortunately, I do not think so. It's quite possible to attach a SQL
Server 2000 to SQL Server 2005, but as far as I know not the other way
around.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||Bummer, that's what I was afraid of. Thanks for the reply.
|||1. Create new database in SQL 2000
2. Genarete script from objtects on the SQL 2005
3. Execute this script on the SQL 2000
If you have data, use bcp utilities or DTS/SSIS to export and import.
Regards
Amish
|||"amish" <shahamishm@.gmail.com> wrote in news:1136273968.474136.28240
@.g44g2000cwa.googlegroups.com:

> 1. Create new database in SQL 2000
> 2. Genarete script from objtects on the SQL 2005
> 3. Execute this script on the SQL 2000
> If you have data, use bcp utilities or DTS/SSIS to export and import.
Of course, there are only one problem: There are no SQL Server 2005
instance, so there is nowhere to create the scripts As far as I remember
from the original post, the situation is that he has a database detached
from SQL Server 2005, but no SQL Server 2005 instance.
He can install one though...
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||That they have to manage.
Regards
Amish
|||No. The internal bits are different. You can not attach a 2005 database to
2000.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Andre" <no@.spam.com> wrote in message
news:%23p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl...
>I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
>there any way to do this if I no longer have sql 2005 running? I detached
>and saved the db, but I don't have 2005 running anywhere anymore.
> Thanks, Andre
>
|||Thanks all.
In fact, I did end up installing SQL2005 beta 2 on another box. Then the
fun began because that box didn't have enough disk space to hold my 2005 db
that I was concerned with. But fortunately I found the article that showed
my how to flip a traceflag so that I could connect the db to a network
share. That worked - and then I used Integration Services (dts) to transfer
the data to a new sql 2k db. Where there's a will, there's a way.
Andre

attach 2005 db on 2000

I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
there any way to do this if I no longer have sql 2005 running? I detached
and saved the db, but I don't have 2005 running anywhere anymore.
Thanks, Andre"Andre" <no@.spam.com> wrote in
news:#p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl:
> I have a sql 2005 beta 2 db that I need to move back to a sql 2000
> box. Is there any way to do this if I no longer have sql 2005
> running? I detached and saved the db, but I don't have 2005 running
> anywhere anymore.
Unfortunately, I do not think so. It's quite possible to attach a SQL
Server 2000 to SQL Server 2005, but as far as I know not the other way
around.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||Bummer, that's what I was afraid of. Thanks for the reply.|||1. Create new database in SQL 2000
2. Genarete script from objtects on the SQL 2005
3. Execute this script on the SQL 2000
If you have data, use bcp utilities or DTS/SSIS to export and import.
Regards
Amish|||"amish" <shahamishm@.gmail.com> wrote in news:1136273968.474136.28240
@.g44g2000cwa.googlegroups.com:
> 1. Create new database in SQL 2000
> 2. Genarete script from objtects on the SQL 2005
> 3. Execute this script on the SQL 2000
> If you have data, use bcp utilities or DTS/SSIS to export and import.
Of course, there are only one problem: There are no SQL Server 2005
instance, so there is nowhere to create the scripts :) As far as I remember
from the original post, the situation is that he has a database detached
from SQL Server 2005, but no SQL Server 2005 instance.
He can install one though...
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||That they have to manage.
Regards
Amish|||No. The internal bits are different. You can not attach a 2005 database to
2000.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Andre" <no@.spam.com> wrote in message
news:%23p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl...
>I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
>there any way to do this if I no longer have sql 2005 running? I detached
>and saved the db, but I don't have 2005 running anywhere anymore.
> Thanks, Andre
>|||Thanks all.
In fact, I did end up installing SQL2005 beta 2 on another box. Then the
fun began because that box didn't have enough disk space to hold my 2005 db
that I was concerned with. But fortunately I found the article that showed
my how to flip a traceflag so that I could connect the db to a network
share. That worked - and then I used Integration Services (dts) to transfer
the data to a new sql 2k db. Where there's a will, there's a way. :)
Andre

attach 2005 db on 2000

I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
there any way to do this if I no longer have sql 2005 running? I detached
and saved the db, but I don't have 2005 running anywhere anymore.
Thanks, Andre"Andre" <no@.spam.com> wrote in
news:#p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl:

> I have a sql 2005 beta 2 db that I need to move back to a sql 2000
> box. Is there any way to do this if I no longer have sql 2005
> running? I detached and saved the db, but I don't have 2005 running
> anywhere anymore.
Unfortunately, I do not think so. It's quite possible to attach a SQL
Server 2000 to SQL Server 2005, but as far as I know not the other way
around.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||Bummer, that's what I was afraid of. Thanks for the reply.|||1. Create new database in SQL 2000
2. Genarete script from objtects on the SQL 2005
3. Execute this script on the SQL 2000
If you have data, use bcp utilities or DTS/SSIS to export and import.
Regards
Amish|||"amish" <shahamishm@.gmail.com> wrote in news:1136273968.474136.28240
@.g44g2000cwa.googlegroups.com:

> 1. Create new database in SQL 2000
> 2. Genarete script from objtects on the SQL 2005
> 3. Execute this script on the SQL 2000
> If you have data, use bcp utilities or DTS/SSIS to export and import.
Of course, there are only one problem: There are no SQL Server 2005
instance, so there is nowhere to create the scripts As far as I remember
from the original post, the situation is that he has a database detached
from SQL Server 2005, but no SQL Server 2005 instance.
He can install one though...
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||That they have to manage.
Regards
Amish|||No. The internal bits are different. You can not attach a 2005 database to
2000.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Andre" <no@.spam.com> wrote in message
news:%23p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl...
>I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
>there any way to do this if I no longer have sql 2005 running? I detached
>and saved the db, but I don't have 2005 running anywhere anymore.
> Thanks, Andre
>|||Thanks all.
In fact, I did end up installing SQL2005 beta 2 on another box. Then the
fun began because that box didn't have enough disk space to hold my 2005 db
that I was concerned with. But fortunately I found the article that showed
my how to flip a traceflag so that I could connect the db to a network
share. That worked - and then I used Integration Services (dts) to transfer
the data to a new sql 2k db. Where there's a will, there's a way.
Andre

Sunday, March 11, 2012

Assigning one text box value to the other text box in the sql reporting services Form

Hi,

Can some one help me in this case,

I am manipulating a value for onetext.value , And I want to assign like this

seconetext.value = onetext.value in the SQl reporting services form,

Is it possible? if so can any one help me with the syntax?

-Thanks

Yes, this is possible.

In "seconetext", use this expression:

=ReportItems!onetext.Value

-Chris

Saturday, February 25, 2012

ASR backup of SQL server 2000

Is there a process or procedure to use ASR as part of backup and recovery of a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
Thanks,
Gordon
please disregard this post.
"GoHwang" wrote:

> Is there a process or procedure to use ASR as part of backup and recovery of a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
> Thanks,
> Gordon

ASR backup of SQL server 2000

Is there a process or procedure to use ASR as part of backup and recovery of
a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
Thanks,
Gordonplease disregard this post.
"GoHwang" wrote:

> Is there a process or procedure to use ASR as part of backup and recovery
of a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
> Thanks,
> Gordon

ASR backup of SQL 2000 on win2k3

Is there a process or procedure to use ASR as part of backup and recovery of
a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
Thanks,
Gordonplease disregard this post
"GoHwang" wrote:

> Is there a process or procedure to use ASR as part of backup and recovery
of a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
> Thanks,
> Gordon

ASR backup of SQL 2000 on win2k3

Is there a process or procedure to use ASR as part of backup and recovery of a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
Thanks,
Gordonplease disregard this post
"GoHwang" wrote:
> Is there a process or procedure to use ASR as part of backup and recovery of a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
> Thanks,
> Gordon

ASR backup of SQL 2000 on win2k3

Is there a process or procedure to use ASR as part of backup and recovery of a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
Thanks,
Gordon
please disregard this post
"GoHwang" wrote:

> Is there a process or procedure to use ASR as part of backup and recovery of a SQL server 2000 box? We are using SQL 2000 on win2k3 EE.
> Thanks,
> Gordon

Thursday, February 9, 2012

ASP.NET 2.0 / ASP and SQL Server 2005

I'm having to do some maintenance on a legacy site done in "classic" ASP. I've taken the site onto our new internal win2k3 box as it doesn't need to be public any longer and put the DB on sql server 2005. All good so far.

I can't get the app to connect to the DB at all. If I use the exact same connection string that works in an asp.net 2.0 app on the same server, it doesn't work. I don't even have to do a query, merely opening the connection will break it.

I use...
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open "Data Source=********;Initial Catalog=intranet_database;Integrated Security=True" '(that's the connection string that works just fine on the asp.net app)

I get..
Microsoft OLE DB Service Components error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/v1/testing/default.asp, line 13

Most of the stuff I can see relates to datatypes and so on, but given the above I can't see how that might be.

Any ideas? Please! ;-)

I solved this by creating a black UDL file on the desktop and it generated a very different connection string. When I try and grant the ISR_MACHINENAME user access to the database I keep getting this not very helpful error message.

|||

Can't you edit a post? What I meant to say was...

Yeskin Gallen:

I solved this by creating a blank UDL file on the desktop and it generated a very different connection string. When I try and grant the IUSR_MACHINENAME user access to the database I keep getting this not very helpful error message...

TITLE: Microsoft SQL Server Management Studio

----------

Cannot show requested dialog.

----------

ADDITIONAL INFORMATION:

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

----------

The server principal "BEL-INTRANET-01\IUSR_BEL-INTRANET-01" is not able to access the database "self-builder-v1" under the current security context. (Microsoft SQL Server, Error: 916)

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

----------

BUTTONS:

OK

----------