Copy Database Error. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Copy Database Error.

Author

Topic

deepusurana
Starting Member

4 Posts

Posted - 2011-04-19 : 01:47:58

Hi,
I am trying to create a copy of Database but getting an error.[URL=http://picturepush.com/public/5484076]

Please let me know the solution. Or let me know if copy of database can be done via script.

Thanks.

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-04-19 : 02:18:51

Tell me your MS sql version.
And where you are copying your database? (means on Diff version of MS SQL If yes then send me version version)

Raghu' S

deepusurana
Starting Member

4 Posts

Posted - 2011-04-19 : 02:41:31

quote:
Originally posted by raghuveer125

Tell me your MS sql version.
And where you are copying your database? (means on Diff version of MS SQL If yes then send me version version)

Raghu' S

Sql Server 2005 Details :
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3615
Operating System 5.1.2600[b]
Also I am trying to copy the database in the same server but with the different name,

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-04-19 : 02:55:36

Which service pack
Run this
select @@version

Raghu' S

deepusurana
Starting Member

4 Posts

Posted - 2011-04-19 : 02:59:14

quote:
Originally posted by raghuveer125

Which service pack
Run this
select @@version

Raghu' S

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-04-19 : 03:03:48

Ok you need to check that your agent service is running or not if running
then next option is
reinstall SP2 or
I think installing sp3 will resolve this issue

Raghu' S

deepusurana
Starting Member

4 Posts

Posted - 2011-04-19 : 04:54:55

quote:
Originally posted by raghuveer125

Ok you need to check that your agent service is running or not if running
then next option is
reinstall SP2 or
I think installing sp3 will resolve this issue

Raghu' S

All the services listed in SQL services are running.
Will try to deploy SP3.

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-04-19 : 05:03:54

Check this link
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4

Raghu' S

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources