нет, не прокатит.
проверяю так:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
create database db8;
go
alter database db8
set recovery full;
go
backup database db8
to disk = 'Z:\Anna\_backups\hp\db8\db8_full.bak';
go
alter database db8
set offline;
go
/* copy .mdf to Z:\Anna\_backups\hp\db8, rename .ldf
test it on another server:
USE [master]
GO
CREATE DATABASE [db8] ON
( FILENAME = N'Z:\Anna\_backups\hp\db8\db8.mdf' )
FOR ATTACH
GO
------------
File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\db8_log.LDF" may be incorrect.
New log file 'Z:\Anna\_backups\hp\db8\db8_log.LDF' was created.
drop database db8;
go
re-copy .mdf to Z:\Anna\_backups\hp\db8, rename .ldf
*/
alter database db8
set online;
go
use db8;
go
with cte as(
select number as n
from master..spt_values
where type = 'p' and number between 0 and 999)
select c1.n * 1000 + c2.n + 1 as n
into dbo.num1
from cte c1 cross join cte c2;
go
alter database db8
set offline;
go
/* copy .ldf to Z:\Anna\_backups\hp\db8*/
/* go to another server */
USE [master]
GO
CREATE DATABASE [db8] ON
( FILENAME = N'Z:\Anna\_backups\hp\db8\db8.mdf' ),
( FILENAME = N'Z:\Anna\_backups\hp\db8\db8_log.LDF' )
FOR ATTACH
GO
-----------------------------------
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'db8'. CREATE DATABASE is aborted.
Msg 5125, Level 24, State 1, Line 1
File 'Z:\Anna\_backups\hp\db8\db8.mdf' appears to have been truncated by the operating system. Expected size is 3328 KB but actual size is 2304 KB.
Msg 3313, Level 21, State 2, Line 1
During redoing of a logged operation in database 'db8', an error occurred at log record ID (30:122:54). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
не могу сейчас объяснить, на какой момент он требует .mdf,
но файл не обрезан.
опыт был проведен 2 раза, файл копируется нормально.
для проверки в третий раз просто пробую сразу же приаттачить этот .mdf без .ldf,
и все с ним ok.
к концу выполнения заполнения таблицы чисел .mdf становится 18.688 Кб,
сервер же требует .mdf размером в 3328 KB
