BackUp Issue - 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 2008 Forums

Other SQL Server 2008 Topics

BackUp Issue

Author

Topic

Dhanushkodi
Starting Member

21 Posts

Posted - 2013-06-11 : 01:48:09

Hi Everyone,

when I try to back up the database manually or automatically it's get backed up. But while I am restoring it , the Original file name created as master for "mdffile" and masterlog for "ldffile". so its give an error as "Already an object named "sysnobjs" in the database". please help me resolve it.

thanks & regards,
Dhanushkodi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-11 : 02:13:51

are you trying to restore master database?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Dhanushkodi
Starting Member

21 Posts

Posted - 2013-06-11 : 02:23:03

No Visakh, it's just a user database. but i dont know why it's refer master file name.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-11 : 02:32:05

quote:
Originally posted by Dhanushkodi

No Visakh, it's just a user database. but i dont know why it's refer master file name.

Show your backup script please. Problem might be in it.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Dhanushkodi
Starting Member

21 Posts

Posted - 2013-06-11 : 02:48:04

i did not write any script, just right click the database and back up.

another one is scheduling back up. so here it's not any manual. i mentioned wrongly. Sorry for that.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-11 : 02:51:30

quote:
Originally posted by Dhanushkodi

i did not write any script, just right click the database and back up.

another one is scheduling back up. so here it's not any manual. i mentioned wrongly. Sorry for that.

Which database you clicked for backing up? did you click on correct user database?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-11 : 03:00:15

You could use the below to check the logical filenames for your database and see if they're correct


use [master]
GO
select * from sys.master_files
where database_id = DB_ID(N'Your databasename here')

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Dhanushkodi
Starting Member

21 Posts

Posted - 2013-06-11 : 03:02:11

ya the user database only. even i have compared the tables which are in both databases.

matched table(both databse "master and userdatabase")

TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TABLES
VIEW_COLUMN_USAGE
VIEW_TABLE_USAGE
VIEWS

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-11 : 03:19:35

quote:
Originally posted by Dhanushkodi

ya the user database only. even i have compared the tables which are in both databases.

matched table(both databse "master and userdatabase")

TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TABLES
VIEW_COLUMN_USAGE
VIEW_TABLE_USAGE
VIEWS

Sorry my suggestion was to double check the logical filenames of your userdb. Are they same as that in error messge?
Also is the attempt to restore the backup to server where actual db exists?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources