this details it

http://msdn.microsoft.com/en-us/library/aa196700.aspx

your welcome

it doesnt exist as you are not running sql...

no as Lynn pointed out id 2 is the default trace

what version of sql server is this as common criteria is only available in dev or Ent sql editions

so it sounds like it is common criteria, did you run the code Jack posted above?

this is not a default trace as that logs to the LOG directory not the data directory

stop and close the trace as i specified, then go hunt down how this...

from this

1 1 6

1 2 \\?\C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\audittrace20090407090827_200.trc

1 3 200

1 4 NULL

1 5 1

traceid 1 is your culprit and this "1 5 1" means its still running. Try stopping...

FAT32 does not support file sizes of over 4GB (4294967296 bytes - 1), also your partition size is capped @ 32GB.

google found this, it gives you uptime of sql instance in minutes

SELECT datediff(mi, login_time, getdate())

FROM master..sysprocesses WHERE spid = 1

alternatively for server uptime try this[/url]

simply

backup and restore

or

detach and attach

the SQL 7 database to the SQL 2005 server and all the identities should be fine

dont forget to update usages and rebuild indexes afterwards

what file system is the USB drive formatted with?

Achtang (4/8/2009)

---

hi perry thanks for that. I downlad Virtual PC 2007 and i start to install win2003 server but it says to put the boot disk on. do i have...

"Au contrair mon pere"

you dont need to shutdown sql server!

you dont need to detach the database!

you dont...

Achtang (4/7/2009)

---

how can i do virtualisation? can you tell my how to start mine is windows XP sp2 and i have sql 2005 developer edition.

I want to configure cluster and...

use the alter index command, this is also minimally logged under bulk-logged and i think simple recovery too