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

Top 5 Contributors of the Month
Post New Web Links

Backing Up To NAS

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server
We just purchased a Seagate BlackArmor 1100 NAS device.  The drive is attached to our network, but not part of our domain.  I can backup files if we make access to the drive public, but I'd like to use their built in security that assigns permissions for specific users to be able to read and write to the drive. The problem is this requires a user id and password, which I don't know if I can get to work in a job scheduled through SQL Server.  Does anyone know of a way to get this to work with out public access to the drive?

View Complete Post

More Related Resource Links

Backing Up & Restoring Data.

Hello, I'n new to the SQL Server Management Studio 2008, What i have done so far: I have opened my file Datebase Selected a subfolder inside the Database called "World00" I have backed up my World00 into my Hard Drive file called World00.bak But when i open my SQL Server Management Studio 2008, my World00 is "(Restoring) i seen some videos something about a Log that i also need to restore but where can i find that log? how do i make my file come back so i can go in it and use it? and also: http://img827.imageshack.us/img827/7172/problem2.jpg Can somebody please explain to me what do these options mean? Restore Options like (WITH REPLACE), (WITH KEEP_REPLICATION), Prompt and (WITH RESTRICTED_USER) Recovery State (RESTORE WITH RECOVERY), (RESTORE WITH NORECOVERY), (RESTORE WITH STANDBY) When i clicked on my World00 I selected (WITH REPLACE), and now i think i messed it up..is there a way to recover myfile back? so i can use it? because its still on "Restoring" please help! Also i did it all the way through like Manualy i didn't put any codes SQL's Query thing because i dont know how to use them if your going to give me a Query please tell me what to do, sorry i'm new to this coding ;o All i would like to know is how to backup ~ well i know this just right click on file select full backup and job done, but restoring is kinda confusing me because i

C#: How to add a row to a child table with a DataSet backing?

On the back end I am using XML files, xsd schemas a DataSet(dsThingPrograms) and DataTables. I have a parent ->child table relationship defined through the DataSet designer as such:   things[RFID(pkey), name] programs[ID(pkey/autogen), name, path, thing_RFID(FK references things->RFID)]   In my code I have:   dsThingPrograms.things.AddthingsRow("lala" , "00ffe4" ); dsThingPrograms.things.WriteXml("path\to\things.xml" , System.Data.XmlWriteMode.WriteSchema);   which works fine. However the problem comes when I try to add a row to the Programs table. When I do:   dsThingPrograms.programs.AddprogramsRow("someprog" , "some\path" , <???>);   VS wants me to add a "dsThingPrograms.thingsRow parentthingsRowByFK_things_programs" where the <???> is. I've tried a bunch of things but I could not satisfy that requirement and can't even get the code to compile. What is supposed to go in there to satisfy the FK property?

Backing up databases with large partitions in AS2005

  Hi,   While ago I reply to a thread regarding this issue, see http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-olap/11643/Backing-up-databases-with-large-partitions-in-AS2005. I think the original forum is no longer available.   This week I got a similar problem, now we are not able to create and restore a abf for a cube with a .fact.data file with size of 4.39 GB. We are in a Win Server 2003 Enterprise Edition SP2 (IA64) . The SSAS version is 9.00.4035.00 (SQL Server 2005 Service Pack 3 ). We did the following steps: Create the .abf in SSMS compressing the data of the <database name>_2010 . Restore it in the same server with the name <database name>_201008 . We are not able to browse the cube in <database name>_201008 . If we unprocess the partition with the .fact.data with size of 4.39 GB, then the cube browses without problems. We then copy the .fact.data from the <database name>_2010 to <database name>_201008 and then the cube from <database name>_201008 browses correctly! I can add that the database was processed in Win Server 2003 Enterprise Edition SP2 (x86) (with SQL Server 9.00.3228.00 - Cumulative update package 6 for SQL Server 2005 Service Pack 2 ) and then synchronized to the Win Server 2003 Enterprise Edition SP2 (IA64) (also 9.00.3228.00) without problems. In the original thread Peter Yang [MSFT] stated th

Backing to mapped drive No GO



When I use the UNC to the share drive I get access denied.  I gather this is because it is running under the Sql Agent Account and not me.  How do I tell the Agent to run under myself?  The other problem is, if i run the backup as myself in the Query Editor it still fails, even though at the bottom it gives my domain\username as who the query is running under. 

10.50 RTM Sql Server 2008


about backing up and restoring site collections


does backing up and restoring site collections using STSADM or powershell back up the database too? how do contents remain in the sites? how can i backup a site collection without contents ? thanks for any help everyone :)

Backing up and restoring AdventureWorks database


Hey there,

I have 2 servers. Each have SQL Server 2005 installed on them. I have the AdventureWorks database on Server 1. I want to test database mirroring. So I backed up AdventureWorks to a network drive, then copied it over to a directory on Server 2. I logged into Server 2 and tried to do a restore pointing to the directory the .bak file was copied to and it errors saying 'Create database permission denied in database master'

I don't understand. For the destination db, I put in AdventureWorks.

What am I doing wrong?

Thanks for your help!!

Trouble backing up to a network share


I am having trouble trying to get MSSQL 2005 to backup to a network share.

Cannot open backup device '\\srvr106\logshipping\mydb.bak'.
Operating system error 1326(Logon failure: unknown user name or bad password.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Here is the setup:
+ MSSQL 2005 Enerprise Edition on Windows Server 2003 R2 64-bit;

+ \\srvr106\logshipping - share is located on windows 2007 server Enterprise service pack 2; 64-bit

+ MSSQL is running under windows account that is in Admin group on this machine, (the same Windows account exists on the destination srvr106 server in Admin Group).

+ both srvr106 & srvr104 servers are in the same workgroup (no domain only workgroup).
+ destination server srvr106 allows everyone full control to share.

Interesingly, the backup works fine for another share on another Windows Server 2003 R2 server, called srvr104, but not for srvr106, which has Win 2007 as described above.
Is that a problem?

thank you!


Backing up and truncate log fast


Hello all,

What are the problems that the following backup method can create:

Backup Log "database_name" With Truncate_Only

Also, if this method is not preferred, which backup method should be used to backup and truncate Tlog fast in a case of emergency?



Backing up SQL CE 4.0 during run-time


When I release upgrades with my desktop app I backup my .sdf with a simple copy from the code behind.   

I do this via a background worker, and on bgw completion, I run the SQL commands to modify the DB.

Is there a more elegant way to backup 4.0?

Backing up the Database Objects only in SQL Server 2008 R2 using T-SQL


Hi Team,

I have used DMO and T-SQL  to backup my database objects only in SQL server 2005 working fine. I know DMO script would not work in SQL server 2008 R2. Do you have any equivalent script in SQL server 2008 R2. Can we achieve the same using SMOs in SQL server 2008 R2.

If you want I can post the working 2005 SQL script.

Appreciate your help .

Many thanks







Kalyan Techbubbles.com

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