start by setting the recovery model to simple for this database

and then take a full database backup. This will truncate the log file

Shrink the file to the desired size, if...

if you really need to move logs for the master,model and msdb then use the

alter database modify file command

Tempdb may also be moved but make sure not to touch...

look in sql config manager. Find the instance and on the protocols click TCP. Right click and select preoperties then scroll all the way down. Dynamically assigned port will be...

you'll also get this if you mistype the file and or path too.

Tip: If you do get this message...

winston

just to re iterate

the MOVE is only used when restoring a backup. When moving a data file location via ALTER DATABASE use MODIFY FILE. You can issue the statement while...

use a select script to generate an insert script for each row in the table and coupled with a create table script you have your table in portable format

as i said above, you can play to your hearts content without fear of retribution. Mojo pointed out the...

thank you for all the +ve comments, i just hope this is useful to you all somehow. Its great for testing and if you blow away the cluster you dont...

thanks for your reply. The document does specify you should only use for test\educational purposes and that options such as VMWare HA make this redundant. Its more for people who...

have you tried running it from the DVD?

where are you running the setup from CD, HDD, etc?

this should do it

select [name] as [DB Name], SUSER_SNAME([owner_sid]) AS [DBOwner] from sys.databases

order by 1

Hi

passive nodes first, check this link for further details

that is correct

the 2 biggest differences between std and ent are online index rebuilding and partitioning. Also AFAIK page level restores are only available in sql2005 ent