if you have enough space,

then I will suggest

1.take a back up of the database and restore it on the same server with different name,

2. and then rename the db...

And I'm Glad that they removed this option from 2008 🙂

You can use default Stored Procedure Template from Template Explorer.

it will help you

SSMS > View > Template Explorer > Stored Procedure

if you are feasible to work in data center or where the physical server is kept,

you can pull out the network cable connected to your server machine .

but before ...

go for this

http://blog.sqlauthority.com/2011/12/23/sql-server-a-quick-script-for-point-in-time-recovery-back-up-and-restore/

or for all about backup and restore

http://www.sqlbackuprestore.com/introduction.htm

in your this case you don't need /PAE option ..as you are using 64 bit machine

I hear you on that one and not like that option/switch very much.

There are some...

Which edition of SQl server you are using ?

GilaMonster (11/5/2012)

No, it does not. It fragments indexes, doesn't make them unusable,...

GilaMonster (11/5/2012)

If running SQL on 32-bit OS with more than 4GB of memory, /PAE is...

Koen Verbeeck (11/5/2012)

I wouldn't consider this the...

Also consider this as your very last options.

To speed up your DB check,first check if there any scope for Query Tuning.

Is your production machine 32- bit ?

if yes ,you need to add /PAE option in your boot.ini file .

http://support.microsoft.com/kb/283037

But I will recommend before doing this discuss with your system admin...

Sorry,this is with proper code format 🙂

SELECT DB_NAME(database_id) AS [Database Name],

COUNT(*) * 8/1024.0 AS [Cached Size (MB)]

FROM sys.dm_os_buffer_descriptors

WHERE database_id > 4 -- system databases

AND database_id <> 32767 -- ResourceDB

GROUP...

I cant see Error text :blink:

this might help you

SELECT DB_NAME(database_id) AS [Database Name],

COUNT(*) * 8/1024.0 AS [Cached Size (MB)]

FROM sys.dm_os_buffer_descriptors

WHERE database_id > 4 -- system databases

AND database_id <> 32767 -- ResourceDB

GROUP BY DB_NAME(database_id)

ORDER BY [Cached...