Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alter Database DBNAME Set Recovery Full. Gives error. Expand / Collapse
Author
Message
Posted Sunday, February 22, 2009 10:42 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 1,500, Visits: 2,519
Dear All,

I installed SQL Server 2005 in my home PC. SQL server 2000 was allready existing.
I installed SQL 2005 without installing SQL 2000. Will it make any difference..?
Now am facing some problem with below command.

Alter Database DBNAME Set Recovery Full.
I get error 'Incorrect syntax near FULL.
What could be the problem..? Pls help.
Post #662360
Posted Sunday, February 22, 2009 11:16 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
swmsan (2/22/2009)
Dear All,

I installed SQL Server 2005 in my home PC. SQL server 2000 was allready existing.
I installed SQL 2005 without installing SQL 2000. Will it make any difference..?

No, it should not make any difference.


Now am facing some problem with below command.

Alter Database DBNAME Set Recovery Full.
I get error 'Incorrect syntax near FULL.
What could be the problem..? Pls help.


What are you trying to do here?


Post #662364
Posted Monday, February 23, 2009 12:17 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 1,500, Visits: 2,519
Sorry, There was a mistake.
I installed SQL 2005 without UNINSTALLING SQL 2000.

Wel, I was just practising Backup, Restore etc.

I just tried to chage the recovery mode of database and I got the mentioned error.





Post #662378
Posted Monday, February 23, 2009 12:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 42,434, Visits: 35,488
swmsan (2/22/2009)

Alter Database DBNAME Set Recovery Full.
I get error 'Incorrect syntax near FULL.


The syntax is correct. Is that all that was in the query window?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #662393
Posted Monday, February 23, 2009 12:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
swmsan (2/23/2009)
Sorry, There was a mistake.
I installed SQL 2005 without UNINSTALLING SQL 2000.

Wel, I was just practising Backup, Restore etc.

I just tried to chage the recovery mode of database and I got the mentioned error.




Can you just copy and paste the query as it is that your are executing.


Post #662397
Posted Monday, February 23, 2009 1:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 1,500, Visits: 2,519

Yes.. Only that much.
When I tried the same in my office PC it works.

One more thing I noticed that the COLOR of words like
'Alter', 'Database' etc, is blue but color of 'Recovery' & 'Full' remains black. It doesn't get changed. (In my home PC)
In office PC everythig becomes blue..
















Post #662412
Posted Monday, February 23, 2009 7:18 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 42,434, Visits: 35,488
What version of SQL do you have on your home PC? (run SELECT @@version)


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #662554
Posted Monday, February 23, 2009 10:30 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:25 AM
Points: 1,500, Visits: 2,519
Hi,
I have Micorsoft SQL server 2005 standard edition. 32 bit.
After installing it I UNINSTALLED SQL Server 2000 which was already there.

Post #663216
Posted Tuesday, February 24, 2009 1:15 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 42,434, Visits: 35,488
What does SELECT @@version return?
What querying tool are you using?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #663259
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse