View Complete Post
Hi all. I want send backup statement from my c# code to sql server then
sql server return same back up file to my application in varbinary(max).
what code is necessary for that?
I used the below code to return the datas from one excel file. My question is if i suppose need to get the records from morethan one excel file using joins, how it is possible.
string connString = ConfigurationManager.ConnectionStrings["xls"].ConnectionString;
// Create the connection object
OleDbConnection oledbConn = new OleDbConnection(connString);
// Open connection
// Create OleDbCommand object and select data from worksheet Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn);
// Create new OleDbDataAdapter
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
// Create a DataSet which will hold the data extracted from the worksheet.
DataSet ds = new DataSet();
// Fill the DataSet from the data extracted from the worksheet.
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.
MSDN Magazine May 2009
I have three databases named XDW, XOLTP, XOLTPSchema. All of these are for only one application. In the application, user should do backup/restore using GUI.
1. How I should do backup/restore in one transaction? i.e. all of three actions should be success elsewhere all of them should fail.
2. Is it possible to backup them into only one file e.g. X.bak?
3. Or, What is the standard solution in this condition?
Thanks in advance.
Ive just done BACKUP LOG against particular database and found no changes in size for the appropriate LDF file. It is shrunk only after I issue:
But this approach breaks all logs chain. Is there any way to shrink the LDF file for FULL backup model without destroying the whole sequece of log backups?
I need to make a backup file(.bak) of a database(.mdf)
I learned I need to use MS SQL Server management studio Express to do so, but I can't figure it out how.
I don't know how to connect to the database using this program. In the "Connect to Server" dialogue window, I am supposed to choose a server name from the dropdown list, but nothing comes up. What am i doing wrong? Pls see the screet shot. Please help!
During logshipping, job on secondary server is ran successfully BUT give this information "Skipping log backup file since load delay period has not expired ...."What is this "Load delay period" ? Can we configure this somehow, somewhere ? NOTE : The value on "Restore Transasction Log tab", Delay Restoring backups at least = Default (zero minutes)Thanks
I want to check first to see ifthe xyz.bak file exsits before I perform a backup.
I'm having a strange issue with file system permissions.
A backup database to file location e:\sqlbackup works fine.
A BACKUP SERVICE MASTER KEY or BACKUP MASTER KEY fails with the error ´MSG 15240, Level 16, State 1 Cannot Write into file ´e:\sqlbackup\file.bak' Verify that you have write permissions, etc...'
What am I missing?
On trying to restore a site backup from one moss server to another using STSADM i encountered this error.
Your backup is from a different version of Windows SharePoint Services and cannot be restored to a server running the current version. The backup file should be restored to a server with version '763911617.771019783.639568184.357903087' or later.
The versions of MOSS at both server is 184.108.40.20624. What is the version numbers indicated in the error message. Is it the Servers Operating System updates version. Where can i find the relevance of the numbers