.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

create one-time backup files

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :

(using SQL 2008)

Here is my situation.  I have administrative rights to a particular database, but not the entire server.  The server admin makes a new backup every night for all the databases. 

At certain points in time, I would also like to save a backup file of my database, but of course don't want to alter the existing backup schedule.  Is this possible?

View Complete Post

More Related Resource Links

How to create and copy files into a subdirectory at run time.


Good Day,


I have a folder on my server say:


in that folder there is 4 folders






in the pics folder is jpg's that are the buttons for a web page, the web page is in the MasterArt folder and is named default.aspx


upon a user creating an account, i have my program create a folder under a subfolder named ARTIST

I got that part but now what I need to learn how to do is to have at run time, when a new user creates an account, that my program creates a subdirectory under the ARTIST subdirectory and then I copy the default.aspx from the MasterArt folder into their folder, then copy the folders and contents of the 4 subfolders (pics, videos, music, other) so that they now have the direcotries and its contents.


Example: I create a user account and my artist name is Kevin

a subdirectory is created called Kevin, the folder Kevin should now have the default.aspx page, and 4 sub folders, pics, videos, music, and other.


How do I do this? I thanks in advance for any help!



Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

Toolbox: Save Coding Time, Manage Compressed Files, and More


Save Coding Time, Manage Compressed Files, and More

Scott Mitchell

MSDN Magazine January 2007

Sql Server 2005 backup misses files

I have a SQL Server 2005 database that contains 3 files.  Sometimes when I run rhe backup, it appears to only backup 2 of the three files.  The only way I can get it to return to a full backup is to restore the database from a backup tape.

How to create a "search function" to find files and folders using C++ windows forms?

As mentioned above, how can I make a windows forms application that searches for files and folders specified by the user and display results in a ListBox? Thanks in advance another question: How can I make a textbox transparent? I would be really grateful if anybody told me what books are good to learn windows forms using C++? thanks again

How to create time-sheet ?

I don't know what can I call it in English? 01-Aug 02-Aug 03-Aug ... 31-Aug worker A 8(textbox) 8 ... 8 worker B 4 8 ... 8 worker C 8 8 ... 8 ... ... ... ... ...                                              Submit buttonhow to create a datagrid like above, date columns (days of month): dynamicallyworker column: name of worker in each department: dynamicallywe will enter number of hour worker do everyday in textboxThanks

Not able to create a new site from a previous backup

Hi,   I want to create a new site from a backup. I did the restore process in Central Admin. I gave new appplication URLand new content database name in the last page of restore process. I  tried restore several times  but always the following error msg is showing in backup and restore status.   Error Status TEST 600 6/30/2008 11:22 AM Object TEST 600 (previous name: TEST PORTAL) failed in event OnRestore. For more information, see the error log located in the backup directory. SPUpdatedConcurrencyException: An update conflict has occurred, and you must re-try this action. The object SPWebApplication Name=TEST 600 Parent=SPWebService is being updated by WSS\Administrator, in the OWSTIMER process, on machine WSS. View the tracing log for more information about the conflict. WSS_Content_TEST_PORTAL_600 Completing restore 6/30/2008 11:29 AM Object WSS_Content_TEST_PORTAL_600 (previous name: WSS_Content_TEST_PORTAL) failed in event OnPostRestore. For more information, see the error log located in the backup directory. SPException: Cannot attach database to Web application. Use the command line tool or Central Administration pages to attach the database manually to the proper Web Application.   I am also showing the log file details below. Log File Details   [06/30/2008 11:19:44 AM]: Verbose: Using directory: \\wss\TEST\Backup\spbr0003\.[06/30/2008 11:19:44 AM]: Ve

Is it possible to create WSP files within Designer 2010?

