Showing posts with label restored. Show all posts
Showing posts with label restored. Show all posts

Sunday, March 11, 2012

Backward compatiblity in sqlserver 05 Enterprise edition

Hi,
I believe I'm running into a backward compatibility issue with the sqlserver
05 Enterprise edition. I restored a database from sqlserver 2000 to my new
sqlserver 2005. Both of my .net project and Access gets time-out errors
(running remotely) when they try to access to a table that I have modified
via query analyzer in sqlserver 2005. I had no problem reading the table via
those clients before I touched its data, so it looks like modifying data in
those table creating an incompatiblity issue.
Has anybody run into similar situation before? Thank you very much in
advance for your help!Never mind. I had a transaction failed to commit or rollback because of a
fatal error and so my subsequence data modification statements would just
lock up the tables.
"Zen" <zen@.nononospam.com> wrote in message
news:eKrY0y3fGHA.5092@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I believe I'm running into a backward compatibility issue with the
> sqlserver 05 Enterprise edition. I restored a database from sqlserver 2000
> to my new sqlserver 2005. Both of my .net project and Access gets
> time-out errors (running remotely) when they try to access to a table that
> I have modified via query analyzer in sqlserver 2005. I had no problem
> reading the table via those clients before I touched its data, so it looks
> like modifying data in those table creating an incompatiblity issue.
> Has anybody run into similar situation before? Thank you very much in
> advance for your help!
>

Backward compatiblity in sqlserver 05 Enterprise edition

Hi,
I believe I'm running into a backward compatibility issue with the sqlserver
05 Enterprise edition. I restored a database from sqlserver 2000 to my new
sqlserver 2005. Both of my .net project and Access gets time-out errors
(running remotely) when they try to access to a table that I have modified
via query analyzer in sqlserver 2005. I had no problem reading the table via
those clients before I touched its data, so it looks like modifying data in
those table creating an incompatiblity issue.
Has anybody run into similar situation before? Thank you very much in
advance for your help!Never mind. I had a transaction failed to commit or rollback because of a
fatal error and so my subsequence data modification statements would just
lock up the tables.
"Zen" <zen@.nononospam.com> wrote in message
news:eKrY0y3fGHA.5092@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I believe I'm running into a backward compatibility issue with the
> sqlserver 05 Enterprise edition. I restored a database from sqlserver 2000
> to my new sqlserver 2005. Both of my .net project and Access gets
> time-out errors (running remotely) when they try to access to a table that
> I have modified via query analyzer in sqlserver 2005. I had no problem
> reading the table via those clients before I touched its data, so it looks
> like modifying data in those table creating an incompatiblity issue.
> Has anybody run into similar situation before? Thank you very much in
> advance for your help!
>

Monday, February 13, 2012

backup views?

Hi,
I have in one database about 300 views. I have just backed up this database
and restored it with a different name. I have to drop all views from the
first database and the plan is to use the backed up database to restore the
views. How do I do this? If I use DTS, will data be ovewritten from the 2nd
database to the first one?
thanks,
aolxp
Hi,
You can not restore only the view from the database backup.
View will not hold any data until or unless u are using Indexed view. So you
can very well overwrite the view. Even if it is table in DTS
you have option to Overwrite or Append to existing table.
Thanks
Hari
SQL Server MVP
"aolxp" <sa@.anonymous.com> wrote in message
news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi,
> I have in one database about 300 views. I have just backed up this
> database and restored it with a different name. I have to drop all views
> from the first database and the plan is to use the backed up database to
> restore the views. How do I do this? If I use DTS, will data be ovewritten
> from the 2nd database to the first one?
> thanks,
> aolxp
>
|||Thanks Hari. I will actually delete all the views from the 1st database and
then use the second db to DTS them. No indexed views.
will it be allright?
aolxp
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:O9K4fiJRFHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi,
> You can not restore only the view from the database backup.
> View will not hold any data until or unless u are using Indexed view. So
> you can very well overwrite the view. Even if it is table in DTS
> you have option to Overwrite or Append to existing table.
> Thanks
> Hari
> SQL Server MVP
> "aolxp" <sa@.anonymous.com> wrote in message
> news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
>
|||Hi,
Yes, You can do that.
But best approach is script the views using Enterprise manager from 2nd
database and open query analyzer and execute in first database.
Thanks
Hari
SQL Server MVP
"aolxp" <sa@.anonymous.com> wrote in message
news:uS6kBlJRFHA.2604@.TK2MSFTNGP10.phx.gbl...
> Thanks Hari. I will actually delete all the views from the 1st database
> and then use the second db to DTS them. No indexed views.
> will it be allright?
> aolxp
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:O9K4fiJRFHA.2744@.TK2MSFTNGP10.phx.gbl...
>

backup views?

Hi,
I have in one database about 300 views. I have just backed up this database
and restored it with a different name. I have to drop all views from the
first database and the plan is to use the backed up database to restore the
views. How do I do this? If I use DTS, will data be ovewritten from the 2nd
database to the first one?
thanks,
aolxpHi,
You can not restore only the view from the database backup.
View will not hold any data until or unless u are using Indexed view. So you
can very well overwrite the view. Even if it is table in DTS
you have option to Overwrite or Append to existing table.
Thanks
Hari
SQL Server MVP
"aolxp" <sa@.anonymous.com> wrote in message
news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi,
> I have in one database about 300 views. I have just backed up this
> database and restored it with a different name. I have to drop all views
> from the first database and the plan is to use the backed up database to
> restore the views. How do I do this? If I use DTS, will data be ovewritten
> from the 2nd database to the first one?
> thanks,
> aolxp
>|||Thanks Hari. I will actually delete all the views from the 1st database and
then use the second db to DTS them. No indexed views.
will it be allright?
aolxp
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:O9K4fiJRFHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi,
> You can not restore only the view from the database backup.
> View will not hold any data until or unless u are using Indexed view. So
> you can very well overwrite the view. Even if it is table in DTS
> you have option to Overwrite or Append to existing table.
> Thanks
> Hari
> SQL Server MVP
> "aolxp" <sa@.anonymous.com> wrote in message
> news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
>> Hi,
>> I have in one database about 300 views. I have just backed up this
>> database and restored it with a different name. I have to drop all views
>> from the first database and the plan is to use the backed up database to
>> restore the views. How do I do this? If I use DTS, will data be
>> ovewritten from the 2nd database to the first one?
>> thanks,
>> aolxp
>|||Hi,
Yes, You can do that.
But best approach is script the views using Enterprise manager from 2nd
database and open query analyzer and execute in first database.
Thanks
Hari
SQL Server MVP
"aolxp" <sa@.anonymous.com> wrote in message
news:uS6kBlJRFHA.2604@.TK2MSFTNGP10.phx.gbl...
> Thanks Hari. I will actually delete all the views from the 1st database
> and then use the second db to DTS them. No indexed views.
> will it be allright?
> aolxp
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:O9K4fiJRFHA.2744@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> You can not restore only the view from the database backup.
>> View will not hold any data until or unless u are using Indexed view. So
>> you can very well overwrite the view. Even if it is table in DTS
>> you have option to Overwrite or Append to existing table.
>> Thanks
>> Hari
>> SQL Server MVP
>> "aolxp" <sa@.anonymous.com> wrote in message
>> news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
>> Hi,
>> I have in one database about 300 views. I have just backed up this
>> database and restored it with a different name. I have to drop all views
>> from the first database and the plan is to use the backed up database to
>> restore the views. How do I do this? If I use DTS, will data be
>> ovewritten from the 2nd database to the first one?
>> thanks,
>> aolxp
>>
>

backup views?

Hi,
I have in one database about 300 views. I have just backed up this database
and restored it with a different name. I have to drop all views from the
first database and the plan is to use the backed up database to restore the
views. How do I do this? If I use DTS, will data be ovewritten from the 2nd
database to the first one?
thanks,
aolxpHi,
You can not restore only the view from the database backup.
View will not hold any data until or unless u are using Indexed view. So you
can very well overwrite the view. Even if it is table in DTS
you have option to Overwrite or Append to existing table.
Thanks
Hari
SQL Server MVP
"aolxp" <sa@.anonymous.com> wrote in message
news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
> Hi,
> I have in one database about 300 views. I have just backed up this
> database and restored it with a different name. I have to drop all views
> from the first database and the plan is to use the backed up database to
> restore the views. How do I do this? If I use DTS, will data be ovewritten
> from the 2nd database to the first one?
> thanks,
> aolxp
>|||Thanks Hari. I will actually delete all the views from the 1st database and
then use the second db to DTS them. No indexed views.
will it be allright?
aolxp
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:O9K4fiJRFHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi,
> You can not restore only the view from the database backup.
> View will not hold any data until or unless u are using Indexed view. So
> you can very well overwrite the view. Even if it is table in DTS
> you have option to Overwrite or Append to existing table.
> Thanks
> Hari
> SQL Server MVP
> "aolxp" <sa@.anonymous.com> wrote in message
> news:%23RBtmeJRFHA.3076@.tk2msftngp13.phx.gbl...
>|||Hi,
Yes, You can do that.
But best approach is script the views using Enterprise manager from 2nd
database and open query analyzer and execute in first database.
Thanks
Hari
SQL Server MVP
"aolxp" <sa@.anonymous.com> wrote in message
news:uS6kBlJRFHA.2604@.TK2MSFTNGP10.phx.gbl...
> Thanks Hari. I will actually delete all the views from the 1st database
> and then use the second db to DTS them. No indexed views.
> will it be allright?
> aolxp
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:O9K4fiJRFHA.2744@.TK2MSFTNGP10.phx.gbl...
>

Sunday, February 12, 2012

Backup Transaction fails.

Hi,
I have taken a back up of a database that was under transactional
replication and was the subscriber. I have restored the backup on to another
server as a stand alone database (no replication what so ever).
I am now trying to truncate the transaction log as its taking a whole lot of
space on the disc and want to shrink the file.
I issue the following statement:
BACKUP LOG <databaseName> WITH NO_LOG
when i issue this statement it comes out with the following error:
The log was not truncated because records at the beginning of the log are
pending replication. Ensure the Log Reader Agent is running or use
sp_repldone to mark transactions as distributed.
Is there any way I can get around this and truncate the log file?
Thanks
Vikram
Vikram,
try:
EXEC sp_repldone @.xactid = NULL, @.xact_segno = NULL, @.numtrans = 0, @.time
= 0, @.reset = 1
then truncate the log.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul,
I executed that procedure and came up with the following:
Server: Msg 18757, Level 16, State 1, Procedure sp_repldone, Line 1
The database is not published.
Any clues?
Cheers
Vikram
"Paul Ibison" wrote:

> Vikram,
> try:
> EXEC sp_repldone @.xactid = NULL, @.xact_segno = NULL, @.numtrans = 0, @.time
> = 0, @.reset = 1
> then truncate the log.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||One idea I'd try is to publish the database in TR, run the script, truncate,
then drop the publication.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks very much Paul.
It worked.
thanks a lot.
Cheers
"Paul Ibison" wrote:

> One idea I'd try is to publish the database in TR, run the script, truncate,
> then drop the publication.
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>