creating an INSTANCE from an existing INSTANCE

Is it possible , without using the installation CD , to create a new
INSTANCE of SQL Server 2005 from an existing INSTANCE on the same server?
--
___________________________________
Need an IT job? http://www.ITjobfeed.comNo. (Sorry.)
RLF
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:7d-dnT4Z_5Cy-0DbnZ2dnUVZ8v6dnZ2d@.bt.com...
> Is it possible , without using the installation CD , to create a new
> INSTANCE of SQL Server 2005 from an existing INSTANCE on the same server?
>
> --
>
> ___________________________________
> Need an IT job? http://www.ITjobfeed.com
>
>
>|||No Jack. You must start setup from CD\DVD again and choose another name for
your new instance. It's totally a new installation except for some common
services (SSIS etc.)
--
Ekrem Önsoy
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:7d-dnT4Z_5Cy-0DbnZ2dnUVZ8v6dnZ2d@.bt.com...
> Is it possible , without using the installation CD , to create a new
> INSTANCE of SQL Server 2005 from an existing INSTANCE on the same server?
>
> --
>
> ___________________________________
> Need an IT job? http://www.ITjobfeed.com
>
>
>

Creating an Alias for a (non-default) SQL Server 2005 Instance

I am trying to create an alias for a particular SQL Server 2005
Instance.
I've tried doing this in the host file but this was unsucessful
because all the host file seems to do is give you an IP address for
the required server (not the acutal SQL instance).
How do I go about setting up the alias correctly, do I need to use DNS
or something like that?
The alias is fixed and of the form "dbsrvMyDatabase"
Any suggestions would be gratefully received.Use cliconfg.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<charlieopenshaw@.gmail.com> wrote in message
news:1178272012.359623.8200@.y80g2000hsf.googlegroups.com...
>I am trying to create an alias for a particular SQL Server 2005
> Instance.
> I've tried doing this in the host file but this was unsucessful
> because all the host file seems to do is give you an IP address for
> the required server (not the acutal SQL instance).
> How do I go about setting up the alias correctly, do I need to use DNS
> or something like that?
> The alias is fixed and of the form "dbsrvMyDatabase"
> Any suggestions would be gratefully received.
>|||Tibor,
Thanks, that worked a treat.
I went to Alias > Add...
Selected TCP/IP, entered the Server Alias, Server name, checked
Dynamically determine port and entered my port number.
I had to get my port number setting from:
SQL Server Configuration Manager > SQL Server 2005 Network
Configuration > TCP/IP > TCP/IP Properties > IP Addresses > TCP
Dynamic Ports
Charlie
On 4 May, 11:40, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Usecliconfg.exe.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://sqlblog.com/blogs/tibor_karaszi
> <charlieopens...@.gmail.com> wrote in message
> news:1178272012.359623.8200@.y80g2000hsf.googlegroups.com...
>
>
>
>
>
>
> - Show quoted text -

Creating an Alias for a (non-default) SQL Server 2005 Instance

I am trying to create an alias for a particular SQL Server 2005
Instance.
I've tried doing this in the host file but this was unsucessful
because all the host file seems to do is give you an IP address for
the required server (not the acutal SQL instance).
How do I go about setting up the alias correctly, do I need to use DNS
or something like that?
The alias is fixed and of the form "dbsrvMyDatabase"
Any suggestions would be gratefully received.
Use cliconfg.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<charlieopenshaw@.gmail.com> wrote in message
news:1178272012.359623.8200@.y80g2000hsf.googlegrou ps.com...
>I am trying to create an alias for a particular SQL Server 2005
> Instance.
> I've tried doing this in the host file but this was unsucessful
> because all the host file seems to do is give you an IP address for
> the required server (not the acutal SQL instance).
> How do I go about setting up the alias correctly, do I need to use DNS
> or something like that?
> The alias is fixed and of the form "dbsrvMyDatabase"
> Any suggestions would be gratefully received.
>
|||Tibor,
Thanks, that worked a treat.
I went to Alias > Add...
Selected TCP/IP, entered the Server Alias, Server name, checked
Dynamically determine port and entered my port number.
I had to get my port number setting from:
SQL Server Configuration Manager > SQL Server 2005 Network
Configuration > TCP/IP > TCP/IP Properties > IP Addresses > TCP
Dynamic Ports
Charlie
On 4 May, 11:40, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Usecliconfg.exe.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> <charlieopens...@.gmail.com> wrote in message
> news:1178272012.359623.8200@.y80g2000hsf.googlegrou ps.com...
>
>
>
>
> - Show quoted text -
sql

Creating an Alias for a (non-default) SQL Server 2005 Instance

