| Author |
Topic |
|
diyagan
Starting Member
22 Posts |
 Posted - 2007-11-05 : 09:04:34
|
| hiI deleted a database which i was working in Query analyser.I had already opened another Query Analyser .So the database is Present in this window can any one say how to Produce a copy of that database |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-05 : 09:07:14
|
don't you have any backup ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
diyagan
Starting Member
22 Posts |
Posted - 2007-11-05 : 09:08:42
|
| no is it not possible to copy the Database? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-05 : 09:11:46
|
nope. Not when you have already deleted the database.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
diyagan
Starting Member
22 Posts |
Posted - 2007-11-05 : 09:13:13
|
| no I have the database in another window.i can process it u say how to create a copy of Existing Database. |
|
|
|
diyagan
Starting Member
22 Posts |
Posted - 2007-11-05 : 09:13:53
|
| no I have the database in another window.i can process it u say how to create a copy of Existing Database. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-05 : 09:15:39
|
can you still select from your tables ? if you can then, the database is there. you can use backup database to take a snapshot backup of the database
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
diyagan
Starting Member
22 Posts |
Posted - 2007-11-05 : 09:21:29
|
| K .so how to take a snapshot back up of the database? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-05 : 09:25:13
|
Don't you have the Books Online aka SQL Server help file installed ?Check the BOL or refer to here
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
Urgent Please help