Is it necessary to upgrade SQL Server version 7 to 2000?
Real question is that 'What's new in version 2000 from
version 7?'
Q. Is it necessary to upgrade SQL Server version 7 to 2000?
A. No, you can install a separate "named instance" on the same server as you
have SQL Server 7.0 installed.
Q. Real question is that 'What's new in version 2000 from version 7?'
A. If you're interested in just what is new in SQL Server 2000 Full-text
Search (as this is the topic of this newsgroup), then the answer is "Change
Tracking" with "Update Index in Background" as well as the ability to FT
Index and FT Search MS Office file type (doc, xls, etc. plus html) stored in
Image datatype columns. If you have SQL Server 2000 installed, you should
review the BOL under Contents and "What's New" as there are many
improvements in SQL Server 2000 over SQL Server 2000.
Regards,
John
"Jerry" <anonymous@.discussions.microsoft.com> wrote in message
news:1a1ac01c41d87$a2193d10$a401280a@.phx.gbl...
> Is it necessary to upgrade SQL Server version 7 to 2000?
> Real question is that 'What's new in version 2000 from
> version 7?'
Showing posts with label necessary. Show all posts
Showing posts with label necessary. Show all posts
Friday, March 9, 2012
Is it necessary to order again?
I have a function that returns a table:
CREATE FUNCTION dbo.Example(@.Param int)
RETURNS @.Tbl TABLE (
Field1 int,
Field2 int) AS
BEGIN
INSERT @.Tbl (Field1,Field2)
SELECT FieldA,FieldB FROM DataTable
WHERE FieldC = @.Param
ORDER BY FieldA
RETURN
END
The statement that populates the table orders the data. In order
to ensure the results are ordered that way, should the call to the
function include an ordering? I.e., is this sufficient
SELECT * FROM dbo.Example(17)
or is this necessary? --
SELECT * FROM dbo.Example(17) ORDER BY Field1
Thanks!"Jim Geissman" <jim_geissman@.countrywide.com> wrote in message
news:b84bf9dc.0408051457.6ae418c0@.posting.google.c om...
> I have a function that returns a table:
> CREATE FUNCTION dbo.Example(@.Param int)
> RETURNS @.Tbl TABLE (
> Field1 int,
> Field2 int) AS
> BEGIN
> INSERT @.Tbl (Field1,Field2)
> SELECT FieldA,FieldB FROM DataTable
> WHERE FieldC = @.Param
> ORDER BY FieldA
> RETURN
> END
> The statement that populates the table orders the data.
No, it doesn't. Tables are sets of data. They have no order.
Now, your statement may put the data into the table in order... but there's
no guarantee that SQL Server will store it in that order.
> In order
> to ensure the results are ordered that way, should the call to the
> function include an ordering? I.e., is this sufficient
> SELECT * FROM dbo.Example(17)
No
> or is this necessary? --
> SELECT * FROM dbo.Example(17) ORDER BY Field1
Yes.
> Thanks!
Is it necessary to install Intergration Service for different instance ?
We have to install another instance to an existing SQL Server 2005 Server.
We would like to know whether it is necessary for us to select Integration
Service ? Besides, we would like to know besides Database Engine, is there
any other service we have to select ?
Moreover, we find that Reporting Services is shown as an instance when we
view "Installed Instance", we would like to know why it behaves as an
instance ?
In addition, it seems that even though we have installed default instance,
SQL Server 2005 still gives us a choice of installing Default Instance.
What will happen if we choose "Default Instance" if there is already have
one ? In SQL Server 2000, the choice of Default Instance is disabled.
Thanks
Peter> We would like to know whether it is necessary for us to select Integration Service ?
You can only have one instance of SSIS (which will serve all database engine instance that need to
use it). So, if SSIS is already installed and you select to install it again, setup will tell you
that it is already installed.
> Besides, we would like to know besides Database Engine, is there any other service we have to
> select ?
Not really. But only you know if you after installing this instance need also, say SSAS.
> Moreover, we find that Reporting Services is shown as an instance when we view "Installed
> Instance", we would like to know why it behaves as an instance ?
Because you can have several instances of RS, just the same way as you can have several instances of
the database engine.
> In addition, it seems that even though we have installed default instance, SQL Server 2005 still
> gives us a choice of installing Default Instance. What will happen if we choose "Default Instance"
> if there is already have one ?
Setup will tell you that it already is installed and won't do anything.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:e9v0AnyCIHA.4956@.TK2MSFTNGP06.phx.gbl...
> We have to install another instance to an existing SQL Server 2005 Server. We would like to know
> whether it is necessary for us to select Integration Service ? Besides, we would like to know
> besides Database Engine, is there any other service we have to select ?
> Moreover, we find that Reporting Services is shown as an instance when we view "Installed
> Instance", we would like to know why it behaves as an instance ?
> In addition, it seems that even though we have installed default instance, SQL Server 2005 still
> gives us a choice of installing Default Instance. What will happen if we choose "Default Instance"
> if there is already have one ? In SQL Server 2000, the choice of Default Instance is disabled.
> Thanks
> Peter
>|||Dear Tibor,
From your mail, my understanding is that for SSIS, only 1 instance can be
installed.
On the other hand, for others - like RS, AS, Database Engine, we can install
more than 1 instance.
Is there any other services that only installed once - Like Notification
Services ... ?
Peter
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uZ9QyvzCIHA.5328@.TK2MSFTNGP05.phx.gbl...
>> We would like to know whether it is necessary for us to select
>> Integration Service ?
> You can only have one instance of SSIS (which will serve all database
> engine instance that need to use it). So, if SSIS is already installed and
> you select to install it again, setup will tell you that it is already
> installed.
>> Besides, we would like to know besides Database Engine, is there any
>> other service we have to select ?
> Not really. But only you know if you after installing this instance need
> also, say SSAS.
>> Moreover, we find that Reporting Services is shown as an instance when we
>> view "Installed Instance", we would like to know why it behaves as an
>> instance ?
> Because you can have several instances of RS, just the same way as you can
> have several instances of the database engine.
>
>> In addition, it seems that even though we have installed default
>> instance, SQL Server 2005 still gives us a choice of installing Default
>> Instance. What will happen if we choose "Default Instance" if there is
>> already have one ?
> Setup will tell you that it already is installed and won't do anything.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:e9v0AnyCIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> We have to install another instance to an existing SQL Server 2005
>> Server. We would like to know whether it is necessary for us to select
>> Integration Service ? Besides, we would like to know besides Database
>> Engine, is there any other service we have to select ?
>> Moreover, we find that Reporting Services is shown as an instance when we
>> view "Installed Instance", we would like to know why it behaves as an
>> instance ?
>> In addition, it seems that even though we have installed default
>> instance, SQL Server 2005 still gives us a choice of installing Default
>> Instance. What will happen if we choose "Default Instance" if there is
>> already have one ? In SQL Server 2000, the choice of Default Instance is
>> disabled.
>> Thanks
>> Peter
>>
>|||Peter,
> From your mail, my understanding is that for SSIS, only 1 instance can be installed.
Correct.
> On the other hand, for others - like RS, AS, Database Engine, we can install more than 1 instance.
Also correct.
> Is there any other services that only installed once - Like Notification Services ... ?
Actually RS, AS and Db Engine are the only services for which you can install several instances.
You can only have one SQL Server browser - it doesn't make sense to have several.
You can only have one SQL Server VSS Writer - it doesn't make sense to have several.
You can only have one SSIS service
As for Notification Services (NS), you can only install it once. But you need to read about NS to
understand what that means. Installation of NS only installs some binary files (essentially). When
you develop an NS solution, you (among other things) run a program (NSCONTROL.EXE) to create the
Windows service. You can have several of these services, but that part is something you do *after*
you have installed the binary files. Also, NS will not ship with 2008, so it is essentially a dead
component which you probably don't want to build new solutions on.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:ez0wn7%23CIHA.4308@.TK2MSFTNGP06.phx.gbl...
> Dear Tibor,
> From your mail, my understanding is that for SSIS, only 1 instance can be installed.
> On the other hand, for others - like RS, AS, Database Engine, we can install more than 1 instance.
> Is there any other services that only installed once - Like Notification Services ... ?
> Peter
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:uZ9QyvzCIHA.5328@.TK2MSFTNGP05.phx.gbl...
>> We would like to know whether it is necessary for us to select Integration Service ?
>> You can only have one instance of SSIS (which will serve all database engine instance that need
>> to use it). So, if SSIS is already installed and you select to install it again, setup will tell
>> you that it is already installed.
>> Besides, we would like to know besides Database Engine, is there any other service we have to
>> select ?
>> Not really. But only you know if you after installing this instance need also, say SSAS.
>> Moreover, we find that Reporting Services is shown as an instance when we view "Installed
>> Instance", we would like to know why it behaves as an instance ?
>> Because you can have several instances of RS, just the same way as you can have several instances
>> of the database engine.
>>
>> In addition, it seems that even though we have installed default instance, SQL Server 2005 still
>> gives us a choice of installing Default Instance. What will happen if we choose "Default
>> Instance" if there is already have one ?
>> Setup will tell you that it already is installed and won't do anything.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Peter" <Peter@.discussions.microsoft.com> wrote in message
>> news:e9v0AnyCIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> We have to install another instance to an existing SQL Server 2005 Server. We would like to know
>> whether it is necessary for us to select Integration Service ? Besides, we would like to know
>> besides Database Engine, is there any other service we have to select ?
>> Moreover, we find that Reporting Services is shown as an instance when we view "Installed
>> Instance", we would like to know why it behaves as an instance ?
>> In addition, it seems that even though we have installed default instance, SQL Server 2005 still
>> gives us a choice of installing Default Instance. What will happen if we choose "Default
>> Instance" if there is already have one ? In SQL Server 2000, the choice of Default Instance is
>> disabled.
>> Thanks
>> Peter
>>
>>
>
We would like to know whether it is necessary for us to select Integration
Service ? Besides, we would like to know besides Database Engine, is there
any other service we have to select ?
Moreover, we find that Reporting Services is shown as an instance when we
view "Installed Instance", we would like to know why it behaves as an
instance ?
In addition, it seems that even though we have installed default instance,
SQL Server 2005 still gives us a choice of installing Default Instance.
What will happen if we choose "Default Instance" if there is already have
one ? In SQL Server 2000, the choice of Default Instance is disabled.
Thanks
Peter> We would like to know whether it is necessary for us to select Integration Service ?
You can only have one instance of SSIS (which will serve all database engine instance that need to
use it). So, if SSIS is already installed and you select to install it again, setup will tell you
that it is already installed.
> Besides, we would like to know besides Database Engine, is there any other service we have to
> select ?
Not really. But only you know if you after installing this instance need also, say SSAS.
> Moreover, we find that Reporting Services is shown as an instance when we view "Installed
> Instance", we would like to know why it behaves as an instance ?
Because you can have several instances of RS, just the same way as you can have several instances of
the database engine.
> In addition, it seems that even though we have installed default instance, SQL Server 2005 still
> gives us a choice of installing Default Instance. What will happen if we choose "Default Instance"
> if there is already have one ?
Setup will tell you that it already is installed and won't do anything.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:e9v0AnyCIHA.4956@.TK2MSFTNGP06.phx.gbl...
> We have to install another instance to an existing SQL Server 2005 Server. We would like to know
> whether it is necessary for us to select Integration Service ? Besides, we would like to know
> besides Database Engine, is there any other service we have to select ?
> Moreover, we find that Reporting Services is shown as an instance when we view "Installed
> Instance", we would like to know why it behaves as an instance ?
> In addition, it seems that even though we have installed default instance, SQL Server 2005 still
> gives us a choice of installing Default Instance. What will happen if we choose "Default Instance"
> if there is already have one ? In SQL Server 2000, the choice of Default Instance is disabled.
> Thanks
> Peter
>|||Dear Tibor,
From your mail, my understanding is that for SSIS, only 1 instance can be
installed.
On the other hand, for others - like RS, AS, Database Engine, we can install
more than 1 instance.
Is there any other services that only installed once - Like Notification
Services ... ?
Peter
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uZ9QyvzCIHA.5328@.TK2MSFTNGP05.phx.gbl...
>> We would like to know whether it is necessary for us to select
>> Integration Service ?
> You can only have one instance of SSIS (which will serve all database
> engine instance that need to use it). So, if SSIS is already installed and
> you select to install it again, setup will tell you that it is already
> installed.
>> Besides, we would like to know besides Database Engine, is there any
>> other service we have to select ?
> Not really. But only you know if you after installing this instance need
> also, say SSAS.
>> Moreover, we find that Reporting Services is shown as an instance when we
>> view "Installed Instance", we would like to know why it behaves as an
>> instance ?
> Because you can have several instances of RS, just the same way as you can
> have several instances of the database engine.
>
>> In addition, it seems that even though we have installed default
>> instance, SQL Server 2005 still gives us a choice of installing Default
>> Instance. What will happen if we choose "Default Instance" if there is
>> already have one ?
> Setup will tell you that it already is installed and won't do anything.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:e9v0AnyCIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> We have to install another instance to an existing SQL Server 2005
>> Server. We would like to know whether it is necessary for us to select
>> Integration Service ? Besides, we would like to know besides Database
>> Engine, is there any other service we have to select ?
>> Moreover, we find that Reporting Services is shown as an instance when we
>> view "Installed Instance", we would like to know why it behaves as an
>> instance ?
>> In addition, it seems that even though we have installed default
>> instance, SQL Server 2005 still gives us a choice of installing Default
>> Instance. What will happen if we choose "Default Instance" if there is
>> already have one ? In SQL Server 2000, the choice of Default Instance is
>> disabled.
>> Thanks
>> Peter
>>
>|||Peter,
> From your mail, my understanding is that for SSIS, only 1 instance can be installed.
Correct.
> On the other hand, for others - like RS, AS, Database Engine, we can install more than 1 instance.
Also correct.
> Is there any other services that only installed once - Like Notification Services ... ?
Actually RS, AS and Db Engine are the only services for which you can install several instances.
You can only have one SQL Server browser - it doesn't make sense to have several.
You can only have one SQL Server VSS Writer - it doesn't make sense to have several.
You can only have one SSIS service
As for Notification Services (NS), you can only install it once. But you need to read about NS to
understand what that means. Installation of NS only installs some binary files (essentially). When
you develop an NS solution, you (among other things) run a program (NSCONTROL.EXE) to create the
Windows service. You can have several of these services, but that part is something you do *after*
you have installed the binary files. Also, NS will not ship with 2008, so it is essentially a dead
component which you probably don't want to build new solutions on.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:ez0wn7%23CIHA.4308@.TK2MSFTNGP06.phx.gbl...
> Dear Tibor,
> From your mail, my understanding is that for SSIS, only 1 instance can be installed.
> On the other hand, for others - like RS, AS, Database Engine, we can install more than 1 instance.
> Is there any other services that only installed once - Like Notification Services ... ?
> Peter
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:uZ9QyvzCIHA.5328@.TK2MSFTNGP05.phx.gbl...
>> We would like to know whether it is necessary for us to select Integration Service ?
>> You can only have one instance of SSIS (which will serve all database engine instance that need
>> to use it). So, if SSIS is already installed and you select to install it again, setup will tell
>> you that it is already installed.
>> Besides, we would like to know besides Database Engine, is there any other service we have to
>> select ?
>> Not really. But only you know if you after installing this instance need also, say SSAS.
>> Moreover, we find that Reporting Services is shown as an instance when we view "Installed
>> Instance", we would like to know why it behaves as an instance ?
>> Because you can have several instances of RS, just the same way as you can have several instances
>> of the database engine.
>>
>> In addition, it seems that even though we have installed default instance, SQL Server 2005 still
>> gives us a choice of installing Default Instance. What will happen if we choose "Default
>> Instance" if there is already have one ?
>> Setup will tell you that it already is installed and won't do anything.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Peter" <Peter@.discussions.microsoft.com> wrote in message
>> news:e9v0AnyCIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> We have to install another instance to an existing SQL Server 2005 Server. We would like to know
>> whether it is necessary for us to select Integration Service ? Besides, we would like to know
>> besides Database Engine, is there any other service we have to select ?
>> Moreover, we find that Reporting Services is shown as an instance when we view "Installed
>> Instance", we would like to know why it behaves as an instance ?
>> In addition, it seems that even though we have installed default instance, SQL Server 2005 still
>> gives us a choice of installing Default Instance. What will happen if we choose "Default
>> Instance" if there is already have one ? In SQL Server 2000, the choice of Default Instance is
>> disabled.
>> Thanks
>> Peter
>>
>>
>
Is it necessary to exclude the \data folder when using NetBackup?
I am not a big fan of paying 3rd party backup vendors for
agents, but I need to make sure that we are not risking
corrupting the database files. I have setup maintenance
plans to do the fulls and log backups to disk. We are just
beginning to roll out NetBackup 5.0 in production, and
without the SQL agent installed, it appears as though it
can backup all the data files without error. Should I
exclude the "hot files" in NetBackup, and rely on the bak
and trn files if I need to restore the whole server?
Meaning, if my prod server died, and I needed to restore
from tape to a hotspare, is it possible to restore the
database(s) if the mssql\data\*.mdf and ldf files are not
restored?
If this is a lame question, I apologize, as I am not a
DBA, but a storage guy, and we have no official SQL DBA's
in house yet.
Thanks for any and all help!
DaveYes, you want to avoid trying to back up the mdf and ldf files and instead
just back up the native SQL backup files (trn/bak) to tape. You would use
these to restore the database. BOL has plenty of detail on backup and
restore in the Administering SQL Server>Backing Up and Restoring Databases
section
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
> I am not a big fan of paying 3rd party backup vendors for
> agents, but I need to make sure that we are not risking
> corrupting the database files. I have setup maintenance
> plans to do the fulls and log backups to disk. We are just
> beginning to roll out NetBackup 5.0 in production, and
> without the SQL agent installed, it appears as though it
> can backup all the data files without error. Should I
> exclude the "hot files" in NetBackup, and rely on the bak
> and trn files if I need to restore the whole server?
> Meaning, if my prod server died, and I needed to restore
> from tape to a hotspare, is it possible to restore the
> database(s) if the mssql\data\*.mdf and ldf files are not
> restored?
> If this is a lame question, I apologize, as I am not a
> DBA, but a storage guy, and we have no official SQL DBA's
> in house yet.
> Thanks for any and all help!
> Dave
>
>|||Yes, I was planning on keeping the maintenance plan. I was
not sure if it is possible to restore the trn\bak files if
real SQL server datafiles were not restored (ie excluding
the \data\*.* in NetBackup policy). Is there some command
line you can run to start SQL enough to restore the files?
I've looked in the online help, but I must be missing the
obvious. What is BOL?
thanks!
>--Original Message--
>Yes, you want to avoid trying to back up the mdf and ldf
files and instead
>just back up the native SQL backup files (trn/bak) to
tape. You would use
>these to restore the database. BOL has plenty of detail
on backup and
>restore in the Administering SQL Server>Backing Up and
Restoring Databases
>section
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
>news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
for
just
bak
not
DBA's
>
>.
>|||> Is there some command
> line you can run to start SQL enough to restore the files?
?
When you do a RESTORE in SQL Server, the database is created, if it doesn't
exists. If a system database is broken, you need to use REBUILDM.EXE to
create new system databases so that you can start SQL Server and then do the
restore. If the whole installation is toast, you need to install SQL Server
first instead. :-)
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:2ad501c3fcb0$61c267c0$a001280a@.phx.gbl...
> Yes, I was planning on keeping the maintenance plan. I was
> not sure if it is possible to restore the trn\bak files if
> real SQL server datafiles were not restored (ie excluding
> the \data\*.* in NetBackup policy). Is there some command
> line you can run to start SQL enough to restore the files?
> I've looked in the online help, but I must be missing the
> obvious. What is BOL?
> thanks!
>
> files and instead
> tape. You would use
> on backup and
> Restoring Databases
> message
> for
> just
> bak
> not
> DBA's
agents, but I need to make sure that we are not risking
corrupting the database files. I have setup maintenance
plans to do the fulls and log backups to disk. We are just
beginning to roll out NetBackup 5.0 in production, and
without the SQL agent installed, it appears as though it
can backup all the data files without error. Should I
exclude the "hot files" in NetBackup, and rely on the bak
and trn files if I need to restore the whole server?
Meaning, if my prod server died, and I needed to restore
from tape to a hotspare, is it possible to restore the
database(s) if the mssql\data\*.mdf and ldf files are not
restored?
If this is a lame question, I apologize, as I am not a
DBA, but a storage guy, and we have no official SQL DBA's
in house yet.
Thanks for any and all help!
DaveYes, you want to avoid trying to back up the mdf and ldf files and instead
just back up the native SQL backup files (trn/bak) to tape. You would use
these to restore the database. BOL has plenty of detail on backup and
restore in the Administering SQL Server>Backing Up and Restoring Databases
section
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
> I am not a big fan of paying 3rd party backup vendors for
> agents, but I need to make sure that we are not risking
> corrupting the database files. I have setup maintenance
> plans to do the fulls and log backups to disk. We are just
> beginning to roll out NetBackup 5.0 in production, and
> without the SQL agent installed, it appears as though it
> can backup all the data files without error. Should I
> exclude the "hot files" in NetBackup, and rely on the bak
> and trn files if I need to restore the whole server?
> Meaning, if my prod server died, and I needed to restore
> from tape to a hotspare, is it possible to restore the
> database(s) if the mssql\data\*.mdf and ldf files are not
> restored?
> If this is a lame question, I apologize, as I am not a
> DBA, but a storage guy, and we have no official SQL DBA's
> in house yet.
> Thanks for any and all help!
> Dave
>
>|||Yes, I was planning on keeping the maintenance plan. I was
not sure if it is possible to restore the trn\bak files if
real SQL server datafiles were not restored (ie excluding
the \data\*.* in NetBackup policy). Is there some command
line you can run to start SQL enough to restore the files?
I've looked in the online help, but I must be missing the
obvious. What is BOL?
thanks!
>--Original Message--
>Yes, you want to avoid trying to back up the mdf and ldf
files and instead
>just back up the native SQL backup files (trn/bak) to
tape. You would use
>these to restore the database. BOL has plenty of detail
on backup and
>restore in the Administering SQL Server>Backing Up and
Restoring Databases
>section
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
>news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
for
just
bak
not
DBA's
>
>.
>|||> Is there some command
> line you can run to start SQL enough to restore the files?
?
When you do a RESTORE in SQL Server, the database is created, if it doesn't
exists. If a system database is broken, you need to use REBUILDM.EXE to
create new system databases so that you can start SQL Server and then do the
restore. If the whole installation is toast, you need to install SQL Server
first instead. :-)
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:2ad501c3fcb0$61c267c0$a001280a@.phx.gbl...
> Yes, I was planning on keeping the maintenance plan. I was
> not sure if it is possible to restore the trn\bak files if
> real SQL server datafiles were not restored (ie excluding
> the \data\*.* in NetBackup policy). Is there some command
> line you can run to start SQL enough to restore the files?
> I've looked in the online help, but I must be missing the
> obvious. What is BOL?
> thanks!
>
> files and instead
> tape. You would use
> on backup and
> Restoring Databases
> message
> for
> just
> bak
> not
> DBA's
Is it necessary to exclude the \data folder when using NetBackup?
I am not a big fan of paying 3rd party backup vendors for
agents, but I need to make sure that we are not risking
corrupting the database files. I have setup maintenance
plans to do the fulls and log backups to disk. We are just
beginning to roll out NetBackup 5.0 in production, and
without the SQL agent installed, it appears as though it
can backup all the data files without error. Should I
exclude the "hot files" in NetBackup, and rely on the bak
and trn files if I need to restore the whole server?
Meaning, if my prod server died, and I needed to restore
from tape to a hotspare, is it possible to restore the
database(s) if the mssql\data\*.mdf and ldf files are not
restored?
If this is a lame question, I apologize, as I am not a
DBA, but a storage guy, and we have no official SQL DBA's
in house yet.
Thanks for any and all help!
DaveYou must do sql backups using maintenance plan or using
SQL Agent. Make sure to backup bak and trn files on tape
if you use maintenance plan. You should not rely on "hot
files" backup in NebBackup because it doesn't always work
in case of sql files. SQL backups (through a maintenance
plan or NetBackup sql agent) is the only reliable way to
restore sql databases.
I would advise against doing backup of \data folder,
specially if backup window is limited.
hth.
>--Original Message--
>I am not a big fan of paying 3rd party backup vendors for
>agents, but I need to make sure that we are not risking
>corrupting the database files. I have setup maintenance
>plans to do the fulls and log backups to disk. We are
just
>beginning to roll out NetBackup 5.0 in production, and
>without the SQL agent installed, it appears as though it
>can backup all the data files without error. Should I
>exclude the "hot files" in NetBackup, and rely on the bak
>and trn files if I need to restore the whole server?
>Meaning, if my prod server died, and I needed to restore
>from tape to a hotspare, is it possible to restore the
>database(s) if the mssql\data\*.mdf and ldf files are not
>restored?
>If this is a lame question, I apologize, as I am not a
>DBA, but a storage guy, and we have no official SQL DBA's
>in house yet.
>Thanks for any and all help!
>Dave
>
>.
>|||Yes, you want to avoid trying to back up the mdf and ldf files and instead
just back up the native SQL backup files (trn/bak) to tape. You would use
these to restore the database. BOL has plenty of detail on backup and
restore in the Administering SQL Server>Backing Up and Restoring Databases
section
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
> I am not a big fan of paying 3rd party backup vendors for
> agents, but I need to make sure that we are not risking
> corrupting the database files. I have setup maintenance
> plans to do the fulls and log backups to disk. We are just
> beginning to roll out NetBackup 5.0 in production, and
> without the SQL agent installed, it appears as though it
> can backup all the data files without error. Should I
> exclude the "hot files" in NetBackup, and rely on the bak
> and trn files if I need to restore the whole server?
> Meaning, if my prod server died, and I needed to restore
> from tape to a hotspare, is it possible to restore the
> database(s) if the mssql\data\*.mdf and ldf files are not
> restored?
> If this is a lame question, I apologize, as I am not a
> DBA, but a storage guy, and we have no official SQL DBA's
> in house yet.
> Thanks for any and all help!
> Dave
>
>|||Yes, I was planning on keeping the maintenance plan. I was
not sure if it is possible to restore the trn\bak files if
real SQL server datafiles were not restored (ie excluding
the \data\*.* in NetBackup policy). Is there some command
line you can run to start SQL enough to restore the files?
I've looked in the online help, but I must be missing the
obvious. What is BOL?
thanks!
>--Original Message--
>Yes, you want to avoid trying to back up the mdf and ldf
files and instead
>just back up the native SQL backup files (trn/bak) to
tape. You would use
>these to restore the database. BOL has plenty of detail
on backup and
>restore in the Administering SQL Server>Backing Up and
Restoring Databases
>section
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
>news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
>> I am not a big fan of paying 3rd party backup vendors
for
>> agents, but I need to make sure that we are not risking
>> corrupting the database files. I have setup maintenance
>> plans to do the fulls and log backups to disk. We are
just
>> beginning to roll out NetBackup 5.0 in production, and
>> without the SQL agent installed, it appears as though it
>> can backup all the data files without error. Should I
>> exclude the "hot files" in NetBackup, and rely on the
bak
>> and trn files if I need to restore the whole server?
>> Meaning, if my prod server died, and I needed to restore
>> from tape to a hotspare, is it possible to restore the
>> database(s) if the mssql\data\*.mdf and ldf files are
not
>> restored?
>> If this is a lame question, I apologize, as I am not a
>> DBA, but a storage guy, and we have no official SQL
DBA's
>> in house yet.
>> Thanks for any and all help!
>> Dave
>>
>
>.
>|||> Is there some command
> line you can run to start SQL enough to restore the files?
?
When you do a RESTORE in SQL Server, the database is created, if it doesn't
exists. If a system database is broken, you need to use REBUILDM.EXE to
create new system databases so that you can start SQL Server and then do the
restore. If the whole installation is toast, you need to install SQL Server
first instead. :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:2ad501c3fcb0$61c267c0$a001280a@.phx.gbl...
> Yes, I was planning on keeping the maintenance plan. I was
> not sure if it is possible to restore the trn\bak files if
> real SQL server datafiles were not restored (ie excluding
> the \data\*.* in NetBackup policy). Is there some command
> line you can run to start SQL enough to restore the files?
> I've looked in the online help, but I must be missing the
> obvious. What is BOL?
> thanks!
> >--Original Message--
> >Yes, you want to avoid trying to back up the mdf and ldf
> files and instead
> >just back up the native SQL backup files (trn/bak) to
> tape. You would use
> >these to restore the database. BOL has plenty of detail
> on backup and
> >restore in the Administering SQL Server>Backing Up and
> Restoring Databases
> >section
> >
> >--
> >HTH
> >
> >Jasper Smith (SQL Server MVP)
> >
> >I support PASS - the definitive, global
> >community for SQL Server professionals -
> >http://www.sqlpass.org
> >
> >
> >"Dave" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
> >> I am not a big fan of paying 3rd party backup vendors
> for
> >> agents, but I need to make sure that we are not risking
> >> corrupting the database files. I have setup maintenance
> >> plans to do the fulls and log backups to disk. We are
> just
> >> beginning to roll out NetBackup 5.0 in production, and
> >> without the SQL agent installed, it appears as though it
> >> can backup all the data files without error. Should I
> >> exclude the "hot files" in NetBackup, and rely on the
> bak
> >> and trn files if I need to restore the whole server?
> >> Meaning, if my prod server died, and I needed to restore
> >> from tape to a hotspare, is it possible to restore the
> >> database(s) if the mssql\data\*.mdf and ldf files are
> not
> >> restored?
> >> If this is a lame question, I apologize, as I am not a
> >> DBA, but a storage guy, and we have no official SQL
> DBA's
> >> in house yet.
> >> Thanks for any and all help!
> >>
> >> Dave
> >>
> >>
> >>
> >
> >
> >.
> >
agents, but I need to make sure that we are not risking
corrupting the database files. I have setup maintenance
plans to do the fulls and log backups to disk. We are just
beginning to roll out NetBackup 5.0 in production, and
without the SQL agent installed, it appears as though it
can backup all the data files without error. Should I
exclude the "hot files" in NetBackup, and rely on the bak
and trn files if I need to restore the whole server?
Meaning, if my prod server died, and I needed to restore
from tape to a hotspare, is it possible to restore the
database(s) if the mssql\data\*.mdf and ldf files are not
restored?
If this is a lame question, I apologize, as I am not a
DBA, but a storage guy, and we have no official SQL DBA's
in house yet.
Thanks for any and all help!
DaveYou must do sql backups using maintenance plan or using
SQL Agent. Make sure to backup bak and trn files on tape
if you use maintenance plan. You should not rely on "hot
files" backup in NebBackup because it doesn't always work
in case of sql files. SQL backups (through a maintenance
plan or NetBackup sql agent) is the only reliable way to
restore sql databases.
I would advise against doing backup of \data folder,
specially if backup window is limited.
hth.
>--Original Message--
>I am not a big fan of paying 3rd party backup vendors for
>agents, but I need to make sure that we are not risking
>corrupting the database files. I have setup maintenance
>plans to do the fulls and log backups to disk. We are
just
>beginning to roll out NetBackup 5.0 in production, and
>without the SQL agent installed, it appears as though it
>can backup all the data files without error. Should I
>exclude the "hot files" in NetBackup, and rely on the bak
>and trn files if I need to restore the whole server?
>Meaning, if my prod server died, and I needed to restore
>from tape to a hotspare, is it possible to restore the
>database(s) if the mssql\data\*.mdf and ldf files are not
>restored?
>If this is a lame question, I apologize, as I am not a
>DBA, but a storage guy, and we have no official SQL DBA's
>in house yet.
>Thanks for any and all help!
>Dave
>
>.
>|||Yes, you want to avoid trying to back up the mdf and ldf files and instead
just back up the native SQL backup files (trn/bak) to tape. You would use
these to restore the database. BOL has plenty of detail on backup and
restore in the Administering SQL Server>Backing Up and Restoring Databases
section
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
> I am not a big fan of paying 3rd party backup vendors for
> agents, but I need to make sure that we are not risking
> corrupting the database files. I have setup maintenance
> plans to do the fulls and log backups to disk. We are just
> beginning to roll out NetBackup 5.0 in production, and
> without the SQL agent installed, it appears as though it
> can backup all the data files without error. Should I
> exclude the "hot files" in NetBackup, and rely on the bak
> and trn files if I need to restore the whole server?
> Meaning, if my prod server died, and I needed to restore
> from tape to a hotspare, is it possible to restore the
> database(s) if the mssql\data\*.mdf and ldf files are not
> restored?
> If this is a lame question, I apologize, as I am not a
> DBA, but a storage guy, and we have no official SQL DBA's
> in house yet.
> Thanks for any and all help!
> Dave
>
>|||Yes, I was planning on keeping the maintenance plan. I was
not sure if it is possible to restore the trn\bak files if
real SQL server datafiles were not restored (ie excluding
the \data\*.* in NetBackup policy). Is there some command
line you can run to start SQL enough to restore the files?
I've looked in the online help, but I must be missing the
obvious. What is BOL?
thanks!
>--Original Message--
>Yes, you want to avoid trying to back up the mdf and ldf
files and instead
>just back up the native SQL backup files (trn/bak) to
tape. You would use
>these to restore the database. BOL has plenty of detail
on backup and
>restore in the Administering SQL Server>Backing Up and
Restoring Databases
>section
>--
>HTH
>Jasper Smith (SQL Server MVP)
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Dave" <anonymous@.discussions.microsoft.com> wrote in
message
>news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
>> I am not a big fan of paying 3rd party backup vendors
for
>> agents, but I need to make sure that we are not risking
>> corrupting the database files. I have setup maintenance
>> plans to do the fulls and log backups to disk. We are
just
>> beginning to roll out NetBackup 5.0 in production, and
>> without the SQL agent installed, it appears as though it
>> can backup all the data files without error. Should I
>> exclude the "hot files" in NetBackup, and rely on the
bak
>> and trn files if I need to restore the whole server?
>> Meaning, if my prod server died, and I needed to restore
>> from tape to a hotspare, is it possible to restore the
>> database(s) if the mssql\data\*.mdf and ldf files are
not
>> restored?
>> If this is a lame question, I apologize, as I am not a
>> DBA, but a storage guy, and we have no official SQL
DBA's
>> in house yet.
>> Thanks for any and all help!
>> Dave
>>
>
>.
>|||> Is there some command
> line you can run to start SQL enough to restore the files?
?
When you do a RESTORE in SQL Server, the database is created, if it doesn't
exists. If a system database is broken, you need to use REBUILDM.EXE to
create new system databases so that you can start SQL Server and then do the
restore. If the whole installation is toast, you need to install SQL Server
first instead. :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:2ad501c3fcb0$61c267c0$a001280a@.phx.gbl...
> Yes, I was planning on keeping the maintenance plan. I was
> not sure if it is possible to restore the trn\bak files if
> real SQL server datafiles were not restored (ie excluding
> the \data\*.* in NetBackup policy). Is there some command
> line you can run to start SQL enough to restore the files?
> I've looked in the online help, but I must be missing the
> obvious. What is BOL?
> thanks!
> >--Original Message--
> >Yes, you want to avoid trying to back up the mdf and ldf
> files and instead
> >just back up the native SQL backup files (trn/bak) to
> tape. You would use
> >these to restore the database. BOL has plenty of detail
> on backup and
> >restore in the Administering SQL Server>Backing Up and
> Restoring Databases
> >section
> >
> >--
> >HTH
> >
> >Jasper Smith (SQL Server MVP)
> >
> >I support PASS - the definitive, global
> >community for SQL Server professionals -
> >http://www.sqlpass.org
> >
> >
> >"Dave" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:288a01c3fc84$cf4b5850$a101280a@.phx.gbl...
> >> I am not a big fan of paying 3rd party backup vendors
> for
> >> agents, but I need to make sure that we are not risking
> >> corrupting the database files. I have setup maintenance
> >> plans to do the fulls and log backups to disk. We are
> just
> >> beginning to roll out NetBackup 5.0 in production, and
> >> without the SQL agent installed, it appears as though it
> >> can backup all the data files without error. Should I
> >> exclude the "hot files" in NetBackup, and rely on the
> bak
> >> and trn files if I need to restore the whole server?
> >> Meaning, if my prod server died, and I needed to restore
> >> from tape to a hotspare, is it possible to restore the
> >> database(s) if the mssql\data\*.mdf and ldf files are
> not
> >> restored?
> >> If this is a lame question, I apologize, as I am not a
> >> DBA, but a storage guy, and we have no official SQL
> DBA's
> >> in house yet.
> >> Thanks for any and all help!
> >>
> >> Dave
> >>
> >>
> >>
> >
> >
> >.
> >
Is it necessary to add a GO ?
We have to run two update statements:
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
Thanks
Jason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks
|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.g bl...
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>
|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.g bl...
>
|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> glsD:OVvXrNeuFHA.3596@.TK2MSFTNGP15.phx.g bl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
Thanks
Jason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks
|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.g bl...
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>
|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.g bl...
>
|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> glsD:OVvXrNeuFHA.3596@.TK2MSFTNGP15.phx.g bl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>
Is it necessary to add a GO ?
We have to run two update statements:
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
ThanksJason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>> Jason
>> GO is a batch "breaker" and it is not TSQL command
>> If you run it on QA you may want to consider putting GO between an
>> UPDATE statements
>>
>> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
>> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>>
>|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:OVvXrNeuFHA.3596@.TK2MSFTNGP15.phx.gbl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>> Additional information:
>> For the concept of batch, assume there are 10 statements in a batch. If
>> the fifth statement has a syntax error, none of the statements in the
>> batch are executed. If the batch is compiled, and the second statement
>> then fails while executing, the results of the first statement are not
>> affected because it has already executed.
>> Read the online help for more information and detailed explanation.
>> "Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>> Jason
>> GO is a batch "breaker" and it is not TSQL command
>> If you run it on QA you may want to consider putting GO between an
>> UPDATE statements
>>
>> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
>> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>>
>>
>
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
ThanksJason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>> Jason
>> GO is a batch "breaker" and it is not TSQL command
>> If you run it on QA you may want to consider putting GO between an
>> UPDATE statements
>>
>> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
>> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>>
>|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D:OVvXrNeuFHA.3596@.TK2MSFTNGP15.phx.gbl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>> Additional information:
>> For the concept of batch, assume there are 10 statements in a batch. If
>> the fifth statement has a syntax error, none of the statements in the
>> batch are executed. If the batch is compiled, and the second statement
>> then fails while executing, the results of the first statement are not
>> affected because it has already executed.
>> Read the online help for more information and detailed explanation.
>> "Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>> Jason
>> GO is a batch "breaker" and it is not TSQL command
>> If you run it on QA you may want to consider putting GO between an
>> UPDATE statements
>>
>> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
>> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>> We have to run two update statements:
>> update pthdbo.table14
>> set name = t3.sortname
>> from pthdbo.table14 as t1,
>> xxxxxx
>> AND
>> update pthdbo.table14
>> set streetname = t7.streetname
>> from pthdbo.table as t1,
>> yyyyyy
>> Can I run these 2 update statements together ? Is it
>> necessary for me to add a GO statement after running the
>> first UPDATE statement ? If YES, would you mind to let me
>> know why ?
>> Thanks
>>
>>
>
Is it necessary to add a GO ?
We have to run two update statements:
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
ThanksJason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...[vbco
l=seagreen]
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>[/vbcol]|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> glsD:OVvXrNeuFHA.3596@.TK2MSFTNGP15.p
hx.gbl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
AND
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
Can I run these 2 update statements together ? Is it
necessary for me to add a GO statement after running the
first UPDATE statement ? If YES, would you mind to let me
know why ?
ThanksJason
GO is a batch "breaker" and it is not TSQL command
If you run it on QA you may want to consider putting GO between an UPDATE
statements
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
> We have to run two update statements:
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> AND
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> Can I run these 2 update statements together ? Is it
> necessary for me to add a GO statement after running the
> first UPDATE statement ? If YES, would you mind to let me
> know why ?
> Thanks|||Additional information:
For the concept of batch, assume there are 10 statements in a batch. If the
fifth statement has a syntax error, none of the statements in the batch are
executed. If the batch is compiled, and the second statement then fails
while executing, the results of the first statement are not affected because
it has already executed.
Read the online help for more information and detailed explanation.
"Uri Dimant" <urid@.iscar.co.il> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...[vbco
l=seagreen]
> Jason
> GO is a batch "breaker" and it is not TSQL command
> If you run it on QA you may want to consider putting GO between an UPDATE
> statements
>
> "Jason" <anonymous@.discussions.microsoft.com> wrote in message
> news:01e301c5b9bd$ab182150$a601280a@.phx.gbl...
>[/vbcol]|||Dear all,
Thank you for your advice.
In this way, I can add GO after both Update Statement. However, it seems
that the one after the 2nd Update Statement is optional AS there is nothing
behind it ?
use database1
GO
update pthdbo.table14
set name = t3.sortname
from pthdbo.table14 as t1,
xxxxxx
GO
update pthdbo.table14
set streetname = t7.streetname
from pthdbo.table as t1,
yyyyyy
GO
Thanks
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
> Additional information:
> For the concept of batch, assume there are 10 statements in a batch. If
> the fifth statement has a syntax error, none of the statements in the
> batch are executed. If the batch is compiled, and the second statement
> then fails while executing, the results of the first statement are not
> affected because it has already executed.
> Read the online help for more information and detailed explanation.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:OLbGPKcuFHA.3660@.tk2msftngp13.phx.gbl...
>|||No. The first GO signals begining of a batch process(i.e. put it in batch
processing mode), and the second GO signal that's the end of it so it gets
executed.
"Jason" <anonymous@.discussions.microsoft.com> glsD:OVvXrNeuFHA.3596@.TK2MSFTNGP15.p
hx.gbl...
> Dear all,
> Thank you for your advice.
> In this way, I can add GO after both Update Statement. However, it seems
> that the one after the 2nd Update Statement is optional AS there is
> nothing behind it ?
> use database1
> GO
> update pthdbo.table14
> set name = t3.sortname
> from pthdbo.table14 as t1,
> xxxxxx
> GO
> update pthdbo.table14
> set streetname = t7.streetname
> from pthdbo.table as t1,
> yyyyyy
> GO
> Thanks
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:edEK12cuFHA.3896@.TK2MSFTNGP15.phx.gbl...
>
Wednesday, March 7, 2012
Is is necessary for a table which will be part of the Replication process to have a and Primary
Hi there,
We're going to use replication on our database. There are tables without any primary key.
Is a primary key necessary for replication?
I have also antoher question: We want to replicate the whole OLTP database (size 30 GB).
Is snapshot replication a suitable mechanisme for this? I thougt snapshot replication overwrites all of the data, not only changed data. Or should we use another replication method?
Thanks in advance,
Patrick de Jong
A primary key is necessary to replicate an article so that a unique record can always be found. Snapshotting a 30gb everytime might not be such a great idea. Transactional is probably a better way to go, depending on your situation.Tim|||
Yes you need to have a primary key on each table for replication.
Depending on how often your data changes and how frequently you need to have the subscriber updated is the best way to decide if snapshot replication is the best method.
Typically snapshot is not the best option unless you have a very high data change rate and you only need the subscriber updated once or twice per day (or less frequently).
|||Thanks for the answer's. The really helped me.
1.) My customer has te deside on which fields the pk must come.
2.) I think we will use transactional replication.
Greetz,
Patrick de Jong
|||Hi Friends,
1.Yes a table involved in Transactional replication should have a primary key defined.Also if u hav opted for transactional publication with updating subscriber,a unique identifier is required for a table.
2.Since it is a OLTP Database it keeps changing frequently,my suggestion would be to go for Transactional Replication.
Always prefer Snapshot replication for datas which do not change frequently (OLAP environment)
Rgds
Deepak
|||Thanks Deepak,
Today we've made a list of tables without a PK. It seems to be no problem to add the missing PK's because the tabels had an identity which was used as some sort of PK. Tomorrow we will test transactional replication.
Greetz,
Patrick de Jong
Friday, February 24, 2012
is importing a dtsx file Necessary
Ok, I'm actually adding a SSIS job to my job agent on my test SQL server. Noticed that when I go to my job agent --> add new job, under the steps option, I click new. this then takes me to the new job step window. When I select
Type as SQL Server Integrated Services, I then see some new tabs at the bottom of the form. Under package source I can select File System, SQL Server, or SSIS Package Store, then I have to select the location of the dtsx file.
So my question is, since I can select the actual file (package) I want to run from here, do I really have to import a package to the file system or MSDB under the SQL Integration Services on the server?
It appears to me that its kind of the same thing.
I'm new to this SSIS, SQL DB work, so I'm learning as I go. . . .Yes, you do. If the file doesn't reside on the server, how will the agent job be able to find it?I believe that when you select filesystem in the Agent job step, it's showing you your local filesystem, not that of the server.
Is DTC required in a SQL 2000/Windows 2003 cluster ?
Hi,
If the SQL environment is not going to use distributed transactions, is it
still necessary to configure a DTC resource on the cluster ?
Thanks
In theory, you can run SQL 2000 clustered without DTC. In practice, it can
limit functionality. I generally configure a DTC resource, just to simplify
installation and maintenance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SteveO" <SteveO@.discussions.microsoft.com> wrote in message
news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
> Hi,
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
> Thanks
|||Yes. You will always configured DTC into the cluster. There are other
services which will use it.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"SteveO" <SteveO@.discussions.microsoft.com> wrote in message
news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
> Hi,
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
> Thanks
|||I hate to nitpick. But technically, you don't have to if you don't need it.
Linchi
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:%23YUT2d2IGHA.2912@.tk2msftngp13.phx.gbl...
> Yes. You will always configured DTC into the cluster. There are other
> services which will use it.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "SteveO" <SteveO@.discussions.microsoft.com> wrote in message
> news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
>
|||Well, you'd have to take that up with the failover clustering team. It is
their explicit recommendation for ALL clusters that you will install a
failover cluster instance in.
Not having it there is going to cause several errors during the upgrade as
well as throwing additional errors during a fresh install. I haven't tested
enough permutations to say whether it is needed or not, so at this point, I
tend to trust the people who have spent thousands of hours testing hundreds
of different configurations. They know the code a lot better than me since
they wrote it. If that's the recommendation, I'm sticking into in this
case, because I have no way of proving that it shouldn't be followed.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:%23Dc$G%238IGHA.2064@.TK2MSFTNGP09.phx.gbl...
>I hate to nitpick. But technically, you don't have to if you don't need it.
> Linchi
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:%23YUT2d2IGHA.2912@.tk2msftngp13.phx.gbl...
>
|||I have 15 SQL Clusters in Production without MSDTC in the cluster, the local
service is disabled. No issues. Our application simply does not use it!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:uuCH0K9IGHA.1132@.TK2MSFTNGP10.phx.gbl...
> Well, you'd have to take that up with the failover clustering team. It is
> their explicit recommendation for ALL clusters that you will install a
> failover cluster instance in.
> Not having it there is going to cause several errors during the upgrade as
> well as throwing additional errors during a fresh install. I haven't
> tested enough permutations to say whether it is needed or not, so at this
> point, I tend to trust the people who have spent thousands of hours
> testing hundreds of different configurations. They know the code a lot
> better than me since they wrote it. If that's the recommendation, I'm
> sticking into in this case, because I have no way of proving that it
> shouldn't be followed.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:%23Dc$G%238IGHA.2064@.TK2MSFTNGP09.phx.gbl...
>
>
If the SQL environment is not going to use distributed transactions, is it
still necessary to configure a DTC resource on the cluster ?
Thanks
In theory, you can run SQL 2000 clustered without DTC. In practice, it can
limit functionality. I generally configure a DTC resource, just to simplify
installation and maintenance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"SteveO" <SteveO@.discussions.microsoft.com> wrote in message
news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
> Hi,
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
> Thanks
|||Yes. You will always configured DTC into the cluster. There are other
services which will use it.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"SteveO" <SteveO@.discussions.microsoft.com> wrote in message
news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
> Hi,
> If the SQL environment is not going to use distributed transactions, is it
> still necessary to configure a DTC resource on the cluster ?
> Thanks
|||I hate to nitpick. But technically, you don't have to if you don't need it.
Linchi
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:%23YUT2d2IGHA.2912@.tk2msftngp13.phx.gbl...
> Yes. You will always configured DTC into the cluster. There are other
> services which will use it.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "SteveO" <SteveO@.discussions.microsoft.com> wrote in message
> news:332351AB-0806-4F9A-94DF-C5F929F5B7D0@.microsoft.com...
>
|||Well, you'd have to take that up with the failover clustering team. It is
their explicit recommendation for ALL clusters that you will install a
failover cluster instance in.
Not having it there is going to cause several errors during the upgrade as
well as throwing additional errors during a fresh install. I haven't tested
enough permutations to say whether it is needed or not, so at this point, I
tend to trust the people who have spent thousands of hours testing hundreds
of different configurations. They know the code a lot better than me since
they wrote it. If that's the recommendation, I'm sticking into in this
case, because I have no way of proving that it shouldn't be followed.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:%23Dc$G%238IGHA.2064@.TK2MSFTNGP09.phx.gbl...
>I hate to nitpick. But technically, you don't have to if you don't need it.
> Linchi
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:%23YUT2d2IGHA.2912@.tk2msftngp13.phx.gbl...
>
|||I have 15 SQL Clusters in Production without MSDTC in the cluster, the local
service is disabled. No issues. Our application simply does not use it!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:uuCH0K9IGHA.1132@.TK2MSFTNGP10.phx.gbl...
> Well, you'd have to take that up with the failover clustering team. It is
> their explicit recommendation for ALL clusters that you will install a
> failover cluster instance in.
> Not having it there is going to cause several errors during the upgrade as
> well as throwing additional errors during a fresh install. I haven't
> tested enough permutations to say whether it is needed or not, so at this
> point, I tend to trust the people who have spent thousands of hours
> testing hundreds of different configurations. They know the code a lot
> better than me since they wrote it. If that's the recommendation, I'm
> sticking into in this case, because I have no way of proving that it
> shouldn't be followed.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:%23Dc$G%238IGHA.2064@.TK2MSFTNGP09.phx.gbl...
>
>
Is Disc 2 necessary?
Hello all,
I only have disc 1 of 2. Do I need Disc 2? What is in Disc 2?
Thanks
The biggest component that Disc 2 contains is the client tools. I imagine you'd be able to install a few of the components (engine, etc), but you might hit some errors. Here's the most common thing you'll hit if you try an install that requires Disc 2:
http://blogs/jdbaker/archive/2006/01/19/8885.aspx
Thanks,
Sam Lester (MSFT)
Subscribe to:
Posts (Atom)