Hello,
One of my production database become suspect. Here is the messages taken from event veiwer-> Application Log. This is all I can share with you. Please help.
Regards
Nurullah
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D
9/18/2003 12:27:57 PM MSSQLSERVER Information
-2 17055 N/A SERVERA "19013 :
SQL server listening on TCP, Shared Memory, Named Pipes.
"
--
9/18/2003 12:27:57 PM MSSQLSERVER Information
-2 17055 N/A SERVERA 17126 :
SQL Server is ready for client connections =09
--
9/18/2003 12:28:08 PM MSSQLSERVER Information
-2 17055 N/A SERVERA 8128:00:00
Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'sp_MSgetversion'. =09
--
9/18/2003 12:28:08 PM MSSQLSERVER Information
-2 17055 N/A SERVERA 8128:00:00
--
9/18/2003 12:33:29 PM MSSQLSERVER Error -2
17055 N/A SERVERA "17066 :
SQL Server Assertion: File: <page.cpp>, line=3D2610 Failed Assertion =3D 'spaceNeeded <=3D spaceContig && spaceNeeded <=3D space_usable'.
"
--
9/18/2003 12:33:29 PM MSSQLSERVER Error -2
17055 N/A SERVERA "18052 :
Error: 3624, Severity: 20, State: 1.
"
--
9/18/2003 12:33:29 PM MSSQLSERVER Error -2
17052 N/A SERVERA "Error: 644, Severity: 21, State: 5
Could not find the index entry for RID '1618d4000000100' in index page (1:9759), index ID 2, database 'eBill_Main'. "
--
9/18/2003 12:33:29 PM MSSQLSERVER Error -2
17052 N/A SERVERA "Error: 3314, Severity: 21, State: 4
Error while undoing logged operation in database 'eBill_Main'. Error at log record ID (25502:819:174). "
--
9/18/2003 12:33:31 PM MSSQLSERVER Error -2
17055 N/A SERVERA "17066 :
SQL Server Assertion: File: <scanrid.cpp>, line=3D321 Failed Assertion =3D 'm_len !=3D 0'.
"
--
9/18/2003 12:33:31 PM MSSQLSERVER Error -2
17052 N/A SERVERA "Error: 644, Severity: 21, State: 5
Could not find the index entry for RID '=01' in index page (1:9759), index ID 2, database 'eBill_Main'. "
--
9/18/2003 12:33:34 PM MSSQLSERVER Error -2
17055 N/A SERVERA "17066 :
SQL Server Assertion: File: <logscan.cpp>, line=3D3063 Failed Assertion =3D '(m_lastLSN =3D=3D NullLSN) || (m_lastLSN > m_curLSN)'.
"
--
9/18/2003 12:33:36 PM MSSQLSERVER Error -2
17055 N/A SERVERA "17066 :
SQL Server Assertion: File: <logscan.cpp>, line=3D3282 Failed Assertion =3D 'm_lastLSN =3D=3D NullLSN || startLSN < m_lastLSN'.
"
--
9/18/2003 12:33:36 PM MSSQLSERVER Error -2
17052 N/A SERVERA "Error: 9004, Severity: 23, State: 7
An error occurred while processing the log for database 'eBill_Main'. "
--
9/18/2003 12:33:36 PM MSSQLSERVER Error -2
17052 N/A SERVERA "Error: 3314, Severity: 21, State: 4
Error while undoing logged operation in database 'eBill_Main'. Error at log record ID (25502:819:174). "
--
9/18/2003 12:33:36 PM MSSQLSERVER Error -2
17052 N/A SERVERA "Error: 9001, Severity: 21, State: 1
The log for database 'eBill_Main' is not available. "
--An assertion is when a piece of SQL Server's C Code goes west.
This line interested me though
9/18/2003 12:33:29 PM MSSQLSERVER Error -2
17055 N/A SERVERA "17066 :
SQL Server Assertion: File: <page.cpp>, line=2610
Failed Assertion = 'spaceNeeded <= spaceContig &&
spaceNeeded <= space_usable'.
Do you have enough disk space?
What version SQL Server and SP are you running ?
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Showing posts with label share. Show all posts
Showing posts with label share. Show all posts
Tuesday, March 27, 2012
Wednesday, March 21, 2012
Database backup hardware
Can anyone suggest what types of hardware I should be using to backup my SQL database. I currently do a differential each night to a file share, which works well, and there is no concern for network usage. I wonder if using a tape or perhaps DVD is a bett
er method. Is a differential backup to DVD even possible?
Thanks.
I personally prefer to backup to a file share overnight and archive that to
tape during the day. I don't bother with differential backups, but that is
due more to my data flow than anything else. Differentials don't really
save me much. Your situation may be different.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.
|||So I tend to be of the school of thought that the first, if not the second
and third, generations of backups should be on spinning disk somewhere -
high performance, cheap, simple and for more reliable than any removable
medium. In a multi-server environment it's best to have these on a device
that's independant of a server chassis (NAS or SAN). I consider tape for
disaster recovery from off-site resources _only_. TCO of tape is
astronomical compared to SATA NAS or SAN devices and way more problematic.
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.
|||G Clark,
I like to backup to disk first, then let a tape job run at night to
backup the sql backup files. When selecting backup media you should look
at the durability of the media. I'm not sure how durable DVD media is,
or if it is better than tape. There is certainly a capacity issue with
DVD for me.
Tape manufacturers recommend that a tape not be used more than 20 times
before being discarded. However this is seldom respected and I quite
often here stories of people with corrupt tapes - due I suspect to a
worn out tape.
A tape solution should be serviceable for you as long as your respect
the durability of the medium and adhere to manufacturers guidelines.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
G Clark wrote:
> Can anyone suggest what types of hardware I should be using to backup my SQL database. I currently do a differential each night to a file share, which works well, and there is no concern for network usage. I wonder if using a tape or perhaps DVD is a be
tter method. Is a differential backup to DVD even possible?
> Thanks.
sql
er method. Is a differential backup to DVD even possible?
Thanks.
I personally prefer to backup to a file share overnight and archive that to
tape during the day. I don't bother with differential backups, but that is
due more to my data flow than anything else. Differentials don't really
save me much. Your situation may be different.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.
|||So I tend to be of the school of thought that the first, if not the second
and third, generations of backups should be on spinning disk somewhere -
high performance, cheap, simple and for more reliable than any removable
medium. In a multi-server environment it's best to have these on a device
that's independant of a server chassis (NAS or SAN). I consider tape for
disaster recovery from off-site resources _only_. TCO of tape is
astronomical compared to SATA NAS or SAN devices and way more problematic.
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.
|||G Clark,
I like to backup to disk first, then let a tape job run at night to
backup the sql backup files. When selecting backup media you should look
at the durability of the media. I'm not sure how durable DVD media is,
or if it is better than tape. There is certainly a capacity issue with
DVD for me.
Tape manufacturers recommend that a tape not be used more than 20 times
before being discarded. However this is seldom respected and I quite
often here stories of people with corrupt tapes - due I suspect to a
worn out tape.
A tape solution should be serviceable for you as long as your respect
the durability of the medium and adhere to manufacturers guidelines.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
G Clark wrote:
> Can anyone suggest what types of hardware I should be using to backup my SQL database. I currently do a differential each night to a file share, which works well, and there is no concern for network usage. I wonder if using a tape or perhaps DVD is a be
tter method. Is a differential backup to DVD even possible?
> Thanks.
sql
Database backup hardware
Can anyone suggest what types of hardware I should be using to backup my SQL database. I currently do a differential each night to a file share, which works well, and there is no concern for network usage. I wonder if using a tape or perhaps DVD is a better method. Is a differential backup to DVD even possible?
Thanks.I personally prefer to backup to a file share overnight and archive that to
tape during the day. I don't bother with differential backups, but that is
due more to my data flow than anything else. Differentials don't really
save me much. Your situation may be different.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.|||So I tend to be of the school of thought that the first, if not the second
and third, generations of backups should be on spinning disk somewhere -
high performance, cheap, simple and for more reliable than any removable
medium. In a multi-server environment it's best to have these on a device
that's independant of a server chassis (NAS or SAN). I consider tape for
disaster recovery from off-site resources _only_. TCO of tape is
astronomical compared to SATA NAS or SAN devices and way more problematic.
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.|||G Clark,
I like to backup to disk first, then let a tape job run at night to
backup the sql backup files. When selecting backup media you should look
at the durability of the media. I'm not sure how durable DVD media is,
or if it is better than tape. There is certainly a capacity issue with
DVD for me.
Tape manufacturers recommend that a tape not be used more than 20 times
before being discarded. However this is seldom respected and I quite
often here stories of people with corrupt tapes - due I suspect to a
worn out tape.
A tape solution should be serviceable for you as long as your respect
the durability of the medium and adhere to manufacturers guidelines.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
G Clark wrote:
> Can anyone suggest what types of hardware I should be using to backup my SQL database. I currently do a differential each night to a file share, which works well, and there is no concern for network usage. I wonder if using a tape or perhaps DVD is a better method. Is a differential backup to DVD even possible?
> Thanks.
Thanks.I personally prefer to backup to a file share overnight and archive that to
tape during the day. I don't bother with differential backups, but that is
due more to my data flow than anything else. Differentials don't really
save me much. Your situation may be different.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.|||So I tend to be of the school of thought that the first, if not the second
and third, generations of backups should be on spinning disk somewhere -
high performance, cheap, simple and for more reliable than any removable
medium. In a multi-server environment it's best to have these on a device
that's independant of a server chassis (NAS or SAN). I consider tape for
disaster recovery from off-site resources _only_. TCO of tape is
astronomical compared to SATA NAS or SAN devices and way more problematic.
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.|||G Clark,
I like to backup to disk first, then let a tape job run at night to
backup the sql backup files. When selecting backup media you should look
at the durability of the media. I'm not sure how durable DVD media is,
or if it is better than tape. There is certainly a capacity issue with
DVD for me.
Tape manufacturers recommend that a tape not be used more than 20 times
before being discarded. However this is seldom respected and I quite
often here stories of people with corrupt tapes - due I suspect to a
worn out tape.
A tape solution should be serviceable for you as long as your respect
the durability of the medium and adhere to manufacturers guidelines.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
G Clark wrote:
> Can anyone suggest what types of hardware I should be using to backup my SQL database. I currently do a differential each night to a file share, which works well, and there is no concern for network usage. I wonder if using a tape or perhaps DVD is a better method. Is a differential backup to DVD even possible?
> Thanks.
Database backup hardware
Can anyone suggest what types of hardware I should be using to backup my SQL
database. I currently do a differential each night to a file share, which w
orks well, and there is no concern for network usage. I wonder if using a ta
pe or perhaps DVD is a bett
er method. Is a differential backup to DVD even possible?
Thanks.I personally prefer to backup to a file share overnight and archive that to
tape during the day. I don't bother with differential backups, but that is
due more to my data flow than anything else. Differentials don't really
save me much. Your situation may be different.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.|||So I tend to be of the school of thought that the first, if not the second
and third, generations of backups should be on spinning disk somewhere -
high performance, cheap, simple and for more reliable than any removable
medium. In a multi-server environment it's best to have these on a device
that's independant of a server chassis (NAS or SAN). I consider tape for
disaster recovery from off-site resources _only_. TCO of tape is
astronomical compared to SATA NAS or SAN devices and way more problematic.
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.|||G Clark,
I like to backup to disk first, then let a tape job run at night to
backup the sql backup files. When selecting backup media you should look
at the durability of the media. I'm not sure how durable DVD media is,
or if it is better than tape. There is certainly a capacity issue with
DVD for me.
Tape manufacturers recommend that a tape not be used more than 20 times
before being discarded. However this is seldom respected and I quite
often here stories of people with corrupt tapes - due I suspect to a
worn out tape.
A tape solution should be serviceable for you as long as your respect
the durability of the medium and adhere to manufacturers guidelines.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
G Clark wrote:
> Can anyone suggest what types of hardware I should be using to backup my SQL datab
ase. I currently do a differential each night to a file share, which works well, and
there is no concern for network usage. I wonder if using a tape or perhaps DVD is a
be
tter method. Is a differential backup to DVD even possible?
> Thanks.
database. I currently do a differential each night to a file share, which w
orks well, and there is no concern for network usage. I wonder if using a ta
pe or perhaps DVD is a bett
er method. Is a differential backup to DVD even possible?
Thanks.I personally prefer to backup to a file share overnight and archive that to
tape during the day. I don't bother with differential backups, but that is
due more to my data flow than anything else. Differentials don't really
save me much. Your situation may be different.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.|||So I tend to be of the school of thought that the first, if not the second
and third, generations of backups should be on spinning disk somewhere -
high performance, cheap, simple and for more reliable than any removable
medium. In a multi-server environment it's best to have these on a device
that's independant of a server chassis (NAS or SAN). I consider tape for
disaster recovery from off-site resources _only_. TCO of tape is
astronomical compared to SATA NAS or SAN devices and way more problematic.
"G Clark" <G Clark@.discussions.microsoft.com> wrote in message
news:EA640F28-A688-4A9C-B3C2-0F0C51470A76@.microsoft.com...
> Can anyone suggest what types of hardware I should be using to backup my
SQL database. I currently do a differential each night to a file share,
which works well, and there is no concern for network usage. I wonder if
using a tape or perhaps DVD is a better method. Is a differential backup to
DVD even possible?
> Thanks.|||G Clark,
I like to backup to disk first, then let a tape job run at night to
backup the sql backup files. When selecting backup media you should look
at the durability of the media. I'm not sure how durable DVD media is,
or if it is better than tape. There is certainly a capacity issue with
DVD for me.
Tape manufacturers recommend that a tape not be used more than 20 times
before being discarded. However this is seldom respected and I quite
often here stories of people with corrupt tapes - due I suspect to a
worn out tape.
A tape solution should be serviceable for you as long as your respect
the durability of the medium and adhere to manufacturers guidelines.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
G Clark wrote:
> Can anyone suggest what types of hardware I should be using to backup my SQL datab
ase. I currently do a differential each night to a file share, which works well, and
there is no concern for network usage. I wonder if using a tape or perhaps DVD is a
be
tter method. Is a differential backup to DVD even possible?
> Thanks.
Tuesday, February 14, 2012
Data Transformation in Transactional Replication
I already put this set of questions to another group and oly one person
replied. I would appreciate if other people can share their opinion as well.
Thanks
=====================
I have a transactional replication set up from one system to another.
Subscriber has only read mode on data (Uni-directional Replication). I need
to do lots of transformation in the data while replication from Publisher to
Subcriber Like adding the same record in the other table as well or do some
denormalization etc.
Which route should I choose?
1. Modify Replicaiton procedures to have this business rule in-built.
2. Should I create indexed views and other tables on reporting server.
3. Should I create trigger on the reporting server and have the replication
procedure only do the insert and trigger do rest of the business rules
implementaion.
4. Can reporting services be used for such a transformation.
5. Should I have DTS as a part of replication.
-Nitin
Perhaps you should call PSS and get their input.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:A2EE86E0-024D-4E1D-9051-6144C65B310F@.microsoft.com...
> I already put this set of questions to another group and oly one person
> replied. I would appreciate if other people can share their opinion as
well.
> Thanks
> =====================
> I have a transactional replication set up from one system to another.
> Subscriber has only read mode on data (Uni-directional Replication). I
need
> to do lots of transformation in the data while replication from Publisher
to
> Subcriber Like adding the same record in the other table as well or do
some
> denormalization etc.
> Which route should I choose?
> 1. Modify Replicaiton procedures to have this business rule in-built.
> 2. Should I create indexed views and other tables on reporting server.
> 3. Should I create trigger on the reporting server and have the
replication
> procedure only do the insert and trigger do rest of the business rules
> implementaion.
> 4. Can reporting services be used for such a transformation.
> 5. Should I have DTS as a part of replication.
> -Nitin
replied. I would appreciate if other people can share their opinion as well.
Thanks
=====================
I have a transactional replication set up from one system to another.
Subscriber has only read mode on data (Uni-directional Replication). I need
to do lots of transformation in the data while replication from Publisher to
Subcriber Like adding the same record in the other table as well or do some
denormalization etc.
Which route should I choose?
1. Modify Replicaiton procedures to have this business rule in-built.
2. Should I create indexed views and other tables on reporting server.
3. Should I create trigger on the reporting server and have the replication
procedure only do the insert and trigger do rest of the business rules
implementaion.
4. Can reporting services be used for such a transformation.
5. Should I have DTS as a part of replication.
-Nitin
Perhaps you should call PSS and get their input.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nitin" <Nitin@.discussions.microsoft.com> wrote in message
news:A2EE86E0-024D-4E1D-9051-6144C65B310F@.microsoft.com...
> I already put this set of questions to another group and oly one person
> replied. I would appreciate if other people can share their opinion as
well.
> Thanks
> =====================
> I have a transactional replication set up from one system to another.
> Subscriber has only read mode on data (Uni-directional Replication). I
need
> to do lots of transformation in the data while replication from Publisher
to
> Subcriber Like adding the same record in the other table as well or do
some
> denormalization etc.
> Which route should I choose?
> 1. Modify Replicaiton procedures to have this business rule in-built.
> 2. Should I create indexed views and other tables on reporting server.
> 3. Should I create trigger on the reporting server and have the
replication
> procedure only do the insert and trigger do rest of the business rules
> implementaion.
> 4. Can reporting services be used for such a transformation.
> 5. Should I have DTS as a part of replication.
> -Nitin
Subscribe to:
Posts (Atom)