I am trying to upsize a large Access database to SQL Server 2005. I have limited space in the normal location where SQL Server creates its data and log files (namely, folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data). In Management Studio, I opened the properties for the server, selected Database Settings, and changed the "Database default locations" for Data and Log to a larger volume. (Happens to be Z:\SQL-Data.)
When I use Integration Services to import data into a new database, it uses the location I have specified (the Z: drive). However, when I run the Access Upsizing Wizard, the data and log files are still being created on the C: drive. I'm guessing there is a registry key that could be changed, but I would prefer to know where this file path can be designated within the Managment Studio or some other utility. Thanks!
You can Detach and Attach to move them also which is probably quicker. If you're using upsizing wizard then you probably should look at SQL Server Migration Assistan for Access freely
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
I've encountered valid database schemas that do not have a primary key. For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis. However, occasionally due to user error or a scheduled task…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download.
This will be demonstrated using Microsoft Expression Encoder 4.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers.
According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…