How do I get the unique fields from a select query without iterating. Is
this possible? My current statement is below. Thanks in advance.
"SELECT DealNumber, [User] FROM DealingFinal WHERE ([User] = 'dbo')"Hi
SELECT DISTINCT DealNumber, [User] FROM DealingFinal
"xfd" <xfd@.xfd.com> wrote in message
news:u9rL%23udkFHA.3756@.TK2MSFTNGP15.phx.gbl...
> How do I get the unique fields from a select query without iterating. Is
> this possible? My current statement is below. Thanks in advance.
> "SELECT DealNumber, [User] FROM DealingFinal WHERE ([User] = 'dbo')"
>
Showing posts with label current. Show all posts
Showing posts with label current. Show all posts
Friday, March 23, 2012
Wednesday, March 7, 2012
Newbie ? -- Does 'master' transaction log need to be backed up?
Hope someone can help answer this question for this newbie.
We are running SQL Server 2000 SP3a on Windows Server 2003, all updates current.
We have been running smoothly for some time now with two user databases. The maintenance plans work well for them. The maintenance plans for the system databases, however, have been giving me fits. Occasionally, one or more steps will fail and there is
no information in any log with which to begin an investigation. The Books Online offer no clue, either.
Here's what I need to know:
Most maintenance plans consist of 1 or more options: Optimizations, Integrity Checks, Database Backup, Transaction Log Backup. I have all 4 options set up for my user databases.
For the system databases (master, model, and msdb), the Transaction Log Backup continues to fail for the 'master' database with this error:
Backup can not be performed on this database. This sub task is ignored
The Properties Tab of the 'master' database shows that the Transaction Log file is:
C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf
Is there a problem with the database?
Any assistance is greatly appreciated.
Robert
By the way, 'master' is set to FULL recovery
Robert
|||Hi,
You canot perform a Trasaction log backup for MASTER database even though
recovery model is "FULL". Only database backup is possible. Why do you need
to backup the trasnaction log of MASTER database, because it is not advised
to have user tables / transaction tables in system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> By the way, 'master' is set to FULL recovery
> Robert
>
|||Hari,
Thanks for the information.
We don't use the system databases for user data at all! I merely need to
understand what is involved in a standard daily system maintenance process.
That being said, is it okay to just have the Optimizations, Integrity
Checks, and Database Backup options for those three databases (master, model
and msdb) and forget about the Transaction Log backup for each?
Thanks!
Robert
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
> Hi,
> You canot perform a Trasaction log backup for MASTER database even though
> recovery model is "FULL". Only database backup is possible. Why do you
need
> to backup the trasnaction log of MASTER database, because it is not
advised
> to have user tables / transaction tables in system databases.
> Thanks
> Hari
> MCDBA
> "Robert" <rclay@.kerrdrug.com> wrote in message
> news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
>
|||Hi,
Since you are not adding any trasnactions to System database, you can ignore
the transaction log backup
for system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:#S$Kw28TEHA.3988@.TK2MSFTNGP10.phx.gbl...
> Hari,
> Thanks for the information.
> We don't use the system databases for user data at all! I merely need to
> understand what is involved in a standard daily system maintenance
process.
> That being said, is it okay to just have the Optimizations, Integrity
> Checks, and Database Backup options for those three databases (master,
model[vbcol=seagreen]
> and msdb) and forget about the Transaction Log backup for each?
> Thanks!
> Robert
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
though
> need
> advised
>
|||Thanks, Hari.
I will only backup the Transaction Logs for my user databases, then.
Robert
|||Be aware that the backup history is in the msdb database. Because of this, I also do log backup for msdb. For
some strange reason, MS decided to set msdb to simple recovery mode when agent starts, but I just fix that by
setting msdb to full in an auto-start agent job.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert" <rclay@.kerrdrug.com> wrote in message news:%23sbmuX9TEHA.3140@.tk2msftngp13.phx.gbl...
> Thanks, Hari.
> I will only backup the Transaction Logs for my user databases, then.
> Robert
>
We are running SQL Server 2000 SP3a on Windows Server 2003, all updates current.
We have been running smoothly for some time now with two user databases. The maintenance plans work well for them. The maintenance plans for the system databases, however, have been giving me fits. Occasionally, one or more steps will fail and there is
no information in any log with which to begin an investigation. The Books Online offer no clue, either.
Here's what I need to know:
Most maintenance plans consist of 1 or more options: Optimizations, Integrity Checks, Database Backup, Transaction Log Backup. I have all 4 options set up for my user databases.
For the system databases (master, model, and msdb), the Transaction Log Backup continues to fail for the 'master' database with this error:
Backup can not be performed on this database. This sub task is ignored
The Properties Tab of the 'master' database shows that the Transaction Log file is:
C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf
Is there a problem with the database?
Any assistance is greatly appreciated.
Robert
By the way, 'master' is set to FULL recovery
Robert
|||Hi,
You canot perform a Trasaction log backup for MASTER database even though
recovery model is "FULL". Only database backup is possible. Why do you need
to backup the trasnaction log of MASTER database, because it is not advised
to have user tables / transaction tables in system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> By the way, 'master' is set to FULL recovery
> Robert
>
|||Hari,
Thanks for the information.
We don't use the system databases for user data at all! I merely need to
understand what is involved in a standard daily system maintenance process.
That being said, is it okay to just have the Optimizations, Integrity
Checks, and Database Backup options for those three databases (master, model
and msdb) and forget about the Transaction Log backup for each?
Thanks!
Robert
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
> Hi,
> You canot perform a Trasaction log backup for MASTER database even though
> recovery model is "FULL". Only database backup is possible. Why do you
need
> to backup the trasnaction log of MASTER database, because it is not
advised
> to have user tables / transaction tables in system databases.
> Thanks
> Hari
> MCDBA
> "Robert" <rclay@.kerrdrug.com> wrote in message
> news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
>
|||Hi,
Since you are not adding any trasnactions to System database, you can ignore
the transaction log backup
for system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:#S$Kw28TEHA.3988@.TK2MSFTNGP10.phx.gbl...
> Hari,
> Thanks for the information.
> We don't use the system databases for user data at all! I merely need to
> understand what is involved in a standard daily system maintenance
process.
> That being said, is it okay to just have the Optimizations, Integrity
> Checks, and Database Backup options for those three databases (master,
model[vbcol=seagreen]
> and msdb) and forget about the Transaction Log backup for each?
> Thanks!
> Robert
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
though
> need
> advised
>
|||Thanks, Hari.
I will only backup the Transaction Logs for my user databases, then.
Robert
|||Be aware that the backup history is in the msdb database. Because of this, I also do log backup for msdb. For
some strange reason, MS decided to set msdb to simple recovery mode when agent starts, but I just fix that by
setting msdb to full in an auto-start agent job.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert" <rclay@.kerrdrug.com> wrote in message news:%23sbmuX9TEHA.3140@.tk2msftngp13.phx.gbl...
> Thanks, Hari.
> I will only backup the Transaction Logs for my user databases, then.
> Robert
>
Newbie ? -- Does 'master' transaction log need to be backed up?
Hope someone can help answer this question for this newbie
We are running SQL Server 2000 SP3a on Windows Server 2003, all updates current
We have been running smoothly for some time now with two user databases. The maintenance plans work well for them. The maintenance plans for the system databases, however, have been giving me fits. Occasionally, one or more steps will fail and there is no information in any log with which to begin an investigation. The Books Online offer no clue, either
Here's what I need to know
Most maintenance plans consist of 1 or more options: Optimizations, Integrity Checks, Database Backup, Transaction Log Backup. I have all 4 options set up for my user databases
For the system databases (master, model, and msdb), the Transaction Log Backup continues to fail for the 'master' database with this error:
Backup can not be performed on this database. This sub task is ignore
The Properties Tab of the 'master' database shows that the Transaction Log file is
C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ld
Is there a problem with the database
Any assistance is greatly appreciated
RobertBy the way, 'master' is set to FULL recovery
Robert|||Hi,
You canot perform a Trasaction log backup for MASTER database even though
recovery model is "FULL". Only database backup is possible. Why do you need
to backup the trasnaction log of MASTER database, because it is not advised
to have user tables / transaction tables in system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> By the way, 'master' is set to FULL recovery
> Robert
>|||Hari,
Thanks for the information.
We don't use the system databases for user data at all! I merely need to
understand what is involved in a standard daily system maintenance process.
That being said, is it okay to just have the Optimizations, Integrity
Checks, and Database Backup options for those three databases (master, model
and msdb) and forget about the Transaction Log backup for each?
Thanks!
Robert
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
> Hi,
> You canot perform a Trasaction log backup for MASTER database even though
> recovery model is "FULL". Only database backup is possible. Why do you
need
> to backup the trasnaction log of MASTER database, because it is not
advised
> to have user tables / transaction tables in system databases.
> Thanks
> Hari
> MCDBA
> "Robert" <rclay@.kerrdrug.com> wrote in message
> news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > By the way, 'master' is set to FULL recovery
> >
> > Robert
> >
> >
>|||Hi,
Since you are not adding any trasnactions to System database, you can ignore
the transaction log backup
for system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:#S$Kw28TEHA.3988@.TK2MSFTNGP10.phx.gbl...
> Hari,
> Thanks for the information.
> We don't use the system databases for user data at all! I merely need to
> understand what is involved in a standard daily system maintenance
process.
> That being said, is it okay to just have the Optimizations, Integrity
> Checks, and Database Backup options for those three databases (master,
model
> and msdb) and forget about the Transaction Log backup for each?
> Thanks!
> Robert
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > You canot perform a Trasaction log backup for MASTER database even
though
> > recovery model is "FULL". Only database backup is possible. Why do you
> need
> > to backup the trasnaction log of MASTER database, because it is not
> advised
> > to have user tables / transaction tables in system databases.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Robert" <rclay@.kerrdrug.com> wrote in message
> > news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > > By the way, 'master' is set to FULL recovery
> > >
> > > Robert
> > >
> > >
> >
> >
>|||Thanks, Hari.
I will only backup the Transaction Logs for my user databases, then.
Robert|||Be aware that the backup history is in the msdb database. Because of this, I also do log backup for msdb. For
some strange reason, MS decided to set msdb to simple recovery mode when agent starts, but I just fix that by
setting msdb to full in an auto-start agent job.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert" <rclay@.kerrdrug.com> wrote in message news:%23sbmuX9TEHA.3140@.tk2msftngp13.phx.gbl...
> Thanks, Hari.
> I will only backup the Transaction Logs for my user databases, then.
> Robert
>
We are running SQL Server 2000 SP3a on Windows Server 2003, all updates current
We have been running smoothly for some time now with two user databases. The maintenance plans work well for them. The maintenance plans for the system databases, however, have been giving me fits. Occasionally, one or more steps will fail and there is no information in any log with which to begin an investigation. The Books Online offer no clue, either
Here's what I need to know
Most maintenance plans consist of 1 or more options: Optimizations, Integrity Checks, Database Backup, Transaction Log Backup. I have all 4 options set up for my user databases
For the system databases (master, model, and msdb), the Transaction Log Backup continues to fail for the 'master' database with this error:
Backup can not be performed on this database. This sub task is ignore
The Properties Tab of the 'master' database shows that the Transaction Log file is
C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ld
Is there a problem with the database
Any assistance is greatly appreciated
RobertBy the way, 'master' is set to FULL recovery
Robert|||Hi,
You canot perform a Trasaction log backup for MASTER database even though
recovery model is "FULL". Only database backup is possible. Why do you need
to backup the trasnaction log of MASTER database, because it is not advised
to have user tables / transaction tables in system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> By the way, 'master' is set to FULL recovery
> Robert
>|||Hari,
Thanks for the information.
We don't use the system databases for user data at all! I merely need to
understand what is involved in a standard daily system maintenance process.
That being said, is it okay to just have the Optimizations, Integrity
Checks, and Database Backup options for those three databases (master, model
and msdb) and forget about the Transaction Log backup for each?
Thanks!
Robert
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
> Hi,
> You canot perform a Trasaction log backup for MASTER database even though
> recovery model is "FULL". Only database backup is possible. Why do you
need
> to backup the trasnaction log of MASTER database, because it is not
advised
> to have user tables / transaction tables in system databases.
> Thanks
> Hari
> MCDBA
> "Robert" <rclay@.kerrdrug.com> wrote in message
> news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > By the way, 'master' is set to FULL recovery
> >
> > Robert
> >
> >
>|||Hi,
Since you are not adding any trasnactions to System database, you can ignore
the transaction log backup
for system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:#S$Kw28TEHA.3988@.TK2MSFTNGP10.phx.gbl...
> Hari,
> Thanks for the information.
> We don't use the system databases for user data at all! I merely need to
> understand what is involved in a standard daily system maintenance
process.
> That being said, is it okay to just have the Optimizations, Integrity
> Checks, and Database Backup options for those three databases (master,
model
> and msdb) and forget about the Transaction Log backup for each?
> Thanks!
> Robert
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > You canot perform a Trasaction log backup for MASTER database even
though
> > recovery model is "FULL". Only database backup is possible. Why do you
> need
> > to backup the trasnaction log of MASTER database, because it is not
> advised
> > to have user tables / transaction tables in system databases.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Robert" <rclay@.kerrdrug.com> wrote in message
> > news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> > > By the way, 'master' is set to FULL recovery
> > >
> > > Robert
> > >
> > >
> >
> >
>|||Thanks, Hari.
I will only backup the Transaction Logs for my user databases, then.
Robert|||Be aware that the backup history is in the msdb database. Because of this, I also do log backup for msdb. For
some strange reason, MS decided to set msdb to simple recovery mode when agent starts, but I just fix that by
setting msdb to full in an auto-start agent job.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert" <rclay@.kerrdrug.com> wrote in message news:%23sbmuX9TEHA.3140@.tk2msftngp13.phx.gbl...
> Thanks, Hari.
> I will only backup the Transaction Logs for my user databases, then.
> Robert
>
Newbie ? -- Does 'master' transaction log need to be backed up?
Hope someone can help answer this question for this newbie.
We are running SQL Server 2000 SP3a on Windows Server 2003, all updates curr
ent.
We have been running smoothly for some time now with two user databases. Th
e maintenance plans work well for them. The maintenance plans for the syste
m databases, however, have been giving me fits. Occasionally, one or more s
teps will fail and there is
no information in any log with which to begin an investigation. The Books O
nline offer no clue, either.
Here's what I need to know:
Most maintenance plans consist of 1 or more options: Optimizations, Integri
ty Checks, Database Backup, Transaction Log Backup. I have all 4 options se
t up for my user databases.
For the system databases (master, model, and msdb), the Transaction Log Back
up continues to fail for the 'master' database with this error:
Backup can not be performed on this database. This sub task is ignored
The Properties Tab of the 'master' database shows that the Transaction Log f
ile is:
C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf
Is there a problem with the database?
Any assistance is greatly appreciated.
RobertBy the way, 'master' is set to FULL recovery
Robert|||Hi,
You canot perform a Trasaction log backup for MASTER database even though
recovery model is "FULL". Only database backup is possible. Why do you need
to backup the trasnaction log of MASTER database, because it is not advised
to have user tables / transaction tables in system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> By the way, 'master' is set to FULL recovery
> Robert
>|||Hari,
Thanks for the information.
We don't use the system databases for user data at all! I merely need to
understand what is involved in a standard daily system maintenance process.
That being said, is it okay to just have the Optimizations, Integrity
Checks, and Database Backup options for those three databases (master, model
and msdb) and forget about the Transaction Log backup for each?
Thanks!
Robert
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
> Hi,
> You canot perform a Trasaction log backup for MASTER database even though
> recovery model is "FULL". Only database backup is possible. Why do you
need
> to backup the trasnaction log of MASTER database, because it is not
advised
> to have user tables / transaction tables in system databases.
> Thanks
> Hari
> MCDBA
> "Robert" <rclay@.kerrdrug.com> wrote in message
> news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
>|||Hi,
Since you are not adding any trasnactions to System database, you can ignore
the transaction log backup
for system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:#S$Kw28TEHA.3988@.TK2MSFTNGP10.phx.gbl...
> Hari,
> Thanks for the information.
> We don't use the system databases for user data at all! I merely need to
> understand what is involved in a standard daily system maintenance
process.
> That being said, is it okay to just have the Optimizations, Integrity
> Checks, and Database Backup options for those three databases (master,
model
> and msdb) and forget about the Transaction Log backup for each?
> Thanks!
> Robert
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
though[vbcol=seagreen]
> need
> advised
>|||Thanks, Hari.
I will only backup the Transaction Logs for my user databases, then.
Robert|||Be aware that the backup history is in the msdb database. Because of this, I
also do log backup for msdb. For
some strange reason, MS decided to set msdb to simple recovery mode when age
nt starts, but I just fix that by
setting msdb to full in an auto-start agent job.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert" <rclay@.kerrdrug.com> wrote in message news:%23sbmuX9TEHA.3140@.tk2msftngp13.phx.gbl.
.
> Thanks, Hari.
> I will only backup the Transaction Logs for my user databases, then.
> Robert
>
We are running SQL Server 2000 SP3a on Windows Server 2003, all updates curr
ent.
We have been running smoothly for some time now with two user databases. Th
e maintenance plans work well for them. The maintenance plans for the syste
m databases, however, have been giving me fits. Occasionally, one or more s
teps will fail and there is
no information in any log with which to begin an investigation. The Books O
nline offer no clue, either.
Here's what I need to know:
Most maintenance plans consist of 1 or more options: Optimizations, Integri
ty Checks, Database Backup, Transaction Log Backup. I have all 4 options se
t up for my user databases.
For the system databases (master, model, and msdb), the Transaction Log Back
up continues to fail for the 'master' database with this error:
Backup can not be performed on this database. This sub task is ignored
The Properties Tab of the 'master' database shows that the Transaction Log f
ile is:
C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf
Is there a problem with the database?
Any assistance is greatly appreciated.
RobertBy the way, 'master' is set to FULL recovery
Robert|||Hi,
You canot perform a Trasaction log backup for MASTER database even though
recovery model is "FULL". Only database backup is possible. Why do you need
to backup the trasnaction log of MASTER database, because it is not advised
to have user tables / transaction tables in system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
> By the way, 'master' is set to FULL recovery
> Robert
>|||Hari,
Thanks for the information.
We don't use the system databases for user data at all! I merely need to
understand what is involved in a standard daily system maintenance process.
That being said, is it okay to just have the Optimizations, Integrity
Checks, and Database Backup options for those three databases (master, model
and msdb) and forget about the Transaction Log backup for each?
Thanks!
Robert
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
> Hi,
> You canot perform a Trasaction log backup for MASTER database even though
> recovery model is "FULL". Only database backup is possible. Why do you
need
> to backup the trasnaction log of MASTER database, because it is not
advised
> to have user tables / transaction tables in system databases.
> Thanks
> Hari
> MCDBA
> "Robert" <rclay@.kerrdrug.com> wrote in message
> news:uEutur8TEHA.1356@.TK2MSFTNGP09.phx.gbl...
>|||Hi,
Since you are not adding any trasnactions to System database, you can ignore
the transaction log backup
for system databases.
Thanks
Hari
MCDBA
"Robert" <rclay@.kerrdrug.com> wrote in message
news:#S$Kw28TEHA.3988@.TK2MSFTNGP10.phx.gbl...
> Hari,
> Thanks for the information.
> We don't use the system databases for user data at all! I merely need to
> understand what is involved in a standard daily system maintenance
process.
> That being said, is it okay to just have the Optimizations, Integrity
> Checks, and Database Backup options for those three databases (master,
model
> and msdb) and forget about the Transaction Log backup for each?
> Thanks!
> Robert
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:ObCeux8TEHA.4048@.TK2MSFTNGP12.phx.gbl...
though[vbcol=seagreen]
> need
> advised
>|||Thanks, Hari.
I will only backup the Transaction Logs for my user databases, then.
Robert|||Be aware that the backup history is in the msdb database. Because of this, I
also do log backup for msdb. For
some strange reason, MS decided to set msdb to simple recovery mode when age
nt starts, but I just fix that by
setting msdb to full in an auto-start agent job.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Robert" <rclay@.kerrdrug.com> wrote in message news:%23sbmuX9TEHA.3140@.tk2msftngp13.phx.gbl.
.
> Thanks, Hari.
> I will only backup the Transaction Logs for my user databases, then.
> Robert
>
Saturday, February 25, 2012
Newbie - Good Doumentation Needed
Our current environment consists of a SQL 2000 server and report server with reporting services. I hope I didn't screw that up but I guess the important thing is, I'm sure it's SQL 2000. I have Visual Studio 2005. I need to edit existing reports on the report server website and create new reports with what I have. I am familiar with writing reports in a report viewer and I am familiar with SQL queries. I need some good documentation to get me started, and I'm having trouble finding it related to SQL 2000/VS2005. I dont have the foggiest of ideas of how to get VS2005 to see my exisitng reports and to get them to hook up with each other. Any advice to get me out the door would be much appreciated. Thanks!!
you can't creat Bi project in VS2005 as long as you don't install the MS Reporting service 2005 but you can create the BI project in VS2003 and just refere to the deployed reports on the reporting server
http://<machine name>/reportserver and use them in your VS2005 web or windows project by report viewer
|||
Since upgrading SQL and SQL reporting services to 2005 is out of the question at this point, does this mean I either need to get Visual Studio 2003 or I'm dead in the water?
Sounds like I'm stuck with my current setup. Correct?
yes you need Visual studio 2003 and create BI project , develop yoour reports then deploy them on the reporting server so you can easily view them in your web or windows application using report viewer control.
Subscribe to:
Posts (Atom)