Información de la empresa
Acerca de GFI Software™
Carreras
Centro de prensa
Pequeñas y medianas empresas
Soluciones de correo y mensajería
Soluciones de seguridad de red
Todos los productos
Want help with your product upgrades?
Upgrades made easy
IDIOMAS
▼
English
Deutsch
Español
Français
Italiano
Nederlands
简体中文
繁体中文
BLOG
CONTACTAR CON NOSOTROS
Empresa
Productos
SEGURIDAD DE LA RED
GFI LanGuard
Escáner de seguridad de red con administración de vulnerabilidad y actualizaciones
GFI MailEssentials
Seguridad y anti-spam para sus servidores de correo
Kerio Control
The all-in-one next generation firewall for small and mid-sized businesses.
Exinda Network Orchestrator
Exceptional quality of experience for business critical applications
Exinda SD-WAN
Multi-element WAN, traffic management and prioritization
Red de comunicacion
GFI Archiver
Servidor de archivado para productividad, administración y cumplimiento
GFI FaxMaker
Software servidor de fax de red para Exchange/SMTP/Lotus
GFI FaxMaker Online
Fax sencillo, rápido, hospedado
Kerio Connect
Enterprise-class Email, Calendars, Contacts, Tasks, Chat, and More
DESCARGAS
BUY NOW
Encontrar un mayorista
Empresa
SOBRE NOSOTROS
Sobre nosotros
Carreras
Liderazgo
Premios
Clientes
Pilares de Marca
NOTICIAS Y EVENTOS
Sala de prensa
En las noticias
Notas de prensa
Webcasts y eventos
Blog
Asociados
PROGRAMA DE PARTNERS
Programa de partners
Hágase GFI Partner
Partner Links
Encontrar un distribuidor
Encontrar un mayorista
GFI BETA products
GFI OEM Partners
GFI Technology Partners
Partner Portal
Programa de partners
Soporte
BY PRODUCT
GFI Archiver
GFI EndPointSecurity
GFI EventsManager
GFI FaxMaker
GFI FaxMaker Online
GFI LanGuard
GFI MailEssentials
GFI WebMonitor
Kerio Connect
Kerio Control
Kerio Operator
Exinda Network Orchestrator
OTHER AREAS
Documentation
Upgrade Center
Knowledge Base
Community Blog
Status
CONTACT SUPPORT
FEEDBACK
Descargas
INICIAR SESIÓN
Products
GFI FaxMaker Online
Kerio Cloud
Kerio Product Registration
Support
GFI Support
Product Downloads and Upgrades
Shops
Kerio Shop
Tools
Accounts Portal
My Kerio
Partner Portal
MailEssentials GFI
How to move Microsoft SQL Server databases to a new location by using detach and attach functions in Microsoft SQL Server
Open the Microsoft SQL Management Studio server and connect to the Microsoft SQL server where the database is located
Locate the database you want to move the
location
of under the
Databases
node
Right click the database and choose
Properties
Click the
Files
node of the
Database Properties
dialog
Note the
Path
and
Filename
of both of the files (one will be a .MDF database file and one will be a .LDF transaction log file) and close the dialog
Make sure the GFI Software application that uses the database is no longer running (close the console and stop the services)
Right click the database and choose
Tasks
>
Take Offline
Next, right click the database and choose
Tasks
>
Detach...
Check the box to
Drop Connections
and click the
OK
button at the bottom
Move the database files to the drive and directory where you want to store them
In the management studio, right click the
Databases
node and select
Attach...
Click the
Add...
button, navigate to the directory you put the .MDF database file and select it (it will automatically add the .LDF transaction log file)
Click
OK
and the database will be re-attached
Notes:
This procedure can also be done using SQL statements. See the following Microsoft article:
http://support.microsoft.com/kb/224071
Before attempting any database modifications, please ensure all appropriate GFI Software services are stopped, to ensure no data is lost
Consentimiento
GFI Software recopila sus datos para que podamos usarlos para comunicarnos con usted acerca de nuestros productos y servicios. Revise nuestra
política de privacidad
sobre cómo protegemos y administramos sus datos enviados.
Al seguir navegando en este sitio, usted da su consentimiento para que se utilicen las cookies. Para más detalles, lee nuestra
Política de Cookies
Accepto