Hi,
Is it possible to find the date n time when a particular DTS was changed. All that I can see is thecreation date of a DTS :(
Will appreciate your help.Hi, try right-clicking the package and select Versions. it could give you more info on package history. mojza|||Thanks mojza :) That helps and though it says 'create date' I can use this information as the last modification date.
Many thanks once again.
Showing posts with label log. Show all posts
Showing posts with label log. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Can I disable log for a table?
Hi,
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
MaxNo. You can change the recovery model but only at the database level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
Hi,
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
Max|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> No. You can change the recovery model but only at the database level.
True, but to be complete, you can change it to a simple recovery model but
some logging still occurs.
So you can't elimiante it cmopletely.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>|||"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>
You could put the table in its own database and use the Simple Recovery
model in that database. You can then create the reference to that table as a
view or synonym in another database.
Think about the consequences for your data integrity if you ever have to
restore the transaction log.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||You can eliminate logging completely, but you have to place the database in
a read only state to do so.
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.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> True, but to be complete, you can change it to a simple recovery model but
> some logging still occurs.
> So you can't elimiante it cmopletely.
>
>|||"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:u5zmgmcYGHA.4796@.TK2MSFTNGP04.phx.gbl...
> You can eliminate logging completely, but you have to place the database
in
> a read only state to do so.
Details, details. ;-)
But I have to admit that's true.
> --
> 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.
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message
> news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
but[vbcol=seagreen]
server?[vbcol=seagreen]
>
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
MaxNo. You can change the recovery model but only at the database level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
Hi,
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
Max|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> No. You can change the recovery model but only at the database level.
True, but to be complete, you can change it to a simple recovery model but
some logging still occurs.
So you can't elimiante it cmopletely.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>|||"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>
You could put the table in its own database and use the Simple Recovery
model in that database. You can then create the reference to that table as a
view or synonym in another database.
Think about the consequences for your data integrity if you ever have to
restore the transaction log.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||You can eliminate logging completely, but you have to place the database in
a read only state to do so.
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.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> True, but to be complete, you can change it to a simple recovery model but
> some logging still occurs.
> So you can't elimiante it cmopletely.
>
>|||"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:u5zmgmcYGHA.4796@.TK2MSFTNGP04.phx.gbl...
> You can eliminate logging completely, but you have to place the database
in
> a read only state to do so.
Details, details. ;-)
But I have to admit that's true.
> --
> 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.
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message
> news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
but[vbcol=seagreen]
server?[vbcol=seagreen]
>
Can I disable log for a table?
Hi,
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
MaxNo. You can change the recovery model but only at the database level.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
Hi,
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
Max|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> No. You can change the recovery model but only at the database level.
True, but to be complete, you can change it to a simple recovery model but
some logging still occurs.
So you can't elimiante it cmopletely.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>|||"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>
You could put the table in its own database and use the Simple Recovery
model in that database. You can then create the reference to that table as a
view or synonym in another database.
Think about the consequences for your data integrity if you ever have to
restore the transaction log.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||You can eliminate logging completely, but you have to place the database in
a read only state to do so.
--
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.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
>> No. You can change the recovery model but only at the database level.
> True, but to be complete, you can change it to a simple recovery model but
> some logging still occurs.
> So you can't elimiante it cmopletely.
>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
>> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I Oracle we can disable redo log for a table by using this command:
>>
>> ALTER TABLE your_table_name NOLOGGING
>>
>> Do we have such capability in either 2000 or 2005 versions of SQL server?
>>
>> Thanks,
>> Max
>>
>|||"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:u5zmgmcYGHA.4796@.TK2MSFTNGP04.phx.gbl...
> You can eliminate logging completely, but you have to place the database
in
> a read only state to do so.
Details, details. ;-)
But I have to admit that's true.
> --
> 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.
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message
> news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> > news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> >> No. You can change the recovery model but only at the database level.
> >
> > True, but to be complete, you can change it to a simple recovery model
but
> > some logging still occurs.
> >
> > So you can't elimiante it cmopletely.
> >
> >
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> .
> >> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> >> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> >> Hi,
> >>
> >> I Oracle we can disable redo log for a table by using this command:
> >>
> >>
> >>
> >> ALTER TABLE your_table_name NOLOGGING
> >>
> >>
> >>
> >> Do we have such capability in either 2000 or 2005 versions of SQL
server?
> >>
> >>
> >>
> >> Thanks,
> >>
> >> Max
> >>
> >>
> >
> >
>
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
MaxNo. You can change the recovery model but only at the database level.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
Hi,
I Oracle we can disable redo log for a table by using this command:
ALTER TABLE your_table_name NOLOGGING
Do we have such capability in either 2000 or 2005 versions of SQL server?
Thanks,
Max|||"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> No. You can change the recovery model but only at the database level.
True, but to be complete, you can change it to a simple recovery model but
some logging still occurs.
So you can't elimiante it cmopletely.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>|||"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I Oracle we can disable redo log for a table by using this command:
>
> ALTER TABLE your_table_name NOLOGGING
>
> Do we have such capability in either 2000 or 2005 versions of SQL server?
>
> Thanks,
> Max
>
You could put the table in its own database and use the Simple Recovery
model in that database. You can then create the reference to that table as a
view or synonym in another database.
Think about the consequences for your data integrity if you ever have to
restore the transaction log.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||You can eliminate logging completely, but you have to place the database in
a read only state to do so.
--
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.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
>> No. You can change the recovery model but only at the database level.
> True, but to be complete, you can change it to a simple recovery model but
> some logging still occurs.
> So you can't elimiante it cmopletely.
>
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
>> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I Oracle we can disable redo log for a table by using this command:
>>
>> ALTER TABLE your_table_name NOLOGGING
>>
>> Do we have such capability in either 2000 or 2005 versions of SQL server?
>>
>> Thanks,
>> Max
>>
>|||"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:u5zmgmcYGHA.4796@.TK2MSFTNGP04.phx.gbl...
> You can eliminate logging completely, but you have to place the database
in
> a read only state to do so.
Details, details. ;-)
But I have to admit that's true.
> --
> 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.
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
message
> news:e7sg7xaYGHA.4688@.TK2MSFTNGP04.phx.gbl...
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> > news:u3H$8laYGHA.1204@.TK2MSFTNGP04.phx.gbl...
> >> No. You can change the recovery model but only at the database level.
> >
> > True, but to be complete, you can change it to a simple recovery model
but
> > some logging still occurs.
> >
> > So you can't elimiante it cmopletely.
> >
> >
> >>
> >> --
> >> Tom
> >>
> >> ----
> >> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> >> SQL Server MVP
> >> Toronto, ON Canada
> >> .
> >> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> >> news:O7XrOfaYGHA.3448@.TK2MSFTNGP04.phx.gbl...
> >> Hi,
> >>
> >> I Oracle we can disable redo log for a table by using this command:
> >>
> >>
> >>
> >> ALTER TABLE your_table_name NOLOGGING
> >>
> >>
> >>
> >> Do we have such capability in either 2000 or 2005 versions of SQL
server?
> >>
> >>
> >>
> >> Thanks,
> >>
> >> Max
> >>
> >>
> >
> >
>
Thursday, March 22, 2012
Can I delete Transaction log on subscriber
Hi,
One of our subscriber server is full due to transaction
log too large. The replication was failed without no
space for the transaction log. My question is can I
delete the transation log? Or is there any way I can free
some space on that subscriber server? Please help me.
p.s. we do full backup on our publisher server every day.
Thanks,
While you can delete it I would urge you not to do this. By shutting down
SQL Server and deleting the actual log physical file is a bad idea, although
in some people have claimed to be able to do it, I have never been able to.
I hope you mean truncating it and perhaps shrinking the log file. This is a
better option.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Ping" <anonymous@.discussions.microsoft.com> wrote in message
news:228501c506fc$0ecd0690$a401280a@.phx.gbl...
> Hi,
> One of our subscriber server is full due to transaction
> log too large. The replication was failed without no
> space for the transaction log. My question is can I
> delete the transation log? Or is there any way I can free
> some space on that subscriber server? Please help me.
> p.s. we do full backup on our publisher server every day.
> Thanks,
|||Hi hilary,
Thanks for your reply.
Regarding truncating and shrinking, which one do you
recommend?
Tks
>--Original Message--
>While you can delete it I would urge you not to do this.
By shutting down
>SQL Server and deleting the actual log physical file is a
bad idea, although
>in some people have claimed to be able to do it, I have
never been able to.
>I hope you mean truncating it and perhaps shrinking the
log file. This is a
>better option.
>--
>Hilary Cotter
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>"Ping" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:228501c506fc$0ecd0690$a401280a@.phx.gbl...
free[vbcol=seagreen]
day.
>
>.
>
One of our subscriber server is full due to transaction
log too large. The replication was failed without no
space for the transaction log. My question is can I
delete the transation log? Or is there any way I can free
some space on that subscriber server? Please help me.
p.s. we do full backup on our publisher server every day.
Thanks,
While you can delete it I would urge you not to do this. By shutting down
SQL Server and deleting the actual log physical file is a bad idea, although
in some people have claimed to be able to do it, I have never been able to.
I hope you mean truncating it and perhaps shrinking the log file. This is a
better option.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Ping" <anonymous@.discussions.microsoft.com> wrote in message
news:228501c506fc$0ecd0690$a401280a@.phx.gbl...
> Hi,
> One of our subscriber server is full due to transaction
> log too large. The replication was failed without no
> space for the transaction log. My question is can I
> delete the transation log? Or is there any way I can free
> some space on that subscriber server? Please help me.
> p.s. we do full backup on our publisher server every day.
> Thanks,
|||Hi hilary,
Thanks for your reply.
Regarding truncating and shrinking, which one do you
recommend?
Tks
>--Original Message--
>While you can delete it I would urge you not to do this.
By shutting down
>SQL Server and deleting the actual log physical file is a
bad idea, although
>in some people have claimed to be able to do it, I have
never been able to.
>I hope you mean truncating it and perhaps shrinking the
log file. This is a
>better option.
>--
>Hilary Cotter
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>"Ping" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:228501c506fc$0ecd0690$a401280a@.phx.gbl...
free[vbcol=seagreen]
day.
>
>.
>
Tuesday, March 20, 2012
Can I combine Log Shipping and Clustering?
SQL Server 2005 SP2
Certainly. They're two completely unrelated features.
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Can I combine Log Shipping and Clustering? That is, can I
ship logs from the primary node in my cluster to an offsite
warm standby SQL server box?
Any help appreciated.
TIA
aj"aj" <ronald@.mcdonalds.comwrote in message
news:13k3vep1gmodlec@.news.supernews.com...
Quote:
Originally Posted by
SQL Server 2005 SP2
>
Can I combine Log Shipping and Clustering? That is, can I
ship logs from the primary node in my cluster to an offsite
warm standby SQL server box?
>
Certainly. They're two completely unrelated features.
And it's fairly common to in fact do what you propose.
Quote:
Originally Posted by
Any help appreciated.
>
TIA
>
aj
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Can I Clear SQL Event Log
Hi,
Is there a way to clear the SQL Server Event Log without
stopping/starting the SQL service? I am running SQL Server 2000. I am
not talking about the transaction logs.
Thank You.
DanHi Dan
I assume you are talking about the SQL Server error log. You cannot clear
the log, but you can start a new one, by using the procedure
sp_cycle_errorlog.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Dan" <moro0012@.yahoo.com> wrote in message
news:1136338503.760968.10520@.f14g2000cwb.googlegroups.com...
> Hi,
> Is there a way to clear the SQL Server Event Log without
> stopping/starting the SQL service? I am running SQL Server 2000. I am
> not talking about the transaction logs.
> Thank You.
> Dan
>
Is there a way to clear the SQL Server Event Log without
stopping/starting the SQL service? I am running SQL Server 2000. I am
not talking about the transaction logs.
Thank You.
DanHi Dan
I assume you are talking about the SQL Server error log. You cannot clear
the log, but you can start a new one, by using the procedure
sp_cycle_errorlog.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Dan" <moro0012@.yahoo.com> wrote in message
news:1136338503.760968.10520@.f14g2000cwb.googlegroups.com...
> Hi,
> Is there a way to clear the SQL Server Event Log without
> stopping/starting the SQL service? I am running SQL Server 2000. I am
> not talking about the transaction logs.
> Thank You.
> Dan
>
Monday, March 19, 2012
can I bring roll back a trasaction log
I am building a test environment. My objective is to be able to bring the
test database from different stage within 15 minutes. The database mdf file
is 6G and the log file is 500M after truncated. The data is updated not
using transaction commit command.
Existing Plan
1/ prepare a full backup of the database to a file called
FullBackup.bak
2/ at each hour , do a transaction log backup. e.g
job1.trn
3/ I restore the database by applying the full backup bak and individual
transaction.log . But the whole process takes about one hour which does not
meet the requirement to bring back the database within 15 minutes.
Question:
1/ consider the following:
8:00 am full backup
9:00 am transaction log backup job 1
10:00am transaction log backup job 2
11:00am transaction log backup job 3
I need to bring back the database at 9:59am.
Is it a way to apply the transaction log so that the database can undo the
change based on the job3 transaction log, job 2 transaction log?
or
2/ What other way can allow me to bring back a data base at different stage
within 15 minutes?
3/ How to find out what database has been modified every one hour? and
what data has been added/deleted/edited.
Regards
SMS1
Hi
1. If you need to bring a database back to 9:59am, you need to restore the
last good full backup and all the transaction logs after that, including the
10:00am one, up to the time you need. See "point in time recovery" in BOL
2. This is the only option, as transaction logs can be restored to an exact
point in time.
3. Look at the commercial products LogPI or Log Explorer to examine log files.
Cheers
Mike
"sms" wrote:
> I am building a test environment. My objective is to be able to bring the
> test database from different stage within 15 minutes. The database mdf file
> is 6G and the log file is 500M after truncated. The data is updated not
> using transaction commit command.
> Existing Plan
> 1/ prepare a full backup of the database to a file called
> FullBackup.bak
> 2/ at each hour , do a transaction log backup. e.g
> job1.trn
> 3/ I restore the database by applying the full backup bak and individual
> transaction.log . But the whole process takes about one hour which does not
> meet the requirement to bring back the database within 15 minutes.
> Question:
> 1/ consider the following:
> 8:00 am full backup
> 9:00 am transaction log backup job 1
> 10:00am transaction log backup job 2
> 11:00am transaction log backup job 3
> I need to bring back the database at 9:59am.
> Is it a way to apply the transaction log so that the database can undo the
> change based on the job3 transaction log, job 2 transaction log?
> or
> 2/ What other way can allow me to bring back a data base at different stage
> within 15 minutes?
>
> 3/ How to find out what database has been modified every one hour? and
> what data has been added/deleted/edited.
> Regards
> SMS1
>
>
|||Depending on your disk configurations, you might reduce the backup and
recovery times by striping your backup files e.g.
BACKUP DATABASE pubs TO DISK = 'f:\backups\pubs1.bak', DISK =
'f:\backups\pubs2.bak' ...
When you mentioned that the recovery took 1 hour, did you delete the
database before restoring it? If you did, try restoring without first
deleting the database. It would save some time as it avoids having SQL
Server create a 6 Gig file before the restore process actually starts.
Lastly, depending again on your hardware configuration, you can reduce
backup and restore times by using backup software that works with compressed
SQL Server backup files e.g. our product, MiniSQLBackup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
"sms" <sms1@.pctc.com> wrote in message
news:vsg4d.2575$KF.20421@.tor-nn1.netcom.ca...
> I am building a test environment. My objective is to be able to bring the
> test database from different stage within 15 minutes. The database mdf
file
> is 6G and the log file is 500M after truncated. The data is updated not
> using transaction commit command.
> Existing Plan
> 1/ prepare a full backup of the database to a file called
> FullBackup.bak
> 2/ at each hour , do a transaction log backup. e.g
> job1.trn
> 3/ I restore the database by applying the full backup bak and individual
> transaction.log . But the whole process takes about one hour which does
not
> meet the requirement to bring back the database within 15 minutes.
> Question:
> 1/ consider the following:
> 8:00 am full backup
> 9:00 am transaction log backup job 1
> 10:00am transaction log backup job 2
> 11:00am transaction log backup job 3
> I need to bring back the database at 9:59am.
> Is it a way to apply the transaction log so that the database can undo the
> change based on the job3 transaction log, job 2 transaction log?
> or
> 2/ What other way can allow me to bring back a data base at different
stage
> within 15 minutes?
>
> 3/ How to find out what database has been modified every one hour? and
> what data has been added/deleted/edited.
> Regards
> SMS1
>
test database from different stage within 15 minutes. The database mdf file
is 6G and the log file is 500M after truncated. The data is updated not
using transaction commit command.
Existing Plan
1/ prepare a full backup of the database to a file called
FullBackup.bak
2/ at each hour , do a transaction log backup. e.g
job1.trn
3/ I restore the database by applying the full backup bak and individual
transaction.log . But the whole process takes about one hour which does not
meet the requirement to bring back the database within 15 minutes.
Question:
1/ consider the following:
8:00 am full backup
9:00 am transaction log backup job 1
10:00am transaction log backup job 2
11:00am transaction log backup job 3
I need to bring back the database at 9:59am.
Is it a way to apply the transaction log so that the database can undo the
change based on the job3 transaction log, job 2 transaction log?
or
2/ What other way can allow me to bring back a data base at different stage
within 15 minutes?
3/ How to find out what database has been modified every one hour? and
what data has been added/deleted/edited.
Regards
SMS1
Hi
1. If you need to bring a database back to 9:59am, you need to restore the
last good full backup and all the transaction logs after that, including the
10:00am one, up to the time you need. See "point in time recovery" in BOL
2. This is the only option, as transaction logs can be restored to an exact
point in time.
3. Look at the commercial products LogPI or Log Explorer to examine log files.
Cheers
Mike
"sms" wrote:
> I am building a test environment. My objective is to be able to bring the
> test database from different stage within 15 minutes. The database mdf file
> is 6G and the log file is 500M after truncated. The data is updated not
> using transaction commit command.
> Existing Plan
> 1/ prepare a full backup of the database to a file called
> FullBackup.bak
> 2/ at each hour , do a transaction log backup. e.g
> job1.trn
> 3/ I restore the database by applying the full backup bak and individual
> transaction.log . But the whole process takes about one hour which does not
> meet the requirement to bring back the database within 15 minutes.
> Question:
> 1/ consider the following:
> 8:00 am full backup
> 9:00 am transaction log backup job 1
> 10:00am transaction log backup job 2
> 11:00am transaction log backup job 3
> I need to bring back the database at 9:59am.
> Is it a way to apply the transaction log so that the database can undo the
> change based on the job3 transaction log, job 2 transaction log?
> or
> 2/ What other way can allow me to bring back a data base at different stage
> within 15 minutes?
>
> 3/ How to find out what database has been modified every one hour? and
> what data has been added/deleted/edited.
> Regards
> SMS1
>
>
|||Depending on your disk configurations, you might reduce the backup and
recovery times by striping your backup files e.g.
BACKUP DATABASE pubs TO DISK = 'f:\backups\pubs1.bak', DISK =
'f:\backups\pubs2.bak' ...
When you mentioned that the recovery took 1 hour, did you delete the
database before restoring it? If you did, try restoring without first
deleting the database. It would save some time as it avoids having SQL
Server create a 6 Gig file before the restore process actually starts.
Lastly, depending again on your hardware configuration, you can reduce
backup and restore times by using backup software that works with compressed
SQL Server backup files e.g. our product, MiniSQLBackup.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
"sms" <sms1@.pctc.com> wrote in message
news:vsg4d.2575$KF.20421@.tor-nn1.netcom.ca...
> I am building a test environment. My objective is to be able to bring the
> test database from different stage within 15 minutes. The database mdf
file
> is 6G and the log file is 500M after truncated. The data is updated not
> using transaction commit command.
> Existing Plan
> 1/ prepare a full backup of the database to a file called
> FullBackup.bak
> 2/ at each hour , do a transaction log backup. e.g
> job1.trn
> 3/ I restore the database by applying the full backup bak and individual
> transaction.log . But the whole process takes about one hour which does
not
> meet the requirement to bring back the database within 15 minutes.
> Question:
> 1/ consider the following:
> 8:00 am full backup
> 9:00 am transaction log backup job 1
> 10:00am transaction log backup job 2
> 11:00am transaction log backup job 3
> I need to bring back the database at 9:59am.
> Is it a way to apply the transaction log so that the database can undo the
> change based on the job3 transaction log, job 2 transaction log?
> or
> 2/ What other way can allow me to bring back a data base at different
stage
> within 15 minutes?
>
> 3/ How to find out what database has been modified every one hour? and
> what data has been added/deleted/edited.
> Regards
> SMS1
>
can I bring roll back a trasaction log
I am building a test environment. My objective is to be able to bring the
test database from different stage within 15 minutes. The database mdf file
is 6G and the log file is 500M after truncated. The data is updated not
using transaction commit command.
Existing Plan
1/ prepare a full backup of the database to a file called
FullBackup.bak
2/ at each hour , do a transaction log backup. e.g
job1.trn
3/ I restore the database by applying the full backup bak and individual
transaction.log . But the whole process takes about one hour which does not
meet the requirement to bring back the database within 15 minutes.
Question:
1/ consider the following:
8:00 am full backup
9:00 am transaction log backup job 1
10:00am transaction log backup job 2
11:00am transaction log backup job 3
I need to bring back the database at 9:59am.
Is it a way to apply the transaction log so that the database can undo the
change based on the job3 transaction log, job 2 transaction log?
or
2/ What other way can allow me to bring back a data base at different stage
within 15 minutes?
3/ How to find out what database has been modified every one hour? and
what data has been added/deleted/edited.
Regards
SMS1Depending on your disk configurations, you might reduce the backup and
recovery times by striping your backup files e.g.
BACKUP DATABASE pubs TO DISK = 'f:\backups\pubs1.bak', DISK ='f:\backups\pubs2.bak' ...
When you mentioned that the recovery took 1 hour, did you delete the
database before restoring it? If you did, try restoring without first
deleting the database. It would save some time as it avoids having SQL
Server create a 6 Gig file before the restore process actually starts.
Lastly, depending again on your hardware configuration, you can reduce
backup and restore times by using backup software that works with compressed
SQL Server backup files e.g. our product, MiniSQLBackup.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
"sms" <sms1@.pctc.com> wrote in message
news:vsg4d.2575$KF.20421@.tor-nn1.netcom.ca...
> I am building a test environment. My objective is to be able to bring the
> test database from different stage within 15 minutes. The database mdf
file
> is 6G and the log file is 500M after truncated. The data is updated not
> using transaction commit command.
> Existing Plan
> 1/ prepare a full backup of the database to a file called
> FullBackup.bak
> 2/ at each hour , do a transaction log backup. e.g
> job1.trn
> 3/ I restore the database by applying the full backup bak and individual
> transaction.log . But the whole process takes about one hour which does
not
> meet the requirement to bring back the database within 15 minutes.
> Question:
> 1/ consider the following:
> 8:00 am full backup
> 9:00 am transaction log backup job 1
> 10:00am transaction log backup job 2
> 11:00am transaction log backup job 3
> I need to bring back the database at 9:59am.
> Is it a way to apply the transaction log so that the database can undo the
> change based on the job3 transaction log, job 2 transaction log?
> or
> 2/ What other way can allow me to bring back a data base at different
stage
> within 15 minutes?
>
> 3/ How to find out what database has been modified every one hour? and
> what data has been added/deleted/edited.
> Regards
> SMS1
>|||Hi
1. If you need to bring a database back to 9:59am, you need to restore the
last good full backup and all the transaction logs after that, including the
10:00am one, up to the time you need. See "point in time recovery" in BOL
2. This is the only option, as transaction logs can be restored to an exact
point in time.
3. Look at the commercial products LogPI or Log Explorer to examine log files.
Cheers
Mike
"sms" wrote:
> I am building a test environment. My objective is to be able to bring the
> test database from different stage within 15 minutes. The database mdf file
> is 6G and the log file is 500M after truncated. The data is updated not
> using transaction commit command.
> Existing Plan
> 1/ prepare a full backup of the database to a file called
> FullBackup.bak
> 2/ at each hour , do a transaction log backup. e.g
> job1.trn
> 3/ I restore the database by applying the full backup bak and individual
> transaction.log . But the whole process takes about one hour which does not
> meet the requirement to bring back the database within 15 minutes.
> Question:
> 1/ consider the following:
> 8:00 am full backup
> 9:00 am transaction log backup job 1
> 10:00am transaction log backup job 2
> 11:00am transaction log backup job 3
> I need to bring back the database at 9:59am.
> Is it a way to apply the transaction log so that the database can undo the
> change based on the job3 transaction log, job 2 transaction log?
> or
> 2/ What other way can allow me to bring back a data base at different stage
> within 15 minutes?
>
> 3/ How to find out what database has been modified every one hour? and
> what data has been added/deleted/edited.
> Regards
> SMS1
>
>
test database from different stage within 15 minutes. The database mdf file
is 6G and the log file is 500M after truncated. The data is updated not
using transaction commit command.
Existing Plan
1/ prepare a full backup of the database to a file called
FullBackup.bak
2/ at each hour , do a transaction log backup. e.g
job1.trn
3/ I restore the database by applying the full backup bak and individual
transaction.log . But the whole process takes about one hour which does not
meet the requirement to bring back the database within 15 minutes.
Question:
1/ consider the following:
8:00 am full backup
9:00 am transaction log backup job 1
10:00am transaction log backup job 2
11:00am transaction log backup job 3
I need to bring back the database at 9:59am.
Is it a way to apply the transaction log so that the database can undo the
change based on the job3 transaction log, job 2 transaction log?
or
2/ What other way can allow me to bring back a data base at different stage
within 15 minutes?
3/ How to find out what database has been modified every one hour? and
what data has been added/deleted/edited.
Regards
SMS1Depending on your disk configurations, you might reduce the backup and
recovery times by striping your backup files e.g.
BACKUP DATABASE pubs TO DISK = 'f:\backups\pubs1.bak', DISK ='f:\backups\pubs2.bak' ...
When you mentioned that the recovery took 1 hour, did you delete the
database before restoring it? If you did, try restoring without first
deleting the database. It would save some time as it avoids having SQL
Server create a 6 Gig file before the restore process actually starts.
Lastly, depending again on your hardware configuration, you can reduce
backup and restore times by using backup software that works with compressed
SQL Server backup files e.g. our product, MiniSQLBackup.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!
"sms" <sms1@.pctc.com> wrote in message
news:vsg4d.2575$KF.20421@.tor-nn1.netcom.ca...
> I am building a test environment. My objective is to be able to bring the
> test database from different stage within 15 minutes. The database mdf
file
> is 6G and the log file is 500M after truncated. The data is updated not
> using transaction commit command.
> Existing Plan
> 1/ prepare a full backup of the database to a file called
> FullBackup.bak
> 2/ at each hour , do a transaction log backup. e.g
> job1.trn
> 3/ I restore the database by applying the full backup bak and individual
> transaction.log . But the whole process takes about one hour which does
not
> meet the requirement to bring back the database within 15 minutes.
> Question:
> 1/ consider the following:
> 8:00 am full backup
> 9:00 am transaction log backup job 1
> 10:00am transaction log backup job 2
> 11:00am transaction log backup job 3
> I need to bring back the database at 9:59am.
> Is it a way to apply the transaction log so that the database can undo the
> change based on the job3 transaction log, job 2 transaction log?
> or
> 2/ What other way can allow me to bring back a data base at different
stage
> within 15 minutes?
>
> 3/ How to find out what database has been modified every one hour? and
> what data has been added/deleted/edited.
> Regards
> SMS1
>|||Hi
1. If you need to bring a database back to 9:59am, you need to restore the
last good full backup and all the transaction logs after that, including the
10:00am one, up to the time you need. See "point in time recovery" in BOL
2. This is the only option, as transaction logs can be restored to an exact
point in time.
3. Look at the commercial products LogPI or Log Explorer to examine log files.
Cheers
Mike
"sms" wrote:
> I am building a test environment. My objective is to be able to bring the
> test database from different stage within 15 minutes. The database mdf file
> is 6G and the log file is 500M after truncated. The data is updated not
> using transaction commit command.
> Existing Plan
> 1/ prepare a full backup of the database to a file called
> FullBackup.bak
> 2/ at each hour , do a transaction log backup. e.g
> job1.trn
> 3/ I restore the database by applying the full backup bak and individual
> transaction.log . But the whole process takes about one hour which does not
> meet the requirement to bring back the database within 15 minutes.
> Question:
> 1/ consider the following:
> 8:00 am full backup
> 9:00 am transaction log backup job 1
> 10:00am transaction log backup job 2
> 11:00am transaction log backup job 3
> I need to bring back the database at 9:59am.
> Is it a way to apply the transaction log so that the database can undo the
> change based on the job3 transaction log, job 2 transaction log?
> or
> 2/ What other way can allow me to bring back a data base at different stage
> within 15 minutes?
>
> 3/ How to find out what database has been modified every one hour? and
> what data has been added/deleted/edited.
> Regards
> SMS1
>
>
Thursday, March 8, 2012
Can data be retrieved from a SQL LDF file (Log)
I have a database that has a corrupt .MDF file, but
the .LDF file is still accessible. My most recent backup
is a week old. My question is: After I re-create the
database, is there any way I can recover the past weeks
transactions from the .LDF file. No transaction dump has
been done since the last backup, so I would think that
theoretically the week's transactions are still in the LDF
file.If you haven't done any transaction log backups since the most recent
database backup you can now backup the log, restore the full backup and then
restore the transaction log backup.
See Books Online for the details.
--
Jacco Schalkwijk
SQL Server MVP
"SteveB" <steve_brooks@.adp.com> wrote in message
news:430d01c39e52$c1fa2950$7d02280a@.phx.gbl...
> I have a database that has a corrupt .MDF file, but
> the .LDF file is still accessible. My most recent backup
> is a week old. My question is: After I re-create the
> database, is there any way I can recover the past weeks
> transactions from the .LDF file. No transaction dump has
> been done since the last backup, so I would think that
> theoretically the week's transactions are still in the LDF
> file.|||"SteveB" <steve_brooks@.adp.com> wrote in message
news:430d01c39e52$c1fa2950$7d02280a@.phx.gbl...
> I have a database that has a corrupt .MDF file, but
> the .LDF file is still accessible. My most recent backup
> is a week old. My question is: After I re-create the
> database, is there any way I can recover the past weeks
> transactions from the .LDF file. No transaction dump has
> been done since the last backup, so I would think that
> theoretically the week's transactions are still in the LDF
> file.
Yes.
Before restoring back up your log with NOTRUNCATE
BACKUP LOG mydb
TO mydevice1
WITH NOTRUNCATE
RESTORE DATABASE mydb
FROM mydevice2
WITH RESTORE.
That should roll your log file forward.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003
the .LDF file is still accessible. My most recent backup
is a week old. My question is: After I re-create the
database, is there any way I can recover the past weeks
transactions from the .LDF file. No transaction dump has
been done since the last backup, so I would think that
theoretically the week's transactions are still in the LDF
file.If you haven't done any transaction log backups since the most recent
database backup you can now backup the log, restore the full backup and then
restore the transaction log backup.
See Books Online for the details.
--
Jacco Schalkwijk
SQL Server MVP
"SteveB" <steve_brooks@.adp.com> wrote in message
news:430d01c39e52$c1fa2950$7d02280a@.phx.gbl...
> I have a database that has a corrupt .MDF file, but
> the .LDF file is still accessible. My most recent backup
> is a week old. My question is: After I re-create the
> database, is there any way I can recover the past weeks
> transactions from the .LDF file. No transaction dump has
> been done since the last backup, so I would think that
> theoretically the week's transactions are still in the LDF
> file.|||"SteveB" <steve_brooks@.adp.com> wrote in message
news:430d01c39e52$c1fa2950$7d02280a@.phx.gbl...
> I have a database that has a corrupt .MDF file, but
> the .LDF file is still accessible. My most recent backup
> is a week old. My question is: After I re-create the
> database, is there any way I can recover the past weeks
> transactions from the .LDF file. No transaction dump has
> been done since the last backup, so I would think that
> theoretically the week's transactions are still in the LDF
> file.
Yes.
Before restoring back up your log with NOTRUNCATE
BACKUP LOG mydb
TO mydevice1
WITH NOTRUNCATE
RESTORE DATABASE mydb
FROM mydevice2
WITH RESTORE.
That should roll your log file forward.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003
Saturday, February 25, 2012
Can anyone Help me ?
Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
sam
Let me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>
|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>
|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
[vbcol=seagreen]
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
sam
Let me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>
|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>
|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
[vbcol=seagreen]
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegr oups.com...
Can anyone Help me ?
Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> > Hi all,
> >
> > I am very new to SQL Server 2000
> > my problem is that to connect to sql server from a client computer
> > first i have to log in to the system in which the sql server is
> > installed
> > is it possible that i dont have to login to the computer
> > so that i just open the query analyzer and just login with the sql
> > server user account i dont want to give the login & the password of the
> > windows
> >
> >
> > can any one help me in this
> > is this possible
> >
> > sam
> >
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doamin
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able to
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> > Hi all,
> >
> > I am very new to SQL Server 2000
> > my problem is that to connect to sql server from a client computer
> > first i have to log in to the system in which the sql server is
> > installed
> > is it possible that i dont have to login to the computer
> > so that i just open the query analyzer and just login with the sql
> > server user account i dont want to give the login & the password of the
> > windows
> >
> >
> > can any one help me in this
> > is this possible
> >
> > sam
> >
Can anyone Help me ?
Hi all,
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
[vbcol=seagreen]
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doami
n
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able t
o
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
I am very new to SQL Server 2000
my problem is that to connect to sql server from a client computer
first i have to log in to the system in which the sql server is
installed
is it possible that i dont have to login to the computer
so that i just open the query analyzer and just login with the sql
server user account i dont want to give the login & the password of the
windows
can any one help me in this
is this possible
samLet me try to understand your question. You seem to be saying that to be
able to get access to SQL server you have to access the machine SQL Server
runs on (ie by standing beside it, or by remote control software) and then
get access?
If so, you should be able to access that SQL Server remotely via Query
Analyzer as long as your Windows Account has a login to that SQL Server and
you are using Windows Authentication in Query Analyzer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Hello Sam,
To do this; First of all you should be in the same domain or trusted doamin
the sql server exists. After that you will have to ask the SQL Server DBA
to add your windows login into sql server. After this you should be able to
login to sql server using the windows authentication.
Thanks
Hari
"sam" <sameersrivastava2k@.gmail.com> wrote in message
news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
> Hi all,
> I am very new to SQL Server 2000
> my problem is that to connect to sql server from a client computer
> first i have to log in to the system in which the sql server is
> installed
> is it possible that i dont have to login to the computer
> so that i just open the query analyzer and just login with the sql
> server user account i dont want to give the login & the password of the
> windows
>
> can any one help me in this
> is this possible
> sam
>|||Thanks for your consideration
it helped me a lot
Hari Prasad wrote:
[vbcol=seagreen]
> Hello Sam,
> To do this; First of all you should be in the same domain or trusted doami
n
> the sql server exists. After that you will have to ask the SQL Server DBA
> to add your windows login into sql server. After this you should be able t
o
> login to sql server using the windows authentication.
> Thanks
> Hari
>
> "sam" <sameersrivastava2k@.gmail.com> wrote in message
> news:1168268905.771075.208620@.s34g2000cwa.googlegroups.com...
Sunday, February 19, 2012
Can a SQL Server database be access without having to log onto the server?
One of my client website got hack into and the web application that I created for them is disabled/block externally. Only internally within their business, they will be able to access it. The person that is maintaining the server say, a hacker went straight to the database without having to log onto the server. The person that is maintaining the server is blaming on my web application, which no one has access to view the page except internally within the client work location.
Is this is posibble if the server is secure?
Both scenarios are possible. Hacker might have gotten access to your database or got in through your app via SQL Injection attack. Do you use parameterized queries in your application?
|||The queries is within the code-behind page, I didn't use stored procedured. But yes, it is paramaterize queries. How can a hacker be able to access a database without logging onto the database? Also, how a hacker be able to do an SQL Injection when all administrative webpage(within "admin" folder) is disable/block to all external users. Only the website is shown to external users and internal users is allow to view the administrative webpage. Sorry, if I didn't explain everything. For example, when accessing this: www.mywebsite.com/admin , it would show...
You are not authorized to view this page
The Web server you are attempting to reach has a list of IP addresses that are not allowed to access the Web site, and the IP address of your browsing computer is on this list.
Please try the following:
Contact the Web site administrator if you believe you should be able to view this directory or page.|||Its very well possible. Do a google search for "SQL Injection attack".
Subscribe to:
Posts (Atom)