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