"Logical file 'Movies' is not part of database"
Usually when I need to make a manual change I just back up my SQL Server Management Studio 2012 database called Movies, then upload it to my host, then use their restore feature to implement it.
I am still in a testing phase so data does not need to be kept that is acquired online, however I wanted to try keeping the data today so I used the host's backup option which created a DB_76779_test_backup.bak file for me.
I then download this and "attempted" to updated it's information into the SQL database on my machine (Movie) which I believe is where I messed everything up.
From what I remember I right-clicked my database "Movies" and selected "Tasks -> Restore -> Database", I kept everything as is, but for Source I selected Device then chose the DB_76779_test_backup.bak file and and below that selected "Movies" as the Database and hit OK.
This seemed to work fine, so I opened and edited the tables values that needed to be changed. Then as usual, I just backed it up, FTPed it to the host, and restored my database.
I got an error however when trying to restore and my support told me the following.
"Logical file 'Movies' is not part of database 'DB_76779_test'. Use RESTORE FILELISTONLY to list the logical file names."
I'm afraid we only support restores of databases that contain only 1 .mdf file and 1 .ldf file with no extra partitions.
I am assuming that since the only different thing I did this time was restore my database on my computer is that somehow I broke it, or created more than 1 mdf and ldf file (no clue what those even are). All I was trying to do was keep the actual data from online, so I am not even sure if that was correct way to go about this, but regardless I am unable to restore the database on my host now..
What mistake have I made? I only know a basic level of databasing and not much of the "under the hood" mechanics.
That SSMS dialog is a little difficult to work with some times. It looks like you want to rename your database to Movies. The problem is when you change the name field it does not update the logical names it is using for the files. IIRC simply switching to the Files "tab" on the left will update it and then you can restore fine. That or do your restore with the "old" name and then name the database after restore.
- SQL copying data with new foreign keys
- An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
- space is not allowed after parameter prefix ':' in SpEL support in Spring Data JPA @Query definitions
- SQLAlchemy - Get query results in same order as IN clause
- SQL Grouping and Nested Concatenation
- Extract weekday, millisecond, microsecond, nanosecond from a date in Postgres
- How can I refer to a variable in postgresql dynamic SQL?
- How to pull width & height out of string?
- Add new columns without using Alter
- Get columns of index on DB2
- Athena Query - "NOT IN" slow performance
- SQL one to one relationship vs. single table
- How can I number the instance of a duplicate record?
- How to fix SQL for AWS Athena
- SQL SELECT query not working in mysql
- How can i insert/ select into a table and delete copied records from original table?
- How to convert oracle regex pattern into Databricks compatible version?
- Select min or max based on where duplicate value exists
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- WHERE clause pulling incorrect values
- Sql select all conversation by group
- Create an inline SQL table on the fly (for an excluding left join)
- How to execute raw SQL in Flask-SQLAlchemy app
- Update SQL table using selection from another table
- Clarification on joins
- Foreign key constraint may cause cycles or multiple cascade paths?
- PowerApps retrieving data from SQL using compound criteria
- T-SQL Get File Extension Name from a Column
- postgres - How to parse json array elements?
- How to query the distribution (grouped by value range) of a column value in Oracle?