The network drive is loaded Vroom Vroom.

I went into SQL Server Agent.  On the General tab, the "Service Start up Account" was the one I am logging in with.  I...

Hi. 

We had some issues at the operating system level writing but those have been cleared up ... with the login for SQL Srver I can create folders and files...

When I try to create a directory on that drive I get an access denied error.

Command in job:

sqlmaint -D DoD  -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpDB  "\\Name\I\DIRECTORY"  -CrBkSubDir -BkExt "BAK" -DelBkUps 3days

Error:

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup...

Current Error:

BackupDiskFile::CreateMedia: Backup device 'I:\DIRECTORY\DoD_db_200406301343.BAK' failed to create. Operating system error = 3(The system cannot find the path specified.).

Bring back any memories?

No room on local drives

What is UNC path ?

The full command I am using is

sqlmaint -D Database  -WriteHistory  -VrfyBackup -BkUpMedia DISK -BkUpDB  "I:\DIRECTORY"  -CrBkSubDir -BkExt "BAK" -DelBkUps 3days

I can see the drive in Windows Explorer ... where does...

Hi,

I have setup a backup (My 1st ever), and it has issues running. Can you tell me why?

Note:  The drive is not on the local server ... I have...

Hi again,

When I search for the issue-tables indexes I get back many index's (One for each I see in the GUI) but none have an ID of 1 as indicated in the...

My problem is that there are many index's there ... how do I know which one is index ID1 ?

If I have no restore point ... my backup is bad...

I got the table name with the object id in the error, now I want to get the index field...is the field used to create the index another id somewhere...

No table name.  Just

Server: Msg 1505, Level 16, State 1, Line 1

CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is...

I'm guessing, but do I go back into multi user mode with:

ALTER DATABASE DBase SET MULTI_USER

Do I need 'WITH ROLLBACK IMMEDIATE ' or any other clause?

Related to link one we are not using NOLOCk in the stored procedure.

Related to link 2 we are on service pack 3.

Any other ideas?

Got It Running!  Thanks