unless the 20 databases have something in common you can use in a where clause on sys.databases just execute the 20 relevant statements from the full list produced by the...

if its all your user databases:

select 'alter database '+name+ ' set recovery full' from master.sys.databases where database_id > 4

execute in text mode

copy and paste results to another window and run

then...

I'm guessing neither does the app owner. 🙂

the end result would be the same

thats the least reliable method of trying to copy a database. Any reason why you cannot use backup\restore?

Welsh Corgi (7/10/2011)

---

I was wondering how you can prevent a member of the db_owner from from disabling or altering the...

GilaMonster (7/8/2011)

---

george sibbald (7/8/2011)

---

I think the article you are referring to is a CSS blog which can be accessed via the URL I posted in my earlier reply in this...

tfifield (7/8/2011)

---

GilaMonster (7/8/2011)

---

Jayanth_Kurup (7/7/2011)

---

Since your using 64 bit SQL Server you actually do not need to enable lock pages in memory to avoid paging , mainly since sql will be...

At least let them know their process is sub-optimal.

thats the polite way of putting it.

though didn't you originally say you were trying to do a restore?

my apologies didn't know that.

Yes there is a risk with that. One day the file just won't attach and you will have to go through a complex hack that risks...

.. and copy data and log files (you said you had to do a single file attach)

nice one guys, I was worried you would all pile in but all the answers were professional and helpful. You have all obviously grown as people. 🙂

extra point to Craig...

DBCC timewarp specialists please.......

http://www.sqlservercentral.com/Forums/Topic1138604-146-1.aspx?Update=1

er, sorry, no.

are you copying the backup over an existing file of the same name? If so, try deleting the file on the 2008 server first. then recopy from sql2005.

I have found...