How can I check out the reason a db is in recovery?

#11

On 28-04-2011 23:58, Erland Sommarskog wrote:

Quote:

If you are on SQL 2008, you can script a database including data from
SSMS.

How? I've looked through Options|SQL Server Object Explorer|Scripting
but I can't find an option "Script data" or something like that.

Best,
Henk

#12

On 28-04-2011 17:44, mat wrote:

Quote:

Is there a way to 'rebuild' a database, as if one was importing from
scratch with a sql script? Even with the production db I have the

As Erland said,you can script the tables with the data.
It works like this:

http://www.hvandenberg.net/ScriptObject.jpg shows you where to start
http://www.hvandenberg.net/ScriptOptions.jpg shows you what to change

Best,
Henk

#13

On 29-04-2011 02:46, Henk van den Berg wrote:

Quote:

How? I've looked through Options|SQL Server Object Explorer|Scripting
but I can't find an option "Script data" or something like that.

Never mind, found it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How can I check out the reason a db is in recovery?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: How can I check out the reason a db is in recovery? - 04-28-2011 , 07:46 PM

Re: How can I check out the reason a db is in recovery? - 04-29-2011 , 12:59 AM

Re: How can I check out the reason a db is in recovery? - 04-29-2011 , 01:05 AM