Viewing 15 posts - 8,191 through 8,205 (of 9,244 total)
Krasavita
use the following to generate a modify file command for each database
declare @sql nvarchar(max)
set @sql = ''
select 'alter database [' +db.name + '] modify file (name = ' + al.name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2009 at 2:31 pm
i remember playing around with this before, being nosey. If you stack multiple IP's on the NIC and in SQL Server config manager you basically stop each instance from listening...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 18, 2009 at 12:08 pm
these are separate domains in separate forests is that correct?
also clarify the group scopes you have used.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2009 at 3:52 pm
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
Viewing 15 posts - 8,191 through 8,205 (of 9,244 total)