Tanner:
yet another question:
I tried to generate sql to re-create the database and when I ran it both in SSMS and in the Plesk interface, I got a ton of errors:
Changed database context to 'fsedb'.
Changed database context to 'master'.
/****** Object: Database [fsedb] Script Date: 9/4/2014 2:27:28 PM ******/
DROP DATABASE [fsedb]
Msg 3701, Level 11, State 1, Line number 2
Cannot drop the database 'fsedb', because it does not exist or you do not have permission.
/****** Object: Database [fsedb] Script Date: 9/4/2014 2:27:28 PM ******/
CREATE DATABASE [fsedb]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'fsedb', FILENAME = N'E:\MSSQL.MSSQLSERVER\DATA\fsedb_fsedb_f29bd3f3977d47479d20c61ca66c7ec4.mdf' , SIZE = 7744KB , MAXSIZE = 204800KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N'fsedb_log', FILENAME = N'D:\MSSQL.MSSQLSERVER\DATA\fsedb_fsedb_log_2d8896107626458f95aadf59d70b1934.ldf' , SIZE = 4160KB , MAXSIZE = 102400KB , FILEGROWTH = 1024KB )
Msg 262, Level 14, State 1, Line number 2
CREATE DATABASE permission denied in database 'master'.
ALTER DATABASE [fsedb] SET COMPATIBILITY_LEVEL = 110
Msg 1205, Level 13, State 68, Line number 1
Transaction (Process ID 555) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Msg 5069, Level 16, State 1, Line number 1
ALTER DATABASE statement failed.
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [fsedb].[dbo].[sp_fulltext_database] @action = 'enable'
end
Msg 15247, Level 16, State 1, Line number 27
User does not have permission to perform this action.
ALTER DATABASE [fsedb] SET ANSI_NULL_DEFAULT OFF
Msg 1205, Level 13, State 68, Line number 1
Transaction (Process ID 555) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Msg 5069, Level 16, State 1, Line number 1
ALTER DATABASE statement failed.
yet another question:
I tried to generate sql to re-create the database and when I ran it both in SSMS and in the Plesk interface, I got a ton of errors:
Changed database context to 'fsedb'.
Changed database context to 'master'.
/****** Object: Database [fsedb] Script Date: 9/4/2014 2:27:28 PM ******/
DROP DATABASE [fsedb]
Msg 3701, Level 11, State 1, Line number 2
Cannot drop the database 'fsedb', because it does not exist or you do not have permission.
/****** Object: Database [fsedb] Script Date: 9/4/2014 2:27:28 PM ******/
CREATE DATABASE [fsedb]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'fsedb', FILENAME = N'E:\MSSQL.MSSQLSERVER\DATA\fsedb_fsedb_f29bd3f3977d47479d20c61ca66c7ec4.mdf' , SIZE = 7744KB , MAXSIZE = 204800KB , FILEGROWTH = 1024KB )
LOG ON
( NAME = N'fsedb_log', FILENAME = N'D:\MSSQL.MSSQLSERVER\DATA\fsedb_fsedb_log_2d8896107626458f95aadf59d70b1934.ldf' , SIZE = 4160KB , MAXSIZE = 102400KB , FILEGROWTH = 1024KB )
Msg 262, Level 14, State 1, Line number 2
CREATE DATABASE permission denied in database 'master'.
ALTER DATABASE [fsedb] SET COMPATIBILITY_LEVEL = 110
Msg 1205, Level 13, State 68, Line number 1
Transaction (Process ID 555) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Msg 5069, Level 16, State 1, Line number 1
ALTER DATABASE statement failed.
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [fsedb].[dbo].[sp_fulltext_database] @action = 'enable'
end
Msg 15247, Level 16, State 1, Line number 27
User does not have permission to perform this action.
ALTER DATABASE [fsedb] SET ANSI_NULL_DEFAULT OFF
Msg 1205, Level 13, State 68, Line number 1
Transaction (Process ID 555) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Msg 5069, Level 16, State 1, Line number 1
ALTER DATABASE statement failed.