I AM TRYING TO CREATE THE BACKUP FILES FOR A DATABASE THAT I HAVE BEEN USING OR MONTHS.:I AM RUNNING SQL SERVER EXPRESS 2014, AND VISUAL BASIC 2015 IN WINDOWS 10. IN SQL SERVER MANAGEMENT STUDIO I CAN RUN THIS SIMPLE COMMAND LIST AND IT RUNS PERFECT.
USE [D:\DATA FILES 092015\DVD_LIST.MDF]
SELECT * FROM [DVD_List]
BUT WHEN I TRY TO RUN THIS BACKUP SEQUENCE:
USE [D:\DATA FILES 092015\DVD_LIST.MDF]
ALTER DATABASE DVD_List SET RECOVERY FULL;
GO
BACKUP DATABASE DVD_List
TO DISK = 'F:\SQLServerBackups\DVD_ListfULLrm.bak'
WITH FORMAT;
GO
BACKUP LOG DVD_List
TO DISK = 'F:\SQLServerBackups\DVD_ListfULLrmlOG.bak';
GO
I GET THESE ERRORS:
Msg 5011, Level 14, State 5, Line 2
User does not have permission to alter database 'DVD_List', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Msg 911, Level 16, State 11, Line 5
Database 'DVD_List' does not exist. Make sure that the name is entered correctly.
Msg 3013, Level 16, State 1, Line 5
BACKUP DATABASE is terminating abnormally.
Msg 911, Level 16, State 10, Line 10
Database 'DVD_List' does not exist. Make sure that the name is entered correctly.
Msg 3013, Level 16, State 1, Line 10
BACKUP LOG is terminating abnormally.
HOW DO I GIVE MYSELF PERMISSION TO ALTER MY OWN DATABASE? BETTER YET, WHY DO I NEED TO GIVE MYSELF PERMISSION TO ALTER MY OWN DATABASE? AND THIRD, WHY DOES IT WORK IN THE FIRST SEQUENCE AND NOT THE SECOND? (PROBABLY BECAUSE IT DOESN’T CARE WHO LOOKS AT THE DATA BUT IS FUSSY ABOUT WHO ALTERS IT)