USE [master]
GO
/****** Object: Database [saveRequestInfoEF] Script Date: 08/24/2013 11:46:03 ******/
CREATE DATABASE [saveRequestInfoEF] ON PRIMARY
( NAME = N'saveRequestInfoEF', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\saveRequestInfoEF.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'saveRequestInfoEF_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\saveRequestInfoEF_log.LDF' , SIZE = 576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [saveRequestInfoEF].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [saveRequestInfoEF] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ANSI_NULLS OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ANSI_PADDING OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ARITHABORT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [saveRequestInfoEF] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [saveRequestInfoEF] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ENABLE_BROKER
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [saveRequestInfoEF] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET READ_WRITE
GO
ALTER DATABASE [saveRequestInfoEF] SET RECOVERY FULL
GO
ALTER DATABASE [saveRequestInfoEF] SET MULTI_USER
GO
ALTER DATABASE [saveRequestInfoEF] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [saveRequestInfoEF] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'saveRequestInfoEF', N'ON'
GO
USE [saveRequestInfoEF]
GO
/****** Object: Table [dbo].[requestInfo] Script Date: 08/24/2013 11:46:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[requestInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[IP] [nvarchar](50) NOT NULL,
[UserAgent] [nvarchar](max) NOT NULL,
[UrlReferrer] [nvarchar](max) NOT NULL,
[requestDateTime] [datetime] NOT NULL,
CONSTRAINT [PK_requestInfo] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO上传到网盘或者其它方式给我都可以,请帮忙一下!小弟的机器安装了2008 R2的,没法生成
GO
/****** Object: Database [saveRequestInfoEF] Script Date: 08/24/2013 11:46:03 ******/
CREATE DATABASE [saveRequestInfoEF] ON PRIMARY
( NAME = N'saveRequestInfoEF', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\saveRequestInfoEF.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'saveRequestInfoEF_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\saveRequestInfoEF_log.LDF' , SIZE = 576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [saveRequestInfoEF].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [saveRequestInfoEF] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ANSI_NULLS OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ANSI_PADDING OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ARITHABORT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [saveRequestInfoEF] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [saveRequestInfoEF] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ENABLE_BROKER
GO
ALTER DATABASE [saveRequestInfoEF] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [saveRequestInfoEF] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [saveRequestInfoEF] SET READ_WRITE
GO
ALTER DATABASE [saveRequestInfoEF] SET RECOVERY FULL
GO
ALTER DATABASE [saveRequestInfoEF] SET MULTI_USER
GO
ALTER DATABASE [saveRequestInfoEF] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [saveRequestInfoEF] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'saveRequestInfoEF', N'ON'
GO
USE [saveRequestInfoEF]
GO
/****** Object: Table [dbo].[requestInfo] Script Date: 08/24/2013 11:46:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[requestInfo](
[ID] [int] IDENTITY(1,1) NOT NULL,
[IP] [nvarchar](50) NOT NULL,
[UserAgent] [nvarchar](max) NOT NULL,
[UrlReferrer] [nvarchar](max) NOT NULL,
[requestDateTime] [datetime] NOT NULL,
CONSTRAINT [PK_requestInfo] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO上传到网盘或者其它方式给我都可以,请帮忙一下!小弟的机器安装了2008 R2的,没法生成
[code=csharp][===================================无法为该请求检索数据。 (Microsoft.SqlServer.Management.Sdk.Sfc)------------------------------
有关帮助信息,请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476------------------------------
程序位置: 在 Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
在 Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.GetOriginalDatabaseName(String primaryFilePath)
在 Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.PopulatePrimaryFileData(String primaryFilePath)
在 Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile..ctor(SqlManagementUserControl parent, CDataContainer dc, String fullPath, String databaseOwner, ServerConnection connectionInfo)
在 Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.IsSelectedFileValid(BrowseFolder dlg)===================================执行 Transact-SQL 语句或批处理时发生了异常。 (Microsoft.SqlServer.ConnectionInfo)------------------------------
程序位置: 在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand, SqlCommand& command)
在 Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query, SqlCommand& command)
在 Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
在 Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
在 Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteWithResults(StringCollection query, Object con, StatementBuilder sb)
在 Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
在 Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
在 Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
在 Microsoft.SqlServer.Management.Smo.PrimaryFile.GetData(EnumResult erParent)
在 Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
在 Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
在 Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
在 Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)===================================D:\saveRequestInfoEF 不是主数据库文件。 (.Net SqlClient Data Provider)------------------------------
有关帮助信息,请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=5171&LinkId=20476------------------------------
服务器名称: .
错误号: 5171
严重性: 16
状态: 1
行号: 1
------------------------------
程序位置: 在 Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand, SqlCommand& command)/code]
在SqlSer2008 R2中你可以生成2005的数据库???还望请教!导出,是脚本而已啊!
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS
你上边应该是2005的路径吧,先看这个路径是否存在目前正在用2008,连接管理2005、2000数据库没什么问题,
建议以后数据库采用备份、还原的方式移植
你确定你可以在2008中导出2005的数据库?要mdf格式的,不能吧?
理由:
怎么把sqlserver 2008 mdf文件 转换成 sqlserver 2005 mdf文件 - CSDN论坛 - CSDN.NET
http://bbs.csdn.net/topics/380206403另外,你知道可以的话,就请说详细一点,不要那么含蓄!每次都说那么一点点,你用得着这样吗?!
多谢你的提醒,刚才用还原的方法成功还到上面提到那个没扩展名的数据了,但我要的是mdf格式的。。
在2008中可以导出为2005的mdf格式的么?还望指教!
多谢提醒!在2008中能备份出2005,MDF格式的文件么?