Viewing 15 posts - 196 through 210 (of 225 total)
Hi William,
It sounds like the server vendor's backing the databases up to tape, which isn't a bad thing. What happens if the disk/s were to fail etc etc? Are the backup...
July 3, 2007 at 3:48 am
Thanks again for the bol link MIJ.
We only have 16 or so clients so it's not too bad - cheers.
June 28, 2007 at 2:11 am
Thanks MIJ for your reply.
We'll plod on updating SSMS client tools to build 3054, no problems in doing so so far! I didn't realise that bol was a seperate install,...
June 27, 2007 at 9:31 am
Any thoughts would be greatly appreciated.
June 26, 2007 at 4:09 am
Hopefully someone out there will no the answer to this, but to date i've had no feedback...
June 14, 2007 at 5:53 am
Absolutely Carl, as you mention you will only need to move your logs from d: to e:
Cheers,
Mark
June 4, 2007 at 3:43 am
I completely agree with Ed. Keep the master.mdf & mssqlsystemresource.mdf & .ldf files in their default location! By all means split the master.ldf to E: - no problem. (I think you...
June 1, 2007 at 7:07 am
Many Thanks Anders... worked a treat, if only I knew more about t-sql/scripting.
April 19, 2007 at 7:40 am
Hi David,
Thanks for the replies. I added the N'bak' parameter and now I get a different error.
EXECUTE
master.dbo.xp_delete_file 0
April 19, 2007 at 2:30 am
Ed,
It would be nice to keep things tidy. (i.e split all mdf's and ldf's) but obviously this just isn't possible. Thanks for your reply.
I too am looking at producing a...
April 14, 2007 at 1:06 pm
Guys,
Thanks for your replies. Upon further investigation the SQL Server log file was suggesting that the systemresource db was either corrupt or could not be accessed.
I had split the mdf's...
April 13, 2007 at 9:16 am
Thanks for the reply Vince. I have sent you a pm hopefully this will help pinpoint the problem.
Have you successfully used your script to split the locations of the system...
April 12, 2007 at 2:28 am
Okay having just run SP2 again on a clean SQL 2005 installation with the mdf's & ldf's moved to their respective homes. When SP2 was upgrading the 1st named instance...
April 11, 2007 at 10:32 am
Thanks for the reply Vince. Of course it makes sense if the old file still exists in the original directory!
Before the script it would take us almost half a day...
April 11, 2007 at 9:45 am
Vince,
I can't even begin to tell you how much time & effort this script has saved us.
We've modified it slightly so it now incorporates installing 8 named instances of SQL...
April 11, 2007 at 9:07 am
Viewing 15 posts - 196 through 210 (of 225 total)