February 22, 2009 at 10:42 pm
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.
February 22, 2009 at 11:16 pm
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?
February 23, 2009 at 12:17 am
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.
February 23, 2009 at 12:49 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 23, 2009 at 12:55 am
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.
February 23, 2009 at 1:47 am
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..
February 23, 2009 at 7:18 am
What version of SQL do you have on your home PC? (run SELECT @@version)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 23, 2009 at 10:30 pm
Hi,
I have Micorsoft SQL server 2005 standard edition. 32 bit.
After installing it I UNINSTALLED SQL Server 2000 which was already there.
February 24, 2009 at 1:15 am
What does SELECT @@version return?
What querying tool are you using?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply