I'm using SQL sever 2005 and 2008 expressHow Can I create a DB backup in a specific folder??I use Management Studio but I'd like to automatically create backup without use tools
View 5 Replies
when I make restore to backup database display this error :
The backup set holds a backup of a database other than the existing 'elib' database. (Microsoft.SqlServer.Smo)
how I can solve this error ?
i am trying to create an asp.net service where it can delete specific records from the databas, this is by code so far:
View 1 Repliesmy db in sql server 2005. in my program i want to do a buttion to backup the db. how can i do that?
View 8 RepliesHow to take backup of database of requied database from asp.net to our physical path?
View 11 Replies i have sql2000 i need to take back up
but i am not getting anything in the folder
my stored procedure has
[code]....
i m using these command for backup and restore sql database
BACKUP DATABASE [db_report] TO
DISK =N'db_report.bak'
WITH NOFORMAT, NOINIT, NAME = N'Report-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
RESTORE DATABASE [db_report]
FROM DISK = N'db_report.bak'
WITH FILE = 1,
MOVE N'db_report' TO N'C:db_report.mdf',
MOVE N'db_report' TO N'C:db_report.ldf',
NOUNLOAD, STATS = 10
but i want to set backup drive name with today date and time yani my i will set drive D:db_report010320100910am if u will see theres is db_reportMonth(01) Day(03) Year(2010) Time(09:10am) and when i want to restore then ask me which one u want to get restore
I have two databases- database1 and database2. I have taken the full backup of database1 and want to restore it to the database2. When I do it in the Sql server Management Studio, I get this error:
The backup set holds a backup of a database other than the existing 'database2' database.
how to Take External Database Backup file into Local HardDrive.
how can I achieve this using the SQLdatasource control? I'm using the VB language. What controls/commands should I use to have a backup and restore function on my website?
View 2 Repliesi am trying but i am unable to do this one.
View 2 RepliesI have one database in local server...
What i need is i need to get a backup of my database with one click of asp.net button click with the names as of todaysdatewithtime.bak format..
as well i need to restore using asp.net on button click...
I have an SQL 2008 R2 database on an X86 machine that I have backed up a database from. Now I want to restore it to an SQL 2008 R2 instance on an X64 machine and keep gettting format errors (attributed to restoring a higher version of database to a lower database instance ie 2005 to 2008). On inspecting the databases I find the X86 is version 10 and the X64 is version 9 (which is supposed to be the 2005 database)...are there different versions of the same DB for different software platforms?
View 3 RepliesI am ristrcting access to the Account folder using below:
<location path="Account">
<system.web>
<authorization>
<deny users="?"/>
<allow users="*"/>
</authorization>
</system.web>
</location>
and access to the Default.aspx using
<location path="Default.aspx">
<system.web>
<authorization>
<deny users="?"/>
<allow users="*"/>
</authorization>
</system.web>
</location>
but how do i restrict access to a specific file in the Account folder rather than the entire folder?
I tried the following but did not work
<location path="AccountChangePassword.aspx">
<system.web>
<authorization>
<deny users="?"/>
<allow users="*"/>
</authorization>
</system.web>
</location>
1. i have created aa database named "qraghul" which contains two tables. i want this database to backup from my system and restore it to the host server or any other system. how i can do it.
2. suppoose if i backup and restore it to any system or server. whether i have to change the connection string in my application eg Data Source=QUANO-462F6EB27;Initial Catalog=qraghul;Integrated Security=True
bcoz my server name is QUANO-462F6EB27 whether i restore it to any system. i need to change the server name?
SQL Server Express 2005 MS Visual Studio 2005 Using ASP.NET with VB code behind. Requirements: Click a button on an ASPX page to disconnect temporarily all DB connections when not in use to allow a script to backup/copy the database to a safe backup location. When a user access the db afterwords, the DB connections will be re-established.
If this is imposible, recommend an alternative. Note: I am working with what I have been given and authorized to use.
Invalid column name 'is_compressed'.
Invalid column name 'compressed_backup_size'.
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
Processed 264 pages for database 'E:ASP.NET4.0_CalculatorhicalcApp_DataASPNETDB.MDF', file 'ASPNETDB_1847a276f17a4e2cb63c95936431bc26_DAT' on file 1.
Processed 1 pages for database 'E:ASP.NET4.0_CalculatorhicalcApp_DataASPNETDB.MDF', file 'ASPNETDB_TMP_log' on file 1.
BACKUP DATABASE successfully processed 265 pages in 0.404 seconds (5.124 MB/sec).
[Code]....
I want to save zipped file on server disk using DotNetZip in ASP.Net .... This code creates zip and download it in client side download folder..
ZipFile zip = new ZipFile();
List<Attachment> listattachments = email.Attachments;
int acount = attachments.Count;
for (int i = 0; i < acount; i++)
[Code] ....
I am working on asp.net 3.5 in C#. In my application I have to Create folder and upload file in that folder, which works fine on my machine. I want help for create folder and upload file in that folder on other machine which is connected in LAN. code for create folder and Upload file on my machine
string FileName = FileUpload1.FileName;
This is our current solution layout.
Main Solution
Business Class C# Project
Module1
f1class1.cs f1class2.cs
Module2
f2class1.cs f2class2.cs
Module3
f3class1.cs f3class2.cs
UI Project (aspx,aspx.cs,bin,app_code)
Module1
page1.aspx page2.aspx
Module2
page3.aspx page4.aspx
Module3
page5.aspx page6.aspx
For every deploy the UI Project is published and moved to all the sites. All the Modules use the same Business Class C# Project. Basically every page will use some common classes in Business Class C# Project >> Module1 Now what i need is to just deploy Module3 independent of full deploy. This shouldnt disturb the existing functionality for the remaining modules as they are already working fine in Production. So only the Module3 business class and Module3 aspx changes need to be deployed. The problem here is Module3 business class is a part of Business class C# Project. Is there a way to just deploy Module3 Business Class, ASPX when ever required without having to move the Business Class C# Project.
I would like to ask some help from you guys on how do i do this problem. I'm using asp.net and my problem is on getting the list of filename inside the folder. Is there a function on this? I tried this on console apps there's a function like GetFileName. Hope somebody could help me on this.
View 1 Replieshow can i find the value in the field which contain "," and remove it in sql e.g:
the field is: 11,12,13
how can i find 12 and remove it becomes=> 11,13
if the field is 12,13,14==> 13,14
if the field is 9,10,11,12 ==> 9,10,11
if the field is 12 only ,then result is empty
I have an "Admin" folder in my application that will include pages that I would not like to have anonymous access to. When a user attempts to load a page that resides in this folder, I would like to redirect them to a login page. Here is what I have in my config so far.
[Code]....
[Code]....
Following is my directory structure of my web application which is also configured in IIS as virtual directory
Web Site Root
|MasterPage (file)
|Web Config (file)
|Public Contents (directory)
|ShowNewWallpapers.aspx
|Admin (directory)
| Login.aspx
|WebSiteStat.aspx
|WebConfig file (need form security here)
How is configure my both web configs to solve my issue. currently i am getting following error
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
my root web config has default settings and my Admin directory has following settings
<system.web>
I am having dataset.xsd file which contain table-1 and thousands of record.The table contains rollno,name,mark and soon.If i give rollno means it automatically select name dfrom the table .How to perform this operation?
View 1 Replies
