Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hamid.y
Starting Member
22 Posts |
 Posted - 2010-03-10 : 13:39:12
|
| I wanna save my .mdf and .ldf files on the network, but when choosing a network address as a filename for database files, sql server don't recognize this address on the network.filename = '\\srv\G\SQLDB\datafile.mdf'is what i set as a filename for my database files.anyone can help me? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-11 : 03:14:34
|
| Why do you want to put the database files on a share? Knowing that might enable us to suggest a solution. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-03-11 : 04:37:56
|
Acording to BOL: quote:
By default, using network database files (stored on a networked server or network-attached storage) is not enabled for SQL Server. However, you can create a database that has network-based database files by using trace flag 1807. For information about this trace flag and important performance and maintenance considerations, see this Microsoft Web site (http://support.microsoft.com/kb/304261).
- LumbagoIf the facts don't fit the theory, change the facts. Albert Einstein |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-03-11 : 07:56:54
|
| Donot put Mdf and Ldf files in Network Path. Minor network glitches can make your whole database corrupt. |
|
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-03-11 : 08:03:35
|
quote:
Originally posted by sodeep
Donot put Mdf and Ldf files in Network Path. Minor network glitches can make your whole database corrupt.
If iam understand OP correctly,Actually OP was trying to save it on Network Path having said that OP Facing some issues and Loop was go on like it's not possible.. i was wondering your advivice as Don't Approach..is that possible first?..It is my kind request...pleaseif wrongly underatsnd please correct me |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-11 : 09:17:36
|
| If files are stored on a network path I am sceptical that SQL can know when a buffer is flushed (and thus safely commit, checkpoint and clear transactions). So ... a power cut could mean that SQL cannot roll back. I would also expect that performance will be a fraction of that of local disks.I'm actually surprised that there is a flag to ALLOW it, rather than there being NO WAY to allow it!Dangerous road to go down, unless you have good reasons and know for sure that the hardware/infrastructure will fail-safe. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-03-11 : 10:22:27
|
| If you read the link that Lumbago posted, it describes a specific set of network devices that are "Microsoft Windows servers and networked servers or NAS storage servers that are Windows Hardware Quality Lab (WHQL) certified".Also: "If you use a non-WHQL qualified storage device with SQL Server that supports the I/O guarantees for transactional database use described in this article, Microsoft will provide full support for SQL Server and SQL Server-based applications. However, issues with, or caused by, the device or its storage subsystem will be referred to the device manufacturer. If you use a non-WHQL qualified storage device that does not support the I/O guarantees for transactional database use described in this article, Microsoft cannot provide support for SQL Server or SQL Server-based applications"I wouldn't use it for anything except maybe a read-only database.CODO ERGO SUM |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-11 : 11:29:50
|
| Confirms my expectation then, thanks for clarifying MVJ |
|
|
|
|
|
|
|
|
how to Save MDF and LDF files on network