Viewing 15 posts - 8,191 through 8,205 (of 9,241 total)
just pick the files up and move them with the master.mdf
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2009 at 9:27 am
are you using any replication?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2009 at 10:22 am
always keep dist and resource database in the same location as master.mdf
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2009 at 4:57 am
reefshark (7/8/2009)
I kept getting an error. (why do I keep getting errors with everything I do?!?)
as Lynn says, you need to restore the database full backup with NORECOVERYas...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2009 at 5:37 am
declare @sql nvarchar(max)
set @sql = ''
select @sql = @sql + 'alter database [' + name + '] set offline;
'
from sys.databases where database_id > 4
exec (@sql)
--all system databases occupy id...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2009 at 3:02 pm
what about databases that have open connections what do you want to do about these
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2009 at 4:58 am
shiv (6/13/2009)
"Device error or device off-line"Restore db is terminating abnormally.
have you checked the tape drive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 14, 2009 at 9:18 am
yes simon, the path you provide is relative to the server not your machine.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 14, 2009 at 5:40 am
Hello buddy, fancy seeing you here 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2009 at 5:37 am
i agree with Markus. Create\use a folder that you have permissions for and use that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2009 at 5:35 am
can you post the create trace statement you are using
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2009 at 6:07 am
as i mentioned the only thing you may need is login info and database paths\details. If you haven't upgraded the database (which you haven't) you would need to script the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2009 at 6:09 am
Perry Whittle (6/9/2009)
Extra indexes may have been created, more data now than you had previously??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2009 at 5:54 am
even so it probably shouldnt be necessary on a daily basis.
although its never failed previously remember the database will change. Extra indexes may have been created, more data now than...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2009 at 8:09 am
if you have the extra disk resources i personally would prefer a clean install to the cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 9, 2009 at 6:49 am
Viewing 15 posts - 8,191 through 8,205 (of 9,241 total)