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

in that case the posts above by Markus and myself are sufficient enough to help you

you can use the VI client for a complete VI or for a single...

incidentally, if it is log shipping and you dont have any further backups to restore but want to bring online simply issue

RESTORE DATABASE [mydatabase] WITH RECOVERY

thanks, thats something i didnt know. I knew you could get ESX3.5i (got a copy myself) but i didnt know they gave away ESX 3.5, presumably you dont get virtual...

Homebrew01

BTW what edition/version of vmware are you using?