I'm just getting to grips with Designer 2010 and was wondering if I edited a CSS, Pagelayout or Masterpage (for example), how easy it would be to package them up into a WSP file? Would it be easy to export the changes within Designer into VS2010? Can you import the changes into VS2010? Or would I have to do it the hard way and copy each file and drop them into a WSP project in VS2010 and then build and deploy? Just getting my head around which would be more automated - if at all. Cheers.   Keith.

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

adding sqlserver database files in the time of project deployeement

hi all,        how can i add sql server 2005 database files in the time of a windows application project deployment i have designed a project in Visual Studio 2005 using vb.net language and i want add sql server 2005 database file to it. i am connecting to sql server database by the connection string not using any any dataset or anything else. so how can i add database file ... please replay... 

Maintenance Plan Backup Failing Time to time

See ERRORO Below: I am using SQL Server 2008 64 bit enterprise edition and backing up on network drive. This differential backup run every weekdays and up to sat, it works just fine and sometimes fails every other week. Need some advice. I use a domain service account on SQL Server agent. Executed as user: DOMAIN\SERVER_ag_def. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:45:04 AM  Progress: 2010-09-11 00:45:34.09     Source: {8006A2EB-FD95-45C3-8426-554DAE1895B4}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp...".: 100% complete  End Progress  Progress: 2010-09-11 00:58:12.09     Source: Back Up Database (Differential)      Executing query "BACKUP DATABASE [DataCollectorDW] TO  DISK = N'\\w...".: 50% complete  End Progress  Progress: 2010-09-11 01:01:17.26     Source: Back Up Database (Differential)      Executing query "declare @backupSetId as int  select @backupSetId =...".: 100% complete  End Progress  Progress: 2010-09-11 01:01:22.22     Source: Mai

How does one create context-sensitive custom help files?

We are an ISV and would like to know how to add a feature to our solution that uses the existing help functionality to display help based on the user type and context of that user type in the system.  I have been searching to no avail, if there is a How-To article somewhere I'd love a link! Thanks, -Torrance R. MillerIntegrating the future into today

Report Builder 3.0 issue - can view existing rdl files but cannot create new reports

I have Report Builder 3.0 deployed on my local machine pointing to a remote SQL Server 2008 R2 instance outside of my local domain.  Within this local Report Builder 3.0 instance I am able to open up previously created rdl files from the remote SQL Server 2008 R2 instance that I am connecting to.  However, if I try to create a new report on my local instance of Report Builder 3.0 and attempt to use the same data source as was used to create these existing rdl files, I receive the error: "Unable to connect to data source. The user credentials provided in the connection string do not have permission to connect to Reporting Services."  So why can I open existing rdl files from this remote SQL Server 2008 R2 instance, but not create new ones even though I'm using the same data source as the existing rdl files?  Thanks, Mark

How to create templete controls inside a gridview at run time


i am creating a grid view at run time.now i want to create controls inside the gridview at run time itself,and how to Bind/Eval it.

plz help me

Delete Old Backup Files that are saved in .RAR format



I have configured my SQL Server 2005 to take backups and I have another program running to compress these files to .RAR extension to save space.

I have a Maintenance Cleanup Task also configured to delete old .RAR files but it does not work.  I have specified the extension to look for to be RAR and the job runs without error but no files are deleted.

Is it that only BAK and TRN files are deleted using Maintenance Cleanup Task?

Create Data List at Run Time


hi friends,

I need ur little help, i have a dataset filled from the DB,

let assume the data in the dataset is: -

Inderjeet          Name          Jagjeet          Father's Name          BE.           Qualification.          and so on at infinite level. set by the user.

now i wana bind my data in the Data list:-

bind like as:-

header template would be bind with the data comming at 1 3 5.... and so on position.

I tem template would be bind with data at 0 2 4..... and so on position, Here a point need to conern is that, i dont know the no of coulmns in the data set, so i cant put the label in the header template and item template, all would be set at the run time according the data into the dataset.

the data list structure should be lke above:-




<th>Father's Name</th>




ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend