CODEWITHSUNDEEP
sql-server
user3235408
user3235408

Reputation: 15

SQL Server version issue

This Snapshot is the info of SQL Server Management Studio which am currently running. as you can see its of version 10.50.1600.1 Now when i try to backup a file the below error i get. So it states that i am having a lower version. Can you please advice? Do i have to update? If yes, then how?

Error Snapshot

can you guys please help.

Thanks

Upvotes: 0

Views: 80

Answers (2)

TomTom
TomTom

Reputation: 62093

Se we have t o explain to a programmer the difference between the management studio and the sql server? THe server does not care what version of management studio you run.

In case you do not know it, all you do when you do a backup is send a SQL command to the server. Management studio does nothing regaring the actual restore.

Check your SQL Server versions and upgrade them to at least 10.50.1600 - which would indicate a 2008 R2 version. You currently run 10.00.2531, which indicates 2008 Sp1.

Btw., all builds are here:

http://sqlserverbuilds.blogspot.com/

And, btw., not applying service packs to a database is gross neglect. There are someimtes interesting issues (queries not working) and you seem to have a habit of never patching your system - both, your management studio as well as your server are service packs behind the current patching level.

Upvotes: 1

BAdmin
BAdmin

Reputation: 937

Can you please try generating Script with 'Schema and Data' option and executing that on your destination server.

Upvotes: 0

Related Questions