| Author |
Topic |
|
muzzettemm
Posting Yak Master
212 Posts |
 Posted - 2009-01-07 : 11:37:41
|
| Hi guys, I want to get our database away from bAckup Exec adn I want SQL server to do the backing up. I did some research on backups but I just want to get confirmation from the DB Gurus on what I amd doing is ok. The database are set for SIMPLE recovery because we not that interested in Point In Time since we are not updating on a daily basis. I want to set up a MAINTENANCE PLAN for twice a week on Friday Full backupand three times a week differentialswould that be a good plan or no?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 12:42:56
|
| Really cool thank yoiu Tkizer, I have a quick question silly but. The actual SQL Database reside in the MSSQL\Data Folder correct??? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 13:07:24
|
| Ok so your saying that you have the MDF and the LDF in different folders?? correct |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 13:52:27
|
| I would like to do that, we have a drive that has enough room on it to store the LDF and I would like to place them there if I can. I'm not sure how to implement that, never done it? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 16:32:39
|
| ok so after reattaching the database I run this script, hope this is correct?? After moving the LDF to the desired locationALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path\os_file_name' ) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-07 : 16:53:07
|
| I guess You can also useALter Database ..... Modify file.... to move the location of MDF or LDF file. The only thing is you need to restart SQL Service to take an effect and delete old MDF/Files. |
|
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 17:11:26
|
| I didnt want to RENAME THE logical names, I only wanted to seperate the LDF to a diffent physical disk on the server. I just wondering If I needed to do something else aft the reattaching?? to make sure that the Databbase can find the new location of the LDFHere is the situation, the IT person that set all this up is now gone. And I made suggestions in the past but he didnt want to do them. One of them was moving the LDF out of the same file as the MDF, what I wanting to do was copy paste them out of the file they are in and move them to a differnt file on a differnt drive. I tried doign this with one LDF file and it gave me an error message, just wanted to test it out. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 17:54:29
|
| Ok I see what your saying, I need to either stop the service or detach the database because SQL SERVER is using it, thats why I cant copy it over? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-07 : 18:12:59
|
| ok I just confirming thanks allot guys, I really appreciate your time and patience |
|
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-08 : 11:39:27
|
| Good morning everyone, well I moved the LDF to a different folder on a different disk, detached the database then we attaching it told it where the new location is for the LDF and it gave me an error message saying that the proposed new owner is already and aliased or user in the database. Can anyone tell me what I am doing wrong cause I full access to SQL SERVER, I'm an Admin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
Posted - 2009-01-08 : 15:07:56
|
| yes I detached first, would not let me move to new location unless I detached first |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
muzzettemm
Posting Yak Master
212 Posts |
|
|
Next Page
|
Backup/Maintenance Plan