Viewing 15 posts - 1 through 15 (of 63 total)
Steve Jones - SSC Editor (1/14/2013)
No effect. The extensions have no bearing on the files' purpose or use. They are set to mdf/ndf/ldf only for convention.
Great!! Appreciate your help.
January 14, 2013 at 12:22 pm
Steve Jones - SSC Editor (1/14/2013)
That should work.I assume when you attach, you are attaching the MDF/LDF and new NDF at the same time.
That is correct. My only concern though...
January 14, 2013 at 11:38 am
Good to know..Luckyly I was commiting transaction for each day in the loop and the data was committed
December 12, 2012 at 1:10 pm
How about using CMS in 2008 and powershell to install service packs on a bunch of servers at the same time ..is it possible ?
November 15, 2011 at 2:05 pm
the main report has a parameter @year and asub report also has a parameter @year . I am not sure how to link them...
When the sub report is run indicudually...
February 18, 2011 at 7:55 am
Save physical box? I am assuming your wuestion was same physical box...and no its not..
May 14, 2010 at 9:14 am
Looks like this...
declare @backpath varchar(512)
set @backpath =
(select TOP 1 physical_device_name
from prodserver.msdb.dbo.backupset BS
inner join prodserver.msdb.dbo.backupmediafamily BF
on BS.media_set_id = BF.media_set_id
where database_name = 'dbname'
order by backup_start_date desc)
RESTORE DATABASE devdb
...
May 14, 2010 at 9:04 am
We are trying to restore the dev db with a backup of prod...and I use none of those...
May 14, 2010 at 8:45 am
sorry for the confusion malachyrafferty ...I got my answers too..
April 20, 2010 at 8:53 am
ours is not a 24/7 workshop and the server can be taken down for the weekend ....the only question I have is if we are deleting the old server and...
April 20, 2010 at 8:29 am
I am in pretty much the same situation and we are planning to move the server to a different location ...I have all the scripts ready to move the logins/jobs...
April 20, 2010 at 8:11 am
I was afraid that I would be left with this option....I guess I will have to go though the pain ...
Any tool that would help me in gathering the info...
December 18, 2009 at 9:39 am
By the wat the application was not developed in house - it was bought from a vendor. So I guess there would be no way that I could get the...
December 18, 2009 at 8:41 am
Do you have an internal QA department? - No
Previous test cases for the application? - No
Are you able to go through the application given certain scenarios and receive expected results?...
December 18, 2009 at 8:38 am
Viewing 15 posts - 1 through 15 (of 63 total)