Varing Schedules On Database Maintenance
Feb 27, 2007
As best I can see, the new database maintenance tool allows you to set only one schedule as you work through the wizard. (For that matter if you put multiple tasks in the database, you can not fire them off individually on a different schedule.)
The solution is - of course - a different job for each task you want to have a specific schedule. Or design a database to control the workflow (possible, and arguably easier to maintain, but way too complicated, I think.)
Or perhaps I am missing something. So does anyone know of a better way to do that "All-in-one" kind of database maintenance - just like ti was in 2000?
View 1 Replies
ADVERTISEMENT
Jan 30, 2008
Hi guys, just wanna hear your opinions on which would be better for maintenance plans.
Build separate schedules for each task (integrity checks, optimizations, backups)?
Or a single schedule for the entire plan?
Thanks!
Donn Policarpio
View 4 Replies
View Related
Sep 22, 2005
I'm having a problem figuring out how to show multiple event times in one string. The data I'm using is:
Code:
idloc_idtrny_dowtrny_time
17923:00:00 PM
18926:00:00 PM
19929:00:00 PM
201026:00:00 PM
211029:00:00 PM
221136:00:00 PM
231139:00:00 PM
23946:00:00 PM
If the Loc_ID and trny_dow is the same for mutiple rows, I need to concatenate the trny_time of those recoreds into a string and not return the individual times.
I can't figure out how to return the final recordset as:
Code:
loc_idtrny_dowtrny_time
923:00 PM & 6:00 PM & 9:00 PM
1026:00 PM & 9:00 PM
1136:00 PM & 9:00 PM
946:00 PM
Any help is much appreciated!
- Dan
View 1 Replies
View Related
Jan 25, 2007
Could anyone tell me how to create a scheduled job in sql server 2005, I have a bunch of queries thaty i want to run on a table and i want to automate it, does anyone know of any tutorials on the internet or any helpful links
Thanks
View 1 Replies
View Related
Apr 5, 1999
Whenever I set a schedule on any given package, it executes OK, but I'm not able to bring back those settings for review. Instead, it always starts with the blank schedule form. Any hints?
** Thanx in advance **
P.S. I log in NT as an Administrator.
View 1 Replies
View Related
May 12, 2004
I just created a job with more than one schedule. Specifically, one schedule for the 2nd Sunday and the other for the 4th Sunday. Has anyone ever created multiple schedules for a job?
Sidney Ives
Database Administrator
Sentara Healthcare
View 3 Replies
View Related
Jul 6, 2006
I have set up a DTS to import data from an Access database to a server which is running SQL. It works alright if I execute the DTS, but if I set it to run as a scheduled task, it tells me that the path to the access db is not valid, and that I should make sure the path name is spelled correctly and that I am connected to the server on which the file resides... so obviously it's not a spelling issue (since when I execute it, it works), but a security issue. Anyone have any ideas?
Thanks a lot,
Tex
View 9 Replies
View Related
Aug 27, 2007
I am looking for a script that will show me the job schedule for the jobs on a given server, in plain english. It would look something like this:
Job Name Schedule
Job 1 M,Tu,W,Th,F 3:10 pm
Job 2 1st Day Month 6:00 am
Job 3 Daily 4:15 pm
I have looked at the job schedule table and have decipher some of it, but not all. Can anyone point me in the right direction?
Thank you!!
Jim Youmans
St. Louis, Missouri, USA
View 4 Replies
View Related
Aug 31, 2006
Below is the script of a Job called "eFIMS_SendEmail" that I wish torun. The intention is that every day of the week the job will executea SPROC at timed intervals. For example, the SundayRun schedule willrun once every 1 hours from 00:30:00 to 23:59:59However, the clients have stated that they want an interface to this toenable them easily to change the start time and frequency interval foreach day. It's an easy matter for me to paint them a form from withinthe target application to enable the user to enter the start time andinterval for each day. I can then pass these as parameters to a SPROC.How can I use these values to change the schedules for the job? Forexample, if wanted to change SundayRun from once every 1 hours to onceevery 30 mins? I know I could do it the hard way, by using stringmanipulation (e.g. find string 'SundayRun', then look for the nextoccurrence of @active_start_time, @freq_subday_type,@freq_subday_interval etc. and do some replacement) but this seemssomewhat tricky.Many thanksEdward-- Script generated on 8/31/2006 9:27 AM-- By: sa-- Server: BISMARKBEGIN TRANSACTIONDECLARE @JobID BINARY(16)DECLARE @ReturnCode INTSELECT @ReturnCode = 0IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name =N'[Uncategorized (Local)]') < 1EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]'-- Delete the job with the same name (if it exists)SELECT @JobID = job_idFROM msdb.dbo.sysjobsWHERE (name = N'eFIMS_SendEmail')IF (@JobID IS NOT NULL)BEGIN-- Check if the job is a multi-server jobIF (EXISTS (SELECT *FROM msdb.dbo.sysjobserversWHERE (job_id = @JobID) AND (server_id <0)))BEGIN-- There is, so abort the scriptRAISERROR (N'Unable to import job ''eFIMS_SendEmail'' since thereis already a multi-server job with this name.', 16, 1)GOTO QuitWithRollbackENDELSE-- Delete the [local] jobEXECUTE msdb.dbo.sp_delete_job @job_name = N'eFIMS_SendEmail'SELECT @JobID = NULLENDBEGIN-- Add the jobEXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT ,@job_name = N'eFIMS_SendEmail', @owner_login_name = N'sa', @description= N'No description available.', @category_name = N'[Uncategorized(Local)]', @enabled = 0, @notify_level_email = 0, @notify_level_page =0, @notify_level_netsend = 0, @notify_level_eventlog = 2,@delete_level= 0IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollback-- Add the job stepsEXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID,@step_id = 1, @step_name = N'SendEmail', @command = N'EXECstpSendEmailConfirmation', @database_name = N'194-eFIMS', @server =N'', @database_user_name = N'', @subsystem = N'TSQL',@cmdexec_success_code = 0, @flags = 4, @retry_attempts = 0,@retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0,@on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollbackEXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID,@start_step_id = 1IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollback-- Add the job schedulesEXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID,@name = N'SundayRun', @enabled = 1, @freq_type = 8, @active_start_date= 20060831, @active_start_time = 3000, @freq_interval = 1,@freq_subday_type = 8, @freq_subday_interval = 1,@freq_relative_interval = 0, @freq_recurrence_factor = 1,@active_end_date = 99991231, @active_end_time = 235959IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollbackEXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID,@name = N'MondayRun', @enabled = 1, @freq_type = 8, @active_start_date= 20060831, @active_start_time = 3000, @freq_interval = 2,@freq_subday_type = 4, @freq_subday_interval = 30,@freq_relative_interval = 0, @freq_recurrence_factor = 1,@active_end_date = 99991231, @active_end_time = 235959IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollbackEXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID,@name = N'TuesdayRun', @enabled = 1, @freq_type = 8, @active_start_date= 20060831, @active_start_time = 4000, @freq_interval = 4,@freq_subday_type = 4, @freq_subday_interval = 40,@freq_relative_interval = 0, @freq_recurrence_factor = 1,@active_end_date = 99991231, @active_end_time = 235959IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollbackEXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID,@name = N'WednesdayRun', @enabled = 1, @freq_type = 8,@active_start_date = 20060830, @active_start_time = 3000,@freq_interval = 8, @freq_subday_type = 4, @freq_subday_interval = 30,@freq_relative_interval = 0, @freq_recurrence_factor = 1,@active_end_date = 99991231, @active_end_time = 235959IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollbackEXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID,@name = N'ThursdayRun', @enabled = 1, @freq_type = 8,@active_start_date = 20060831, @active_start_time = 3500,@freq_interval = 16, @freq_subday_type = 4, @freq_subday_interval = 35,@freq_relative_interval = 0, @freq_recurrence_factor = 1,@active_end_date = 99991231, @active_end_time = 235959IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollbackEXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID,@name = N'FridayRun', @enabled = 1, @freq_type = 8, @active_start_date= 20060831, @active_start_time = 3000, @freq_interval = 32,@freq_subday_type = 4, @freq_subday_interval = 30,@freq_relative_interval = 0, @freq_recurrence_factor = 1,@active_end_date = 99991231, @active_end_time = 235959IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollbackEXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID,@name = N'SaturdayRun', @enabled = 1, @freq_type = 8,@active_start_date = 20060831, @active_start_time = 0, @freq_interval =64, @freq_subday_type = 8, @freq_subday_interval = 1,@freq_relative_interval = 0, @freq_recurrence_factor = 1,@active_end_date = 99991231, @active_end_time = 235959IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollback-- Add the Target ServersEXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID,@server_name = N'(local)'IF (@@ERROR <0 OR @ReturnCode <0) GOTO QuitWithRollbackENDCOMMIT TRANSACTIONGOTO EndSaveQuitWithRollback:IF (@@TRANCOUNT 0) ROLLBACK TRANSACTIONEndSave:
View 1 Replies
View Related
Feb 14, 2000
I am looking for opinions of setting up a database maintenance plan. I want to know if it is safe to trust the wizard and let it set up all of the jobs, or if it is better to write your own procedures to handle backups and maintenance as in 6.5. All sugestions and opinions are welcome. Thanks.
View 2 Replies
View Related
Feb 2, 2000
For SQL server 7.0, is it necessary to schedule database maintenance plan on a regulare basis? I know it is necessary for SQL server 6.5.
Thanks.
Su Ge
View 1 Replies
View Related
Apr 12, 1999
SQLMaint is run once a week for the following a database on SQL 6.5. The following is the information for the database when I see it through the Enterprise Manager:
Data Size 650 MB
Data Space Available 0.00
Log Size 360
Log Space Available 359.99
The following is the syntax built by the DATABASE Maintenance Wizard:
SQLMAINT.EXE -D CATS -CkDB -CkAl -CkTxtAl -CkCat -UpdSts -RebldIdx 100 -Rpt E:MSSQLLOGCATS_maint.rpt
It runs once a week and takes about 40 mins and runs successfully. Last it run was 4/11/99 at 2:00 AM
The result set I get from sp_spaceused is as follows:
database_name database_size unallocated space
CATS 1010.00 MB 273.96 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
753710 KB 280360 KB 426494 KB 46856 KB
What I don’t understand is how come the data space available shows 0 in Enterprise Manager? Shouldn't SQLMAINT, which is run once a week, allow for correct information to be reported?
Could someone please explain.
Thanks
Shashu
View 2 Replies
View Related
Jul 20, 2005
Running SQL Server 2000 Enterprise Edition SP3. The database is alsoused by Microsoft Project Server 2002 and also has OLAP views, so thedatabase is being used to view/run cubes in the Analysis Manager.What is the best way of shrinking the database size and its log file too?Is there an automatic way to do this with a maintenance plan or i haveto manually run a SQL statement periodically?What are the best practices?I have a database that the size of it is 260megs and now the log file isover 800megs...Everytime i run the following:BACKUP LOG DBName WITH TRUNCATE ONLYDBCC SHRINKDATABASE (DBName, 10, TRUNCATEONLY)When running it, i get the following 2 records returned:DbId FieldId CurrentSize MinimumSize UsedPages EstimatedPages7 1 32304 128 28152281527 2 160 128 160128I don't know what the above 2 records mean. I am also concerned if i shouldbe running that statement or not.Also concerned as to why the Windows Server 2003 (Enterprise Edition)always creates a CRITICAL error in the Application event viewer with EventIDnumber 17055, source being MSSQLSERVER and the description of the event:18278:Database log truncated: Database: DBName.If it's a critical error message, then what i am doing is bad? Am i damagingmy database?Within like 7-10 days of running the above statement, the log file becomescloseto 1 GB again! How can i find out what causes the log file to grow that big?Is it beingcaused by running some OLAP views or what? The db has about 20 usersconnected to itusing an ASP web aplication as the front-end, and MSP Professional 2002 alsoto connectto the Project Server 2002 (which uses the same database as the aboveDBName).I would appreciate any help.Thank you very much
View 4 Replies
View Related
Oct 15, 2007
I have been looking through the data files directory for my databases and noticed that the log (ldf) files of some of the databases are from 2GB to 4.5GB where as the data files are under 500MB. If I shrink the log files what affect does this have on the database? Should I be setting up regular shrink jobs on the log files?
Any help would be very much appreciated.
View 5 Replies
View Related
Mar 28, 2014
I am doing some general housekeeping for a couple of our SQL boxes in the Development environment. All the databases are set to Simple recovery mode. No need in anything else for these boxes. I have a database on all the boxes named "DatabaseMaintenance" Keeps things like all the sprocs for any type of database maintenance, etc....
I would like to schedule a single sproc that is located in the DatabaseMaintenance database to shrink the Transaction logs on a set schedule. They sometimes grow quite large while testing and developing. The thing that I cannot seem to get around, is when using the ShrinkFile command, one must use the Log Name. If this code is in a sproc that is located in the DatabaseMaintenance database, it will fail when attempting to call out to a different database. Because the Log does not exist on the database that the sproc is located.
How can I get around this small dilemma? There are only about 10 databases per box. To a point we really do not care what happens to them. They are on a Full backup schedule daily, just to keep the objects. As I stated previously, the logs will still grow huge at times while pumping data.
Is there a way to create a piece of code that will run against each database on the server, and be stored in a single database? Other than the system databases of course.
View 5 Replies
View Related
Jun 12, 2015
I wanted to check with you all if it is possible to create a script which generates the list of the schedules of all the jobs and then analyses it to rearrange the job starttime to ensure that we have equal gap between two jobs starting time. Just to ensure we donot have many jobs running at the same time.
View 1 Replies
View Related
Feb 6, 2007
Hi,
I have been trying to figure this out for a while. I have a report that should run at 9AM, 12 Noon and 2PM every weekday. Due to the complexity of the report, I'm using snapshots. Since the lowest gap is 2 hours, I currently have it configured to create the snapshot every two hours. Since this is running all day, my servers are taking a lot of strain. In the report manager help, it suggests creating three daily schedules for the report. I cannot find a way to create more than one schedule for a report. Please let me know how I can do this. Any help will be highly appreciated.
Thanks,
Anand
View 7 Replies
View Related
Mar 12, 2002
Hi there,
We are using a database maintenance plan to backup and reindex our db's. Up until the end of last month this was working perfectly - however now it has stopped deleting the old backups (even though we have checked 'Delete files over 1 day old').
Does anyone have any ideas as to why they are now being deleted - and how we can remove them automatically - has something been corruped? Would it be a case of creating a new maintenance plan?
thanks in advance,
Matt
View 1 Replies
View Related
Mar 26, 2001
SQL Server 7.0 with SP 1
Database maintenance job is failing
with error about being unable to delete old backup file.
I can manually delete the file with no problem.
This occurs randomly, maybe once a week.
Any ideas on what's wrong, and how to fix it?
View 1 Replies
View Related
Jul 28, 2000
I want to know database maintenance issue when there are many databases in a machine. The number of database will be 50~80. We'll use SQL 7.0. In Sql 7.0, I heard that there is not so much maintenance issue.
Wisepost Inc.
Chris Song
View 3 Replies
View Related
Feb 13, 2001
After looking through the archives at database maintenance steps used by others, I have decided on the following steps for each of my SQL Server 7.0 databases. I have set up a maintenance plan where they would execute in the following order for each database, if the preceding step is successful. If the preceding step fails, the job quits.
dbcc checkcatalog ('master')
dbcc checkdb ('master')
backup database master to master_dump with init, name = 'ASP Master dump'
dbcc dbreindex ('master', '', 70)
dbcc shrinkdb ('master', 10)
Now my questions...
1. The checkcatalog, checkdb, backup database, and shrinkdb commands appear in blue in SQL Server 7.0 to seemingly indicate they are commands. However, the dbreindex command is black. Does this mean that it is not recognized as a valid command? If so, why not? It is shown as a valid command in the Microsoft Knowledge Base.
2. The value of 70 in the dbreindex command was the value shown in sample code in the Microsoft Knowledge Base. However, the Knowledge Base does not give any guidance on whether this is a good value or not. How should I make a decision on what value to use? The value of 10% for the shrinkdb command is also just a sample value from Microsoft. How does one know what value to choose?
If anyone thinks this is a poor selection of maintenance steps, please let me know that also.
Thanks!
Joe Meyer
View 2 Replies
View Related
Sep 15, 1999
Hi, I'm new to SQL 7 (and fairly new to SQL Server), can anyone help with these basic questions on database maintenance plans generated by the wizard:
(1) Scheduling - can SQLServer handle say a REORG running at the same time as a backup against the same database? This should never happen, but what will happen if say a backup is due to start before a REORG has finished? To try & simulate this 'problem' I've run REORGs and backups at the same time & have yet to encounter errors I presume SQL locking handles this OK.
(2) Database integrity checks - (a) any comments on the wisdom of checking 'repair any minor problems'? Anyone had any problems with this? (b) While integrity checks are running do they take enforce a consistent view of the data? (I think this is probably the case as my reading of books online indicates that DBCC takes shared locks for the duration)
(3) Backups - does the 'VERIFY INTEGRITY' option have any impact on the live database? (My reading of RESTORE VERIFYONLY indicates it doesn't)
Thanks....
View 1 Replies
View Related
Mar 18, 2003
What is the recommended schedule for SQL Server maintenance plans that perform database integrity checks and optimizations?
Also, more specifically, how often should we be re-building our indexes?
Thanks for your help.
View 4 Replies
View Related
Apr 21, 2003
I have several Maintenance jobs that keep failing. They
are , Integrity Checks, Index rebuild, and Update
statistics. I keep getting a similar error on all three. I
have pasted it below. None of my other SQL 2000 servers
have any problems. I have tried changing the database
options in question. The error I keep getting is as
follows:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'DAPHNE' as 'CDCNorm' (trusted)
Starting maintenance plan 'FSPRD84A Integrity Checks' on
4/21/2003 10:20:59 AM
[1] Database FSPRD84A: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER'.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
because the following SET options have incorrect
settings: 'QUOTED_IDENTIFIER'.
** Execution Time: 0 hrs, 0 mins, 8 secs **
End of maintenance plan 'FSPRD84A Integrity Checks' on
4/21/2003 10:21:07 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Any suggestions?
View 8 Replies
View Related
Sep 18, 2006
Hi,
I'm researching on how to maintain RS SQL server database or what is the best way to maintain ReportServer and ReportServerTempDB? Should I go for the automatic shrink facility of SQL Server? Any suggestion? Thanks.
View 6 Replies
View Related
Dec 1, 2005
Hello, everyone:
I have a Database Maintenance Plan that back up some databases and delete old backup files that more than two day. Can any one have idea which action is first, backup or delete old files?
Thanks
ZYT
View 1 Replies
View Related
Mar 17, 2006
Hello everyone,
I'm new to DB Maint Plans, so let me apologize upfront. I've taken over a system from a DBA who is no longer working here, and he set up Maint Plans for all of the existing DBs. The plans show up in the Enterprise Manager under "Management->Database Maintenance Plans" like they should, but there are also entries in the "Management->SQL Server Agent->Jobs" area. When I set up a new DB Maint Plan for a new DB, it seems to be working fine, but I don't have any corresponding entries in Jobs. Did the other DBA set these up manually? Does anyone know why he might have done this? Is it needed? The jobs and job steps look like the following:
[DBName]Full:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 33C423D0-CC31-40BD-A357-7DCCAB1DC262 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "W:sqldataMSSQL$P001Backup" -DelBkUps 1WEEKS -CrBkSubDir -BkExt "BAK"'
[DBName]Maint Integrity Checks:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 33C423D0-CC31-40BD-A357-7DCCAB1DC262 -WriteHistory -CkDB '
[DBName]Maint Optimizations:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 33C423D0-CC31-40BD-A357-7DCCAB1DC262 -WriteHistory -RebldIdx 10 -RmUnusedSpace 50 10 '
Any help or insight would be greatly appreciated!
Thanks in advance,
Cat
View 12 Replies
View Related
Mar 24, 2004
Overview of my database: size - 45 GB, Full Recovery Mode, Log shipping ever 15 minutes; Full Backup nightly; Optimization and integrity checks on Sunday night.
The Database takes a transactional log every 15 minutes and ships it to our failover database. Usually these are small logs and are executed in matter of seconds.
On sunday night there is a problem. The optimization job (part of DB maintenance plan) runs for 3 hours and during this time the transactional log backup continues to runs and takes close to 4 hours of complete. When the tran log completes its close to a 30 GB file and this is causing problems with space and shipping. This also causes the failover server to be out of sync and at times we have to re setup log shipping.
Does anyone know if there is a way to get around this problem. Appreciate all help and comments.
View 2 Replies
View Related
Nov 16, 2007
I need to create sql 2005 standard maintenance plan for system and user databases and database maintenance plan should include Reorganize index task, full backup task, maintenance cleanup task(for backup files), history cleanup task.
What should be the tasks order ? please let me know....I have to complete this on 8 servers by 11/16/2007 10 AM PST
In sql 2000 database maintenance plan, any rebuild index task is there ??
View 8 Replies
View Related
Jan 16, 2008
can any one tell me the sql server 2005job schedules,ssis packages
View 1 Replies
View Related
Jan 24, 2012
I have a copy of class schedules with only students that are taking half of a full year class in a separate table. The table lists the term that the students are taking so I joined that table to the actual class schedule table via the code below. The values are 1 & 2 and if it's null (not taking half of a full year class) it's a 9. So now I only need 9s and 2s to bell pulled from the script below. How do I go about doing that since HLF_Term is not a real column?
Code:
SELECT STUSCHEDULE.[School_Year]
,STUSCHEDULE.[School_Number]
,STUSCHEDULE.[Student_ID]
,STUSCHEDULE.[CourseID]
[Code] ....
View 4 Replies
View Related
Apr 4, 2008
Hi All
what might be the result If schedules of the Job crashes in SQLServer 2000.
above scenario will going to happen in our Prod server for backup jobs, any pre-cautions I can take right now..
Help me.
View 8 Replies
View Related
Apr 24, 2002
I have in production, the database maintenance plan that runs the nightly backups. I want to restore this to a completly different server I am setting up for testing. What is the best way to restore a backup on one server (that was done using the maintenance plan) to another server? I tried just mapping a drive and then forcing a restore, however, I got some error message about an ID or something. Maybe I need to do it through query analyzer and there is an easier way to force it? thanks!
View 5 Replies
View Related
