Thanks Mike for your suggestions.

Regards

Hello.

Thanks for your answer.

I only want to have a database backup without data in an easy way. I think that DBCC DATABASE may be a great and easy way to...

Thank your for all ideas (I'm going to analyze all of them).

Thanks you for your help.

Hello Lowell.

Thanks you for your answer. We are already using 'ola.hallengren' solution for maintenance plain. ¿Do you have any other suggestion?

Thanks in advance.

ok.

Thanks.

Thanks Joie.

Hi Joie.

Actually there are old aplications that are using this option. As you say, i know that in SQL 2012 this option is removed. But in SQL Server 2008 (our...

I fix this issue executing turning off the 'remote proc trans' server option.

My question is: Can i create snapshot (transactional replication) when ''remote proc trans' server option is on?

Many thanks...

Hi.

I solve the problem following the next explanation:

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/e81c48cf-f3e1-4d8a-bbfd-051a2fb6a656.

Thanks.

ok.

Many thanks.

Thanks,

But would be some performance penalty if I define my database with multiple files in the same disk? I ask it because i have tow aditional user database with some...

As final solution i also tried it.

But finally i had to use 'localsystem' account.

Anyway many thanks Scott for your help.

Hi Robert,

I get the next error in the windows event log after execute 'Copy Database Wizard':

"Event Name: OnError

Message: ERROR : errorCode=-1073548784 description=Executing the query "sys.sp_addrolemember @rolename = N'MyRole',

Many thanks Daxesh.