Перенести базу данных MS SQL на другой диск.

Поиск  Пользователи  Правила 
Закрыть
Логин:
Пароль:
Забыли свой пароль?
Регистрация
Войти
 
Страницы: 1
Ответить
Перенести базу данных MS SQL на другой диск.
Сервер 1С создал новый массив на SSD и хочу перенести на него часть баз 1С в MSSQL
Вопрос как Microsoft SQL Server поменять место хранения базы данных ?
РЕШЕНИЕ:
1. Далее Вам необходимо зайти в SQL Managment Studio.
2. Сделайте бэкап базы, которую хотите перенести на другой диск (на всякий случай).
3. Нажмите правой кнопкой по нужной вам базе пункт Tasks -> Detach... В открывшемся окне нажмите ок
4. Зайдите в ту папку, там где физически лежит Ваша база данных (например у Вас C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data) и скопируйте в новую папку или диск два файла, они должны называться как Ваша база данных (расширение файлов MDF и LDF).
5. В SQL Managment Studio, в дереве, станьте на элемент "Databases" и нажмите правую кнопку, затем Attach...
6. В появившемся окне нажмите Add (добавить) и выберите файл из той папки, куда вы скопировали базу и нажмите ок.

ФОТО ТОГО КАК ЭТО ОПИСАНО ВЫШЕ:






Более подробно об этом на майкрософт: https://support.microsoft.com/ru-ru/kb/224071

При ошибке:
The file "*****.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
Решение:
The solution to this is marking the mdf and ldf file as uncompressed. Follow the following steps,
1. Right-click the .mdf file and select the properties menu.
2. From the Properties dialog box select the Advanced button
4. From the Advanced Dialog un-tick the "Compress Contents To Save Disk Space check box"