I am trying to create an alias for a particular SQL Server 2005
Instance.
I've tried doing this in the host file but this was unsucessful
because all the host file seems to do is give you an IP address for
the required server (not the acutal SQL instance).
How do I go about setting up the alias correctly, do I need to use DNS
or something like that?
The alias is fixed and of the form "dbsrvMyDatabase"
Any suggestions would be gratefully received.Use cliconfg.exe.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<charlieopenshaw@.gmail.com> wrote in message
news:1178272012.359623.8200@.y80g2000hsf.googlegroups.com...
>I am trying to create an alias for a particular SQL Server 2005
> Instance.
> I've tried doing this in the host file but this was unsucessful
> because all the host file seems to do is give you an IP address for
> the required server (not the acutal SQL instance).
> How do I go about setting up the alias correctly, do I need to use DNS
> or something like that?
> The alias is fixed and of the form "dbsrvMyDatabase"
> Any suggestions would be gratefully received.
>|||Tibor,
Thanks, that worked a treat.
I went to Alias > Add...
Selected TCP/IP, entered the Server Alias, Server name, checked
Dynamically determine port and entered my port number.
I had to get my port number setting from:
SQL Server Configuration Manager > SQL Server 2005 Network
Configuration > TCP/IP > TCP/IP Properties > IP Addresses > TCP
Dynamic Ports
Charlie
On 4 May, 11:40, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Usecliconfg.exe.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> <charlieopens...@.gmail.com> wrote in message
> news:1178272012.359623.8200@.y80g2000hsf.googlegroups.com...
>
> >I am trying to create analiasfor a particular SQL Server 2005
> >Instance.
> > I've tried doing this in the host file but this was unsucessful
> > because all the host file seems to do is give you an IP address for
> > the required server (not the acutal SQLinstance).
> > How do I go about setting up thealiascorrectly, do I need to use DNS
> > or something like that?
> > Thealiasis fixed and of the form "dbsrvMyDatabase"
> > Any suggestions would be gratefully received.- Hide quoted text -
> - Show quoted text -

Creating Additional Instances

How do I create additional instances of any MSSQL 2005 service(specifically database and analysis) given that a default instance is present?

You just need to run setup.exe again but this time do not install it as the default instance. In stead, you install it as a named instance. Under UI, you need to choose a different instance name. If you use a command line, the parameter INSTANCENAME=<NEW INSTANCE NAME> should be use.

|||

During the instance selection screen of the install, you can also click on the button to show currently installed instances to make sure that you don't pick the same instance name again.

Thanks,
Sam Lester (MSFT)

creating a server instance on SQL server 2005 enterprise

I got sql 2000 installed on my machine. I got a sql 2000 database instance on my computer and I installed sql 2005 server enterprise but I have got no server instance from sql 2005 like what i have in sql 2000 when i first install, i can have an own server instance on my computer.

is it becos when i have a previous sql 2000 server instance on my computer?

Your SQL server 2000 is probably installed as the 'default' instance. You can keep the default instance at version 2000, and install a 'named' instance for 2005. Or upgrade your default instance to 2005.

Look for the screen during setup that asks (radio buttons)

1) default instance, or

2) named instance. (to create a new named instance you need to type in a name for the instance)

|||how do i install a named instance? i need to uninstall sql 2005?|||i tried upgrading but the sql 2000 instance has errors when upgrading...|||i dun have the adventure works database....only northwind in sql 2000|||

You can create several named instances on the same computer, so you don't need to uninstall. (you can have 50 named instances with enterprise version)

To create a named instance from the command line you can type this: (this is a single command)

start /wait setup.exe /qb INSTANCENAME=brohans ADDLOCAL=SQL_Engine,Client_Components,SQLXML SAPWD=b2r0o0h6ans

Or use the setup interface and select the radio button for a named instance then type in brohans for the instance name.

|||

i install the adventureworks database....in my sql 2005

this article is helpful.

http://msdn2.microsoft.com/en-us/library/ms143804.aspx

Creating a new named instance

As understand it, the only way to add another SQL Express 2005 named instance is to run SQLEXPR32.EXE again.However, when you to, right at the end, you get the following error message:

"An installation package for the product MS SQLK Server VSS Writer cannot be found.Try the installation again using a valid copy of the installation package 'SQLWriter.msi'"

So, I deleted all named instances, and the repeated the procedure and did not get this error and it installed fine. Obviously, I would not be able to delete all instances, but in this case it didn't matter.

So, here are my questions:

Question 1) Am I correct you must rerun SQLEXPR32.EXE to create a new named instance? (I think the answer is yes)

Question 2) Is there a way to rename an existing named instance?(I think the answer is no)

Question 3) The install/uninstall for SQLEXPR32.EXE is incredibly buggy. I have spend days trying to remove an named instance with no succes. Once your remove all named instances from Control Pannel, you stll have not removed SQL Express 2005.How do you remove it?We are considering other avenues because of the incredible problems with this product. Also, we inadvertantly installed SQL Express 2005 Advanced Services, when we meant to install SQL Express 2005, so we would like to uninstall Advance Serviuces and reinstall SQL Express 2005

Question 4) I am switching from the Outlook Express newsgroups to these groups. In the context of these groups, what is the difference betwee a Forum and a Newsgroup?

Thanks

Bob

hi Bob,

BobInIndy wrote:

As understand it, the only way to add another SQL Express 2005 named instance is to run SQLEXPR32.EXE again. However, when you to, right at the end, you get the following error message:

"An installation package for the product MS SQLK Server VSS Writer cannot be found. Try the installation again using a valid copy of the installation package 'SQLWriter.msi'"

you can try unpacking the SQLExpress installer and manual install SQLWriter.msi and, eventually, SQL Native Client msi as well, as this is usually the one causing problems.. but your case does not indicates it..

So, I deleted all named instances, and the repeated the procedure and did not get this error and it installed fine. Obviously, I would not be able to delete all instances, but in this case it didn't matter.

So, here are my questions:

Question 1) Am I correct you must rerun SQLEXPR32.EXE to create a new named instance? (I think the answer is yes)

yes..

Question 2) Is there a way to rename an existing named instance? (I think the answer is no)

no

[quote]

Question 3) The install/uninstall for SQLEXPR32.EXE is incredibly buggy. I have spend days trying to remove an named instance with no succes. Once your remove all named instances from Control Pannel, you stll have not removed SQL Express 2005. How do you remove it? We are considering other avenues because of the incredible problems with this product. Also, we inadvertantly installed SQL Express 2005 Advanced Services, when we meant to install SQL Express 2005, so we would like to uninstall Advance Serviuces and reinstall SQL Express 2005

some times you have to manually remove phantoms accessing file system and registry, as described in here and/or here ..

Question 4) I am switching from the Outlook Express newsgroups to these groups. In the context of these groups, what is the difference betwee a Forum and a Newsgroup?

newsgroup are another community type, usually diffused and accessed via NNTP protocol, where forums have been designed for web access, usually with additional features like link sections, tips section and the like.. anyway this one should be consider a forum, AFAIK..

regards

Creating a new instance of SQL

Hi, We have a SQL server and I have installed a new instance for some
specific application database.
The installation go sucessfully coped all files and I can see the 2
instances on my Program Files folder and the 2 services running.
My question is : How is suppose I swich or see the 2 instances ? I have
open Entrerprise and I can't see the new instance?
I need to install from the CD others componentes like : Entreprise for the
new instances?
Thanks
Andrea
As far as the new instance is a "new server" ou have to register it within
the EM. Register the server with that naming convention
[NameoftheServer]\[InstanceName]. To list the available server you can issue
the following command at the command prompt: OSQL -L
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Colores" <Colores@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6BC321C2-4DF0-4B34-B018-5683536148C7@.microsoft.com...
> Hi, We have a SQL server and I have installed a new instance for some
> specific application database.
> The installation go sucessfully coped all files and I can see the 2
> instances on my Program Files folder and the 2 services running.
> My question is : How is suppose I swich or see the 2 instances ? I have
> open Entrerprise and I can't see the new instance?
> I need to install from the CD others componentes like : Entreprise for the
> new instances?
> Thanks
> Andrea
|||Hi,
No need to install the client components again. You could register the new
server name inside enterprise manager or in query analyzer you
could type the Hostname\sql servername (See the new sql server error logs
for the exact server name).
Thanks
Hari
SQL Server Mvp
"Colores" <Colores@.discussions.microsoft.com> wrote in message
news:6BC321C2-4DF0-4B34-B018-5683536148C7@.microsoft.com...
> Hi, We have a SQL server and I have installed a new instance for some
> specific application database.
> The installation go sucessfully coped all files and I can see the 2
> instances on my Program Files folder and the 2 services running.
> My question is : How is suppose I swich or see the 2 instances ? I have
> open Entrerprise and I can't see the new instance?
> I need to install from the CD others componentes like : Entreprise for the
> new instances?
> Thanks
> Andrea

creating a new database from .bak

How can I create a new instance of a database from a .BAK file?
I tried this to restore a .BAK file to a blank CCC database, didn't work.
RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE = N'SDXArchiver_
Log'
FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
GOIf you let us know the error message we are more likely to give help. My gue
ss is that the RESTORE
process tries to create the database files on locations that doesn't exist.
If that is the case,
check out the MOVE option of the restore command as well as RESTORE FILELIST
ONLY.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"andy" <ajgould@.longlines.com> wrote in message news:ODtGOxVIIHA.4228@.TK2MSFTNGP02.phx.gbl..
.
> How can I create a new instance of a database from a .BAK file?
> I tried this to restore a .BAK file to a blank CCC database, didn't work.
> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE = N'SDXArchive
r_Log' FROM DISK =
> N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
> GO
>|||Just specify a new database name in the RESTORE DATABASE clause:
RESTORE DATABASE [NEWNAME]
FROM DISK=N'C:\CCC\reporting.BAK'
"andy" wrote:

