Post reply

how to create maintenace plan in sql server 2008

  • July 20, 2011 at 5:37 am

    #253956

    how to create maintenace plan for map drive in sql server 2008.pls give steps..and i have using windows authundication mode..

  • July 20, 2011 at 7:07 am

    #1355564

    Your questions' a little unclear...do you not know how to create a maintenance plan, or are unsure of wether you can use a mapped drive?

    Your best bet is to simply use the Wizard to help you set it up:

    after you get inside there and selectbackup databases, you get to this screen: that's where you decide where the backups will be placed:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 20, 2011 at 7:37 am

    #1355591

    after create maintenance plan i have run the jobs but i got error' and error also attached.. kindly check it

    Message

    Executed as user: Testtech\sqldbadmin. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 18:47:17 Progress: 2011-07-20 18:47:17.89 Source: {F5B98876-3662-41C1-9496-AE5A36AE0875} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2011-07-20 18:47:20.74 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [master] TO DISK = N'\\Testserver..." failed with the following error: "Cannot open backup device '\\Testserver1\sql_backup\FULL_BACKUP\TESTDB\master_backup_2011_07_20_184718_3758016.bak'. Operating system error 53(failed to retrieve text for this error. Reason: 15105). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2011-07-20 18:47:20.79 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [model] TO DISK = N'\\Testserver1..." failed with the following error: "Cannot open backup device '\\Testserver1\sql_backup\FULL_BACKUP\TESTDB\model_backup_2011_07_20_184718_3924038.bak'. Operating system error 53(failed to retrieve text for this error. Reason: 15105). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2011-07-20 18:47:20.83 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [msdb] TO DISK = N'\\Testserver1\..." failed with the following error: "Cannot open backup device '\\Testserver1\sql_backup\FULL_BACKUP\TESTDB\msdb_backup_2011_07_20_184718_4099826.bak'. Operating system error 53(failed to retrieve text for this error. Reason: 15105). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 18:47:17 Finished: 18:47:20 Elapsed: 3.781 seconds. The package execution failed. The step failed.

  • July 20, 2011 at 7:57 am

    #1355619

    Have you verified that Testtech\sqldbadmin has permissions to the share?

    \\Testserver1\sql_backup\FULL_BACKUP\TESTDB\

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 20, 2011 at 8:07 am

    #1355638

    how to check the permission yar..?

  • July 20, 2011 at 8:28 am

    #1355670

    You will need to set (or check) share and NTFS Permissions.

    The best example that I saw was on the Microsoft Book Managing and Maintaining a Microsoft Windows Server 2003 Environment preparation for the 70-290 Exam.

    The following should help you.

    http://www.windowsecurity.com/articles/Share-Permissions.html

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply