SQL Server Forums - deleted the database but have a backup .

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

deleted the database but have a backup .

New Topic

Reply to Topic

Printer Friendly

Author

Topic

gongxia649
So Suave

Azores
344 Posts

Posted - 04/09/2007 : 14:53:59

i backed up the database d1 and deleted it off my sql server.
when i innitiate the sql server instante is supposed to run the d1 DB. But since i deleted it, it pops up an error. How can i fix it?

tkizer
Almighty SQL Goddess

USA
35007 Posts

Posted - 04/09/2007 : 14:58:40

What do you mean by "when i innitiate the sql server instante is supposed to run the d1 DB"?

What error are you getting?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

gongxia649
So Suave

Azores
344 Posts

Posted - 04/09/2007 : 15:21:41

cannot connect to p4
cannot open user dfault db. login failed
login failed for user p4\user (ms sql server, error 4064)

spirit1
Cybernetic Yak Master

Slovenia
11741 Posts

Posted - 04/09/2007 : 15:23:22

so this happens when?
when you start management studio or somewhere else?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

tkizer
Almighty SQL Goddess

USA
35007 Posts

Posted - 04/09/2007 : 15:26:45

You'll need to login as a different user, one with permissions to run sp_defaultdb. Then run sp_defaultdb to change the default database of your userid.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.