> How can I create a new instance of a database from a .BAK file?
> I tried this to restore a .BAK file to a blank CCC database, didn't work.
> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE = N'SDXArchive
r_Log'
> FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
> GO
>
>|||This is what I tried doing. Here is the error msg.
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'CCC'
database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"James Luetkehoelter" <JamesLuetkehoelter@.discussions.microsoft.com> wrote
in message news:840C39ED-C9F7-4BF0-8E17-4DA11ABEDBDC@.microsoft.com...[vbcol=seagreen]
> Just specify a new database name in the RESTORE DATABASE clause:
> RESTORE DATABASE [NEWNAME]
> FROM DISK=N'C:\CCC\reporting.BAK'
> "andy" wrote:
>|||Ok, I deleted the existing CCC database and tried to run the script again
and I got the following.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver.mdf" failed with the operating system error
3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'SDXArchiver_Data' cannot be restored to 'C:\Program Files\microsoft
sql server\MSSQL\data\SDXArchiver.mdf'. Use WITH MOVE to identify a valid
location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver_Log.ldf" failed with the operating system
error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'SDXArchiver_Log' cannot be restored to 'C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver_Log.ldf'. Use WITH MOVE to identify a valid
location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous
messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"andy" <ajgould@.longlines.com> wrote in message
news:O69b55kIIHA.1208@.TK2MSFTNGP05.phx.gbl...
> This is what I tried doing. Here is the error msg.
> Msg 3154, Level 16, State 4, Line 1
> The backup set holds a backup of a database other than the existing 'CCC'
> database.
> Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
> "James Luetkehoelter" <JamesLuetkehoelter@.discussions.microsoft.com> wrote
> in message news:840C39ED-C9F7-4BF0-8E17-4DA11ABEDBDC@.microsoft.com...
>|||Read up on RESTORE FILELISTONLY and the MOVE and REPLACE options to the REST
ORE command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"andy" <ajgould@.longlines.com> wrote in message news:%23Pizp9kIIHA.4808@.TK2MSFTNGP05.phx.gbl
..
> Ok, I deleted the existing CCC database and tried to run the script again
> and I got the following.
> Msg 5133, Level 16, State 1, Line 1
> Directory lookup for the file "C:\Program Files\microsoft sql
> server\MSSQL\data\SDXArchiver.mdf" failed with the operating system error
> 3(The system cannot find the path specified.).
> Msg 3156, Level 16, State 3, Line 1
> File 'SDXArchiver_Data' cannot be restored to 'C:\Program Files\microsoft
> sql server\MSSQL\data\SDXArchiver.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Msg 5133, Level 16, State 1, Line 1
> Directory lookup for the file "C:\Program Files\microsoft sql
> server\MSSQL\data\SDXArchiver_Log.ldf" failed with the operating system
> error 3(The system cannot find the path specified.).
> Msg 3156, Level 16, State 3, Line 1
> File 'SDXArchiver_Log' cannot be restored to 'C:\Program Files\microsoft s
ql
> server\MSSQL\data\SDXArchiver_Log.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Msg 3119, Level 16, State 1, Line 1
> Problems were identified while planning for the RESTORE statement. Previou
s
> messages provide details.
> Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
> "andy" <ajgould@.longlines.com> wrote in message
> news:O69b55kIIHA.1208@.TK2MSFTNGP05.phx.gbl...
>|||REPLACE did the trick! Thanks!
RESTORE DATABASE [CCC]
FROM DISK = N'C:\CCC\reporting.BAK'
WITH REPLACE
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:8CEE8BB4-30D9-4DBD-B71D-87DCEFBF716F@.microsoft.com...[vbcol=seagreen]
> Read up on RESTORE FILELISTONLY and the MOVE and REPLACE options to the
> RESTORE command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "andy" <ajgould@.longlines.com> wrote in message
> news:%23Pizp9kIIHA.4808@.TK2MSFTNGP05.phx.gbl...

creating a new database from .bak

How can I create a new instance of a database from a .BAK file?
I tried this to restore a .BAK file to a blank CCC database, didn't work.
RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE = N'SDXArchiver_Log'
FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
GO
Just specify a new database name in the RESTORE DATABASE clause:
RESTORE DATABASE [NEWNAME]
FROM DISK=N'C:\CCC\reporting.BAK'
"andy" wrote:

> How can I create a new instance of a database from a .BAK file?
> I tried this to restore a .BAK file to a blank CCC database, didn't work.
> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE = N'SDXArchiver_Log'
> FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
> GO
>
>
|||This is what I tried doing. Here is the error msg.
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'CCC'
database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"James Luetkehoelter" <JamesLuetkehoelter@.discussions.microsoft.com> wrote
in message news:840C39ED-C9F7-4BF0-8E17-4DA11ABEDBDC@.microsoft.com...[vbcol=seagreen]
> Just specify a new database name in the RESTORE DATABASE clause:
> RESTORE DATABASE [NEWNAME]
> FROM DISK=N'C:\CCC\reporting.BAK'
> "andy" wrote:
|||Ok, I deleted the existing CCC database and tried to run the script again
and I got the following.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver.mdf" failed with the operating system error
3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'SDXArchiver_Data' cannot be restored to 'C:\Program Files\microsoft
sql server\MSSQL\data\SDXArchiver.mdf'. Use WITH MOVE to identify a valid
location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver_Log.ldf" failed with the operating system
error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'SDXArchiver_Log' cannot be restored to 'C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver_Log.ldf'. Use WITH MOVE to identify a valid
location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous
messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"andy" <ajgould@.longlines.com> wrote in message
news:O69b55kIIHA.1208@.TK2MSFTNGP05.phx.gbl...
> This is what I tried doing. Here is the error msg.
> Msg 3154, Level 16, State 4, Line 1
> The backup set holds a backup of a database other than the existing 'CCC'
> database.
> Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
> "James Luetkehoelter" <JamesLuetkehoelter@.discussions.microsoft.com> wrote
> in message news:840C39ED-C9F7-4BF0-8E17-4DA11ABEDBDC@.microsoft.com...
>
|||REPLACE did the trick! Thanks!
RESTORE DATABASE [CCC]
FROM DISK = N'C:\CCC\reporting.BAK'
WITH REPLACE
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:8CEE8BB4-30D9-4DBD-B71D-87DCEFBF716F@.microsoft.com...[vbcol=seagreen]
> Read up on RESTORE FILELISTONLY and the MOVE and REPLACE options to the
> RESTORE command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "andy" <ajgould@.longlines.com> wrote in message
> news:%23Pizp9kIIHA.4808@.TK2MSFTNGP05.phx.gbl...

creating a new database from .bak

How can I create a new instance of a database from a .BAK file?
I tried this to restore a .BAK file to a blank CCC database, didn't work.
RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE = N'SDXArchiver_Log'
FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
GOIf you let us know the error message we are more likely to give help. My guess is that the RESTORE
process tries to create the database files on locations that doesn't exist. If that is the case,
check out the MOVE option of the restore command as well as RESTORE FILELISTONLY.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"andy" <ajgould@.longlines.com> wrote in message news:ODtGOxVIIHA.4228@.TK2MSFTNGP02.phx.gbl...
> How can I create a new instance of a database from a .BAK file?
> I tried this to restore a .BAK file to a blank CCC database, didn't work.
> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE = N'SDXArchiver_Log' FROM DISK => N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
> GO
>|||Just specify a new database name in the RESTORE DATABASE clause:
RESTORE DATABASE [NEWNAME]
FROM DISK=N'C:\CCC\reporting.BAK'
"andy" wrote:
> How can I create a new instance of a database from a .BAK file?
> I tried this to restore a .BAK file to a blank CCC database, didn't work.
> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE = N'SDXArchiver_Log'
> FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
> GO
>
>|||This is what I tried doing. Here is the error msg.
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'CCC'
database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"James Luetkehoelter" <JamesLuetkehoelter@.discussions.microsoft.com> wrote
in message news:840C39ED-C9F7-4BF0-8E17-4DA11ABEDBDC@.microsoft.com...
> Just specify a new database name in the RESTORE DATABASE clause:
> RESTORE DATABASE [NEWNAME]
> FROM DISK=N'C:\CCC\reporting.BAK'
> "andy" wrote:
>> How can I create a new instance of a database from a .BAK file?
>> I tried this to restore a .BAK file to a blank CCC database, didn't work.
>> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE =>> N'SDXArchiver_Log'
>> FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
>> GO
>>|||Ok, I deleted the existing CCC database and tried to run the script again
and I got the following.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver.mdf" failed with the operating system error
3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'SDXArchiver_Data' cannot be restored to 'C:\Program Files\microsoft
sql server\MSSQL\data\SDXArchiver.mdf'. Use WITH MOVE to identify a valid
location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver_Log.ldf" failed with the operating system
error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'SDXArchiver_Log' cannot be restored to 'C:\Program Files\microsoft sql
server\MSSQL\data\SDXArchiver_Log.ldf'. Use WITH MOVE to identify a valid
location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous
messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"andy" <ajgould@.longlines.com> wrote in message
news:O69b55kIIHA.1208@.TK2MSFTNGP05.phx.gbl...
> This is what I tried doing. Here is the error msg.
> Msg 3154, Level 16, State 4, Line 1
> The backup set holds a backup of a database other than the existing 'CCC'
> database.
> Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
> "James Luetkehoelter" <JamesLuetkehoelter@.discussions.microsoft.com> wrote
> in message news:840C39ED-C9F7-4BF0-8E17-4DA11ABEDBDC@.microsoft.com...
>> Just specify a new database name in the RESTORE DATABASE clause:
>> RESTORE DATABASE [NEWNAME]
>> FROM DISK=N'C:\CCC\reporting.BAK'
>> "andy" wrote:
>> How can I create a new instance of a database from a .BAK file?
>> I tried this to restore a .BAK file to a blank CCC database, didn't
>> work.
>> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE =>> N'SDXArchiver_Log'
>> FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
>> GO
>>
>|||Read up on RESTORE FILELISTONLY and the MOVE and REPLACE options to the RESTORE command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"andy" <ajgould@.longlines.com> wrote in message news:%23Pizp9kIIHA.4808@.TK2MSFTNGP05.phx.gbl...
> Ok, I deleted the existing CCC database and tried to run the script again
> and I got the following.
> Msg 5133, Level 16, State 1, Line 1
> Directory lookup for the file "C:\Program Files\microsoft sql
> server\MSSQL\data\SDXArchiver.mdf" failed with the operating system error
> 3(The system cannot find the path specified.).
> Msg 3156, Level 16, State 3, Line 1
> File 'SDXArchiver_Data' cannot be restored to 'C:\Program Files\microsoft
> sql server\MSSQL\data\SDXArchiver.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Msg 5133, Level 16, State 1, Line 1
> Directory lookup for the file "C:\Program Files\microsoft sql
> server\MSSQL\data\SDXArchiver_Log.ldf" failed with the operating system
> error 3(The system cannot find the path specified.).
> Msg 3156, Level 16, State 3, Line 1
> File 'SDXArchiver_Log' cannot be restored to 'C:\Program Files\microsoft sql
> server\MSSQL\data\SDXArchiver_Log.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Msg 3119, Level 16, State 1, Line 1
> Problems were identified while planning for the RESTORE statement. Previous
> messages provide details.
> Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
>
>
> "andy" <ajgould@.longlines.com> wrote in message
> news:O69b55kIIHA.1208@.TK2MSFTNGP05.phx.gbl...
>> This is what I tried doing. Here is the error msg.
>> Msg 3154, Level 16, State 4, Line 1
>> The backup set holds a backup of a database other than the existing 'CCC'
>> database.
>> Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>> "James Luetkehoelter" <JamesLuetkehoelter@.discussions.microsoft.com> wrote
>> in message news:840C39ED-C9F7-4BF0-8E17-4DA11ABEDBDC@.microsoft.com...
>> Just specify a new database name in the RESTORE DATABASE clause:
>> RESTORE DATABASE [NEWNAME]
>> FROM DISK=N'C:\CCC\reporting.BAK'
>> "andy" wrote:
>> How can I create a new instance of a database from a .BAK file?
>> I tried this to restore a .BAK file to a blank CCC database, didn't
>> work.
>> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE =>> N'SDXArchiver_Log'
>> FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS = 10
>> GO
>>
>>
>|||REPLACE did the trick! Thanks!
RESTORE DATABASE [CCC]
FROM DISK = N'C:\CCC\reporting.BAK'
WITH REPLACE
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:8CEE8BB4-30D9-4DBD-B71D-87DCEFBF716F@.microsoft.com...
> Read up on RESTORE FILELISTONLY and the MOVE and REPLACE options to the
> RESTORE command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "andy" <ajgould@.longlines.com> wrote in message
> news:%23Pizp9kIIHA.4808@.TK2MSFTNGP05.phx.gbl...
>> Ok, I deleted the existing CCC database and tried to run the script again
>> and I got the following.
>> Msg 5133, Level 16, State 1, Line 1
>> Directory lookup for the file "C:\Program Files\microsoft sql
>> server\MSSQL\data\SDXArchiver.mdf" failed with the operating system error
>> 3(The system cannot find the path specified.).
>> Msg 3156, Level 16, State 3, Line 1
>> File 'SDXArchiver_Data' cannot be restored to 'C:\Program Files\microsoft
>> sql server\MSSQL\data\SDXArchiver.mdf'. Use WITH MOVE to identify a valid
>> location for the file.
>> Msg 5133, Level 16, State 1, Line 1
>> Directory lookup for the file "C:\Program Files\microsoft sql
>> server\MSSQL\data\SDXArchiver_Log.ldf" failed with the operating system
>> error 3(The system cannot find the path specified.).
>> Msg 3156, Level 16, State 3, Line 1
>> File 'SDXArchiver_Log' cannot be restored to 'C:\Program Files\microsoft
>> sql server\MSSQL\data\SDXArchiver_Log.ldf'. Use WITH MOVE to identify a
>> valid location for the file.
>> Msg 3119, Level 16, State 1, Line 1
>> Problems were identified while planning for the RESTORE statement.
>> Previous messages provide details.
>> Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>> "andy" <ajgould@.longlines.com> wrote in message
>> news:O69b55kIIHA.1208@.TK2MSFTNGP05.phx.gbl...
>> This is what I tried doing. Here is the error msg.
>> Msg 3154, Level 16, State 4, Line 1
>> The backup set holds a backup of a database other than the existing
>> 'CCC' database.
>> Msg 3013, Level 16, State 1, Line 1
>> RESTORE DATABASE is terminating abnormally.
>>
>>
>> "James Luetkehoelter" <JamesLuetkehoelter@.discussions.microsoft.com>
>> wrote in message
>> news:840C39ED-C9F7-4BF0-8E17-4DA11ABEDBDC@.microsoft.com...
>> Just specify a new database name in the RESTORE DATABASE clause:
>> RESTORE DATABASE [NEWNAME]
>> FROM DISK=N'C:\CCC\reporting.BAK'
>> "andy" wrote:
>> How can I create a new instance of a database from a .BAK file?
>> I tried this to restore a .BAK file to a blank CCC database, didn't
>> work.
>> RESTORE DATABASE [CCC] FILE = N'SDXArchiver_Data', FILE =>> N'SDXArchiver_Log'
>> FROM DISK = N'C:\CCC\reporting.BAK' WITH FILE = 1, NOUNLOAD, STATS =>> 10
>> GO
>>
>>
>>

Creating a cached instance of a report for all variable values

I have a report that takes quite some time to render.
So I would like to create cached-instances of the report for each possible
variable value.
I suppose this is a rather common problem. Is there a solution (script,
program) available somwhere to do this?
(I've tried some things with the scripts but I can't get it to work, I keep
geeting "timed out' errors (although de report execution is set not to time
out) or security exeptions (althoug my user is a RS system user with all the
authoroty))
Thank youDid you ever figure out how to do this?
We thought that creating a data-driven subscription that dumped the report
to a file share when the report was setup to be cached would cache all
possible versions of the report, but we're finding that it's not caching
those executions and the report is being rendered on the first request.
Any thoughts?
Thx, Joel
"Antoon" <Antoon@.discussions.microsoft.com> wrote in message
news:CFFBE8A3-1C94-4FC7-8280-3F68E4ECD19F@.microsoft.com...
>I have a report that takes quite some time to render.
> So I would like to create cached-instances of the report for each possible
> variable value.
> I suppose this is a rather common problem. Is there a solution (script,
> program) available somwhere to do this?
> (I've tried some things with the scripts but I can't get it to work, I
> keep
> geeting "timed out' errors (although de report execution is set not to
> time
> out) or security exeptions (althoug my user is a RS system user with all
> the
> authoroty))
> Thank you|||I did, but it's a workaround. I've written a small programme in VB.net
that will take the name of the report and the parameters and that will
render the report in a web-window for each possible combination of the
parameters.
This does the trick, but it's not what you would call "elegant", I hope MS
will solve this in the next version.
"Joel Rumerman" wrote:
> Did you ever figure out how to do this?
> We thought that creating a data-driven subscription that dumped the report
> to a file share when the report was setup to be cached would cache all
> possible versions of the report, but we're finding that it's not caching
> those executions and the report is being rendered on the first request.
> Any thoughts?
> Thx, Joel
> "Antoon" <Antoon@.discussions.microsoft.com> wrote in message
> news:CFFBE8A3-1C94-4FC7-8280-3F68E4ECD19F@.microsoft.com...
> >I have a report that takes quite some time to render.
> > So I would like to create cached-instances of the report for each possible
> > variable value.
> > I suppose this is a rather common problem. Is there a solution (script,
> > program) available somwhere to do this?
> >
> > (I've tried some things with the scripts but I can't get it to work, I
> > keep
> > geeting "timed out' errors (although de report execution is set not to
> > time
> > out) or security exeptions (althoug my user is a RS system user with all
> > the
> > authoroty))
> >
> > Thank you
>
>

Creating a Bottleneck.

I’m using Benchmark factory (TPC-C) on a server that has 3 instances of SQL
Server. Each instance has between 1-3 databases on it. Have set min and max
server memory to 512MB.
What I want:
When the TPC-C transactions are executed I want them to create a memory
and a disk I/O bottleneck.
Apart from the above memory setting what else can I change so that it will
result in a I/O bottleneck?
Cheers!
sqlcatz
If the SQL instance only has 512MB, you almost always get a memory and/or I/O
bottleneck with TPC-C when you configure the number of warehouses to be
larger than 10 and include sufficient number of users. If you want to
increase the I/O load, you can reduce the ratios of the read-only
transactions (OrderStatus and StockLevel) in the transaction mix. If you
don't have a really fast I/O subsystem that has a lot of cache, you should
see I/O bottleneck as long as the ffective size of the test database is
significantly larger than the memory size.
Linchi
"SQLCatz" wrote:

> I’m using Benchmark factory (TPC-C) on a server that has 3 instances of SQL
> Server. Each instance has between 1-3 databases on it. Have set min and max
> server memory to 512MB.
> What I want:
> When the TPC-C transactions are executed I want them to create a memory
> and a disk I/O bottleneck.
> Apart from the above memory setting what else can I change so that it will
> result in a I/O bottleneck?
> Cheers!
> sqlcatz
>
|||Hello Linchi!
Thank you for the suggestion.
I tried it.
Apart from getting memory related errors (expected) - and lots of deadlocks
I dont get anything else. On checking the AvgDiskQueueLength - it's just
2.73. I was expecting a much higher value. What else can I do to get the
bottleneck?
Cheers!
sqlcatz

Creating a Bottleneck.

I’m using Benchmark factory (TPC-C) on a server that has 3 instances of SQ
L
Server. Each instance has between 1-3 databases on it. Have set min and max
server memory to 512MB.
What I want:
When the TPC-C transactions are executed I want them to create a memory
and a disk I/O bottleneck.
Apart from the above memory setting what else can I change so that it will
result in a I/O bottleneck?
Cheers!
sqlcatzIf the SQL instance only has 512MB, you almost always get a memory and/or I/
O
bottleneck with TPC-C when you configure the number of warehouses to be
larger than 10 and include sufficient number of users. If you want to
increase the I/O load, you can reduce the ratios of the read-only
transactions (OrderStatus and StockLevel) in the transaction mix. If you
don't have a really fast I/O subsystem that has a lot of cache, you should
see I/O bottleneck as long as the ffective size of the test database is
significantly larger than the memory size.
Linchi
"SQLCatz" wrote:

> I’m using Benchmark factory (TPC-C) on a server that has 3 instances of
SQL
> Server. Each instance has between 1-3 databases on it. Have set min and m
ax
> server memory to 512MB.
> What I want:
> When the TPC-C transactions are executed I want them to create a memory
> and a disk I/O bottleneck.
> Apart from the above memory setting what else can I change so that it will
> result in a I/O bottleneck?
> Cheers!
> sqlcatz
>|||Hello Linchi!
Thank you for the suggestion.
I tried it.
Apart from getting memory related errors (expected) - and lots of deadlocks
I dont get anything else. On checking the AvgDiskQueueLength - it's just
2.73. I was expecting a much higher value. What else can I do to get the
bottleneck?
Cheers!
sqlcatz

Creating a Bottleneck.

Iâ'm using Benchmark factory (TPC-C) on a server that has 3 instances of SQL
Server. Each instance has between 1-3 databases on it. Have set min and max
server memory to 512MB.
What I want:
When the TPC-C transactions are executed I want them to create a memory
and a disk I/O bottleneck.
Apart from the above memory setting what else can I change so that it will
result in a I/O bottleneck?
Cheers!
sqlcatzIf the SQL instance only has 512MB, you almost always get a memory and/or I/O
bottleneck with TPC-C when you configure the number of warehouses to be
larger than 10 and include sufficient number of users. If you want to
increase the I/O load, you can reduce the ratios of the read-only
transactions (OrderStatus and StockLevel) in the transaction mix. If you
don't have a really fast I/O subsystem that has a lot of cache, you should
see I/O bottleneck as long as the ffective size of the test database is
significantly larger than the memory size.
Linchi
"SQLCatz" wrote:
> Iâ'm using Benchmark factory (TPC-C) on a server that has 3 instances of SQL
> Server. Each instance has between 1-3 databases on it. Have set min and max
> server memory to 512MB.
> What I want:
> When the TPC-C transactions are executed I want them to create a memory
> and a disk I/O bottleneck.
> Apart from the above memory setting what else can I change so that it will
> result in a I/O bottleneck?
> Cheers!
> sqlcatz
>|||Hello Linchi!
Thank you for the suggestion.
I tried it.
Apart from getting memory related errors (expected) - and lots of deadlocks
I dont get anything else. On checking the AvgDiskQueueLength - it's just
2.73. I was expecting a much higher value. What else can I do to get the
bottleneck?
Cheers!
sqlcatz

Createing an instance on a Sql Server 2k installation.

I need to know if it is possible to create a Sql Server instance on top of an existing SQL Server 2k installation.

I am trying to mimic a production setup completely and the database is setup as an instance of a SQL server. By that I mean that we connect to the database by specifying <servername>\<instancename>.

I apologize if I have been ambiguous, or have used incorrect terminology. I am not a DBA and am trying to explain this the best way I know of.

Any help that anyone can provide is greatly appreciated!!

Sure, another instance can be easily installed by using the setup disk on choosing the named instance option along with the setup. If you have a default instance installed on the server, be aware that the named instance has another port than the default instance. You will have to specify the port during connection time in the syntax of ServerName\Instancename,Portnumer (whereas the instanceName is irgnored if you specified the portnumber, but for me this is for better reading and debugging).

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thank you for the reponse!

I will give that a try.

|||This did the trick! Many thanks!