Do the same thing for the .ldf file
Услуги Системного Администратора - Работаю только с Юр. Лицами по договору обслуживания.
<strong>Nike Air Max</strong><br />
<strong>Goyard</strong><br />
<strong>Kyrie Irving Sneakers</strong><br />
<strong>Pandora Jewelry Official Site</strong><br />
<strong>Adidas Factory Outlet</strong><br />
<strong>Cortez</strong><br />
<strong>NFL Shop Official</strong><br />
<strong>Adidas NMD R1</strong><br />
<strong>Nike Shoes For Women</strong><br />
<strong>Hermes Belt</strong><br />
<strong>Pandora Bracelets</strong><br />
<strong>Yeezy Boost 350 V2</strong><br />
<strong>Pandora Charms Sale Clearance</strong><br />
<strong>Ferragamo Belt</strong><br />
<strong>Golden Goose</strong><br />
<strong>Cheap NFL Jerseys</strong><br />
<strong>Goyard Bag</strong><br />
<strong>Nike Outlet Store</strong><br />
<strong>Air Max 270 Men</strong><br />
<strong>Custom Baseball Jerseys</strong><br />
<strong>Christian Louboutin</strong><br />
<strong>Louboutin Shoes</strong><br />
<strong>Pandora Jewellery</strong><br />
<strong>NHL Store Online</strong><br />
<strong>Nike Factory</strong><br />
<strong>Nike</strong><br />
<strong>Nike Outlet Store Online Shopping</strong><br />
<strong>Fila Shoes For Women</strong><br />
<strong>Ferragamo Shoes</strong><br />
<strong>Louboutin shoes</strong><br />
<strong>Christian Louboutin Shoes</strong><br />
<strong>Adidas Ultra Boost 5.0</strong><br />
<strong>Adidas Sneakers</strong><br />
<strong>Red Bottom Shoes For Women</strong><br />
<strong>Ultra Boost</strong><br />
<strong>Nike KD 11 shoes</strong><br />
<strong>Pandora Canada</strong><br />
<strong>Asics Outlet</strong><br />
<strong>Nike Running Shoes For Women</strong><br />
<strong>Pandora</strong><br />
<strong>Nike Running Shoes</strong><br />
<strong>NFL Fan Shop</strong><br />
<strong>Nike Clearance</strong><br />
<strong>Adidas Trainers</strong><br />
<strong>Nike Air Max 95 Essential</strong><br />
<strong>Nike Outlet Store</strong><br />
<strong>Pandora Bracelet</strong><br />
<strong>Nike Shoes</strong><br />
<strong>Pandora Necklace Women</strong><br />
<strong>Nike Air Max 720</strong><br />
<strong>Adidas Originals Superstar</strong><br />
<strong>Retro Jordans</strong><br />
<strong>NFL Jerseys</strong><br />
<strong>Nike Air Max 2019</strong><br />
<strong>New Adidas 2019</strong><br />
<strong>Nike Zoom Pegasus 35</strong><br />
<strong>Red Bottom Shoes</strong><br />
<strong>Adidas NMD R1</strong><br />
<strong>Nike Shoes</strong><br />
<strong>Asics Shoes</strong><br />
<strong>Ultra Boost</strong><br />
<strong>Nike Outlet Store</strong><br />
<strong>Timberland Boots</strong><br />
<strong>Nike Outlet UK</strong><br />
<strong>Adidas Yeezy</strong><br />
<strong>Pandora Outlet</strong><br />
<strong>Nike Air Max 97</strong><br />
<strong>Nike Sneakers</strong><br />
<strong>Adidas Outlet UK</strong><br />
<strong>Yeezy Boost 750</strong><br />
<strong>Fila Sneakers</strong><br />
<strong>Air Max 98 Gundam</strong><br />
<strong>Nike 720</strong><br />
<strong>Air Max 97</strong><br />
<strong>Adidas Superstar Women</strong><br />
<strong>Jordan 11</strong><br />
<strong>Nike Store</strong><br />
<strong>Christian Louboutin Outlet</strong><br />
<strong>New Nike 2019</strong><br />
<strong>Mens Basketball Shoes</strong><br />
<strong>Yeezy Sneakers</strong><br />
<strong>Yeezy 500</strong><br />
<strong>Nike Air Force</strong><br />
<strong>NBA Shop</strong><br />
<strong>Adidas NMD</strong><br />
<strong>Adidas Superstars</strong><br />
<strong>NFL Jerseys</strong><br />
<strong>NFL Store</strong><br />
<strong>NMD R1</strong><br />
<strong>Pandora Charms</strong><br />
<strong>Yeezy</strong><br />
<strong>Nike Air Max</strong><br />
<strong>Pandora Charms Outlet</strong><br />
<strong>Balenciaga</strong><br />
<strong>NFL Jerseys</strong><br />
<strong>Off White Nike</strong><br />
<strong>Adidas Shoes Outlet</strong><br />
<strong>Asics Running Shoes</strong><br />
<strong>Nike Outlet Store</strong><br />
<strong>Yeezy Shoes</strong><br />
<strong>Adidas Shoes Outlet</strong><br />
<strong>Nike Free Rn 2019</strong><br />
<strong>Puma Outlet Store</strong><br />
<strong>Nike Air Max 270</strong><br />
<strong>Vans</strong><br />
<strong>Yeezy Boost 350</strong><br />
<strong>Christian Louboutin Shoes</strong><br />
<strong>Adidas Yeezys</strong><br />
<strong>Asics</strong><br />
<strong>Adidas UK</strong><br />
<strong>Nike Outlet Store Online Shopping</strong><br />
<strong>Louboutin Outlet</strong><br />
<strong>Nike Air Max 720 Men</strong><br />
<strong>Moncler Outlet</strong><br />
<strong>Air Max 2019</strong><br />
<strong>Adidas Outlet Store</strong><br />
<strong>Jordan Shoes</strong><br />
<strong>Nike Running Shoes</strong><br />
<strong>Adidas Yeezy</strong><br />
<strong>Hermes Handbags</strong><br />
<strong>Nike Clearance Outlet</strong><br />
<strong>Pandora Charms</strong><br />
<strong>Adidas Store</strong><br />
<strong>Nike Store Online</strong><br />
<strong>Christian Louboutin Outlet</strong><br />
<strong>Christian Louboutin Shoes Sale Outlet</strong><br />
<strong>Adidas Sneakers For Men</strong><br />
<strong>NMDS</strong><br />
<strong>Nike Outlet Store</strong><br />
<strong>Valentino Outlet</strong><br />
<strong>Fjallraven</strong><br />
<strong>Nike Shoes</strong><br />
<strong>Yeezy</strong><br />
<strong>Adidas Trainers</strong><br />
<strong>MLB Apparel</strong><br />
<strong>Nike Air Max 98 Gundam</strong><br />
<strong>Ferragamo Outlet</strong><br />
<strong>NBA Jerseys</strong><br />
<strong>Pandora Rings</strong><br />
<strong>Yeezy Sneakers</strong><br />
<strong>NFL Gear</strong><br />
<strong>Valentino Shoes</strong><br />
<strong>Christian Louboutin Outlet</strong><br />
<strong>Pandora Charm</strong><br />
<strong>Adidas Stan Smith</strong><br />
<strong>Nike Shoes</strong><br />
<strong>Adidas Outlet</strong><br />
<strong>Nike Outlet Store</strong><br />
<strong>Puma Shoes</strong><br />
<strong>NFL Store</strong><br />
<strong>Nike Shoes</strong><br />
<strong>Nike Trainers Sale</strong><br />
<strong>Nike Sneakers For Men</strong><br />
<strong>Pandora Charms Outlet</strong><br />
<strong>Nike Factory Outlet</strong><br />
<strong>Nike Outlet</strong><br />
<strong>Air Max 270 Men</strong><br />
<strong>Ultra Boost Adidas</strong><br />
<strong>Nike Lebron 16</strong><br />
<strong>Adidas Shoes</strong><br />
<strong>Yeezy 500</strong><br />
<strong>Adidas Ultra Boost</strong><br />
<strong>NFL Shop</strong><br />
<strong>Red Bottom Shoes For Women</strong><br />
<strong>NHL Jerseys</strong><br />
<strong>Nike Shoes For Men</strong><br />
<strong>Lebron Shoes</strong><br />
<strong>Asics</strong><br />
<strong>Retro Jordans</strong><br />
<strong>Nike Air Max 95</strong><br />
<strong>Nike Factory</strong><br />
<strong>Nike Factory Store</strong><br />
<strong>Pandora Bracelet Charms</strong><br />
<strong>Balenciaga Sneakers</strong><br />
<strong>Air Force 1 High</strong><br />
<strong>Basketball Shoes Nike</strong><br />
<strong>Pandora Jewelry Official Site</strong><br />
<strong>Lebron 16</strong><br />
<strong>Yeezys Shoes</strong><br />
<strong>Jordan Shoes</strong><br />
<strong>NFL Jerseys</strong><br />
<strong>Air Max 270</strong><br />
<strong>Nike Outlet</strong><br />
<strong>Pandora Jewelry Store</strong><br />
<strong>NFL Shop Official Online Store</strong><br />
<strong>Adidas Store</strong><br />
<strong>Fjallraven Backpack</strong><br />
<strong>Asics Running Shoes</strong><br />
<strong>Nike Shoes For Men Basketball</strong><br />
<strong>Pandora Jewelry Store</strong><br />
<strong>Adidas Outlet Store</strong><br />
<strong>Skechers Go Walk</strong><br />
<strong>Nike Sneakers</strong><br />
<strong>Nike Outlet Online</strong><br />
<strong>New Nike Shoes</strong><br />
<strong>Nike Shoes For Men</strong><br />
<strong>Air Jordan Sneakers</strong><br />
<strong>Goyard Handbags</strong><br />
<strong>Off White</strong><br />
<strong>Pandora Jewelry</strong><br />
<strong>Yeezy Boost 350 V2</strong><br />
<strong>Air Max 98</strong><br />
<strong>Ice Jerseys</strong><br />
<strong>Nike Air Max Trainers</strong><br />
<strong>Adidas Superstars</strong><br />
<strong>Adidas Yeezy Boost 350 V2</strong><br />
<strong>Nike Sneakers</strong><br />
<strong>Red Bottom Shoes</strong><br />
<strong>Adidas NMD XR1</strong><br />
<strong>Fjallraven Backpack</strong><br />
<strong>Asics Shoes</strong><br />
<strong>Nike Clearance Store</strong><br />
<strong>Womens Nike Shoes</strong><br />
<strong>Nike Cortez</strong><br />
<strong>Fila Disruptor ii</strong><br />
<strong>Air Max 2019</strong><br />
<strong>Nike Store</strong><br />
<strong>Nike Shoes For Kids</strong><br />
<strong>NFL Shop Official Online Store</strong><br />
<strong>Adidas Shoes</strong><br />
<strong>Adidas NMD</strong><br />
<strong>Adidas Yeezy</strong><br />
<strong>Pandora Jewelry Store</strong><br />
<strong>Louboutin Shoes</strong><br />
<strong>Nike Sneakers</strong><br />
<strong>Nike Sneakers For Men</strong><br />
<strong>Adidas Superstars</strong><br />
<strong>Adidas Outlet UK</strong><br />
<strong>Nike Lebron 16</strong><br />
<strong>Adidas Shoes For Men</strong><br />
<strong>Nike KD Shoes</strong><br />
<strong>Jordan Retro</strong><br />
<strong>Nike Factory Outlet Store Online</strong><br />
<strong>Pandora Bracelet</strong><br />
<strong>NBA Clothing</strong><br />
<strong>Nike Outlet</strong><br />
<strong>Air Jordan Shoes</strong><br />
<strong>Nike Outlet</strong><br />
<strong>Adidas UK</strong><br />
<strong>New Nike Shoes</strong><br />
<strong>Fitflop</strong><br />
<strong>Pandora Canada</strong><br />
<strong>Pandora Ring</strong><br />
<strong>MLB Shop Online</strong><br />
<strong>Asics Outlet</strong><br />
<strong>Nike Shoes</strong><br />
<strong>MLB Official Site</strong><br />
<strong>Pandora Jewelry Black Friday</strong><br />
<strong>Red Valentino</strong><br />
<strong>MLB Shop</strong><br />
<strong>NBA Jerseys</strong><br />
<strong>Nike Outlet Store</strong><br />
<strong>Nike Air Max 270 Men</strong><br />
<strong>New Shoes</strong><br />
<strong>Pandora Charms Outlet</strong><br />
Страницы: 1
Ответить
Читают тему (гостей: 1, пользователей: 0, из них скрытых: 0)
Форма ответов
Текст сообщения*
:) ;) :D 8-) :( :| :cry: :evil: :o :oops: :{} :?: :!: :idea:
Защита от автоматических сообщений. Введите символы, изображенные на этой картинке в поле ввода &quote;Код подтверждения&quote;.