is the way this OP is addressing what sounds like a similar problem an option for you?

http://www.sqlservercentral.com/Forums/Topic843729-361-1.aspx

you say you did a system restore? does this mean you restored a backup of the server but SQL server will not start? This will be because database files are...

yes of course the op would have been using the gui, thanks steve.

why are you trying to move its files, that should be done via the startup parameters.

restore the master database with the replace option so it restores the files to their...

presuming you do want to overwrite the target database backup and restore is best method but you will need the replace and move clauses

i.e,

restore database targetname from disk = 'path'...

I don't think so because as you pointed out to change chaining settings requires sysadmin.

I can only suggest you get in touch with the vendor and tell them what you...

Dave, make sure you are following the processes as described in this url

http://support.microsoft.com/kb/842425

you will have to make some changes (db restore not required as you are mirroring instead) but make...

not if it is added as a file in a new filegroup

this is the default value for this option, so can you just comment out that line of code?

just to finish this off I did purchase licenses for 3 servers in the end and all is working well.

I don't see the consistent improvement in elapsed times that...

quick and dirty way using dynamic SQL

select 'exec sp_helptext ', name from sys.objects where type = 'P'

run the results of that in another window, output to a file and then...

c00ler01 (1/5/2010)

---

When box with SQL server dies,your backups will die.

thats why we have DR processes in place. Separate Issue.

thats another reason not to write all your backups to one...

use an execute SQL task to run a backup command pointing to the UNC path of the share on the backup server.

else use the maintenance plan backup task in the...

you're welcome

this query returns the values you require

SELECT

A.NAME as 'Database',

b.name as 'logical_name',

b.type_desc as 'datatype',

b.physical_name as 'path',

SIZE *8/1024 AS 'FILE SIZE IN MB'

from master.sys.databases a

INNER JOIN MASTER.sys.master_files...