retrieved a empty batabase sql server 2005

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

General SQL Server Forums

New to SQL Server Administration

retrieved a empty batabase sql server 2005

Author

Topic

yad93fr
Starting Member

5 Posts

Posted - 2011-04-18 : 07:11:34

hi,

I got a database builted on sql server 2005 and I expect to have the same database on another computer completely separate.
Problem: I don't have a copy of my empty database.
However, that's not a problem for me to have on a new computer, the databse with all registered datas.

So, I install sql server 2005 on the new computer.
After, I make a complete database backup from the first computer to an amovible disk.
Go to the new computer. I built a new database with the same name, the same owner logging and also without structured cause I dont knows exactly the structure. And after I make a restaure with the database registered on my amovible disk : I got a 'database not the same' error or something like this.
Sorry but really new on database, sql server and management studio app. I just need the process to do this: have a same database on a new computer without a copy of empty database source?
thank...

yad93fr
Starting Member

5 Posts

Posted - 2011-04-18 : 07:21:38

detail: when I make the backup, on my mobiled disk It give me a file 'yaddatabse' but without any extension?? not *.mdf.

yad93fr
Starting Member

5 Posts

Posted - 2011-04-18 : 07:26:55

exact mesage when used import db in management studio is : 'g:\yaddatabase is not a primary databse (sql server error:5171'

yad93fr
Starting Member

5 Posts

Posted - 2011-04-18 : 07:34:00

exact message when used retaure : 'the databse backup files contents are not corresponding with the present yaddatabase database (Sqlverver.Smo)'

Sorry for my english I am french and translate with my possible. But if someone got infos for me, wellcom...

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-04-18 : 10:49:02

better idea is to restore your database with script (meilleure idée est de restaurer votre base de données avec le script)
http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/

--------------------------
http://connectsql.blogspot.com/

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-18 : 14:07:22

when you go to restore the database then click the option OVERWRITE or add the REPLACE keyword in the restore script before STATS as

,REPLACE,STATS =

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources