Viewing 15 posts - 31 through 45 (of 50 total)
Thanks for your input everyone. I was actually able to retach the dabatbase from Enterprise manager just be right clicking and attaching. All I had to do was give the...
May 3, 2007 at 9:23 am
Hmmmm, good point. What if I restored the very old backup, with a different .mdf and .ldf files name. THen reattched it with the .mdf and .ldf files from today....
May 3, 2007 at 8:13 am
WOW!!! That did the trick. Thanks so much! I really appreciate it. 🙂
November 27, 2006 at 12:29 pm
How do you write a change script to place a column in the middle of a table that already has data (over 5K of rows) and not the end of...
November 24, 2006 at 10:00 am
Also, when and how do .mdf and .ldf files get modified? All my .mdf and .ldf files have the same time and date...even northwind.
November 16, 2006 at 8:08 am
Ah great! This totally sucks! My question is how can you over-write the .mdf and .ldf files when the restore as database displays another database name. My restore as database...
November 16, 2006 at 7:47 am
THANKS! That worked. Also, do you know how to just get the very last level to display? I just need the highest level. I don't want to see level 1,...
November 3, 2006 at 5:58 am
Thank you everyone. This has really helped a great deal. 🙂
August 22, 2006 at 1:50 pm
Thanks, I understand how the fullbackup, differential, and transaction log backups work. My question is with the INIT and the appending. I assumed that the differential is the changes from...
August 18, 2006 at 9:18 am
Okay, I'm a little confused. I thought we wanted the differential backups to append. I thought that meant, take the differential from Monday and add to Tuesday. Wednesday and so...
August 18, 2006 at 8:47 am
What do you mean by syntax? Please explain.
August 7, 2006 at 7:41 am
The full backup was done on Wednesday (mistake in earlier post) at 5am, differential today at 5am, and the transaction logs are every 4 hours from 6am until 10pm. This is how...
August 4, 2006 at 11:03 am
Thank you to everyone who replied to this post. You really helped a great deal. I have a meeting today to talk to my boss about using two RAID1's.
Now,...
November 30, 2005 at 12:07 pm
Thanks for all your input. This really helps. I have another question though. I recently read somewhere that you could implement RAID 10 using a minimum of 4 drives. But...
November 30, 2005 at 7:17 am
Thanks for all the input. Where is the best place to put the database and transaction log backups. I know mirroring takes up a lot of space. Also, this DB...
November 30, 2005 at 6:53 am
Viewing 15 posts - 31 through 45 (of 50 total)