Hi,

Have you configured it properly while installing the SQL 2008 and also does the SQL server start up account has right permissions? It seems to me that it is an...

Cross post please, all replies to :

http://www.sqlservercentral.com/Forums/Topic693673-146-1.aspx

Cross post please, All replies to :

http://www.sqlservercentral.com/Forums/Topic693673-146-1.aspx

Sorry bad advise, Edited....

Do you get any errors while doing this and also what permissions this user has got?

Perry Whittle (4/8/2009)

---

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....

Jack is right, you could check that.

Or

Right click on your sever->Properties->Security and uncheck the 'Common Criteria Compliance'.

Hi,

Please take a look at this, this is a known error message by microsoft...

Hi,

Anything in the SQL error log. could you please post that please?

archidrb (4/8/2009)

---

Two databases. I submitted a request internally to have the big one (in '00) moved. I would like to try the import/export, but I am not sure...

Could you...

you are welcome, any problems give us a shout

Carol Adams (4/8/2009)

---

The problem is there are over 100 databases from 2mb upto 2gb in size.The way they had me set it up was to create .bak files, copy...

Great ! Thanks for confirming it, Mohit:-)

Backup and Restore is the best way or Import/Export Wizard. Either of them. How many databases have ou got to move?