473,324 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Master File not Accessible for Copying

Re SQL Server 2005 Express

When I attempt to copy the master file for backing up, it is being used by
another application, even after shutting down the PC completely and powering
it up again. What can I do to make back-ups?

Zach
Sep 23 '06 #1
2 1599
Use a BACKUP DATABASE Transact-SQL command to backup SQL Server database
files. For example:

BACKUP DATABASE master
TO DISK='C:\Backups\master.bak'
WITH INIT

Not only does this allow you to take hot backups while the SQL server
service is running, the backup file size is less than the database file
sizes because only used space is backed up.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Zach" <no*@all.accessiblewrote in message
news:45********************@dreader2.news.tiscali. nl...
Re SQL Server 2005 Express

When I attempt to copy the master file for backing up, it is being used by
another application, even after shutting down the PC completely and
powering
it up again. What can I do to make back-ups?

Zach


Sep 23 '06 #2
"Dan Guzman" <gu******@nospam-online.sbcglobal.netwrote in message
news:RY*****************@newssvr25.news.prodigy.ne t...
Use a BACKUP DATABASE Transact-SQL command to backup SQL Server database
files. For example:

BACKUP DATABASE master
TO DISK='C:\Backups\master.bak'
WITH INIT

Not only does this allow you to take hot backups while the SQL server
service is running, the backup file size is less than the database file
sizes because only used space is backed up.
Thank you (done),
Zach.
Sep 23 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: VB Programmer | last post by:
I know that Master pages will be greatly enhanced in the next version of VS. For now, I have several tables that make up a site-wide Header, Footer and Nav bar. Each of these are using user...
13
by: Bijoy Naick | last post by:
My project contains multiple aspx pages. Many of these pages have code-behind that use several helper functions. Instead of copying each helper function into each aspx page, I am thinking of...
2
by: Frank Rizzo | last post by:
Hello, my app needs to copy a file from local TEMP folder to network share. The network share is accessible via a domain ID. I am trying to call LogonUser API, then ImpersonateLoggedOnUser, then...
2
by: .Net Believer | last post by:
I using the routine below to copy file to a network drive for a regular backup process. Before calling this routine I using another function to check the presence of the LAN connection and the...
1
by: Miguel Dias Moura | last post by:
Hello, I am creating a master page for a web site. All pages created from this master page will use the same theme. However I am not able to add the theme in my master page. Why is that? ...
4
by: fishek | last post by:
I have a Master Page with a property defined in codebehind like this: private string profile; public string Profile { get { return profile; } } I can set the property value in the master...
7
by: xkeops | last post by:
Thinking of creating a website, most of the pages will have a general toolbar menu, a content and a footer. The content will be the only one who's gonna change but the rest (header,footer) will...
1
by: Dan | last post by:
I have an application that I want to use for copying files. My goal is to copy a files, if a file is in use or not accessible because of security reasons I want to make note of that file then...
2
by: _Who | last post by:
Hope I'm not posting twice. Posted this a while ago but it does not show in my ng. I have a .htm file that shows in an iframe. I need the .htm to use a style class from the master. The...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.