Any help would be welcomed!

I'm using DMO library.
I'm struggling and pulling out my hair trying to find the XXXX.. property
for the Recovery Model (simple, full,
Server.Databases.Item1....
Does anyone here have
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)Seems to be a Property of the DBOption2 object.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
> I'm using DMO library.
> I'm struggling and pulling out my hair trying to find the XXXX.. property
> for the Recovery Model (simple, full,
> Server.Databases.Item1....
> Does anyone here have
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''''s hard to provide informati
on
> without seeing the code. location: Alicante (ES)|||jezz, seeing on dmo I have only:
server.databases.item.dboption...
!!
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"Tibor Karaszi" wrote:

> Seems to be a Property of the DBOption2 object.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
>|||I'm sorry...I've got it
Dim oss1 As SQLDMO.DBOption2
?oss1.RecoveryModel
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"Tibor Karaszi" wrote:

> Seems to be a Property of the DBOption2 object.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@.microsoft.com...
>

Any help welcomed

Hello all,

I have a SQL 2000 database running on a clustered server. The server domain has recently been changed and may/may not be the cause of my problem. The problem arising is that whenever I backup my database using Enterprise Manager or Query analyser the operation is said to have completed successfully (although looking at the progress bar - which doesn't show the blue status bars moving - this suggestes different). The backup will not then restore or indeed any other backup will not restore, and the database is left in a loading state and never moves away from this.

Any help or suggestions will be greatly appreciated.

Thanks

Richardhttp://support.microsoft.com/newsgroups/default.aspx?NewsGroup=microsoft.public.sqlserver. mseq&SLCID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups

go to clustering