You really need to check with the SAN vendor whether they guarantee consistency for databases.

But in any case I would stop the application and then SQL services cleanly, especially...

duplicate post, answers to:

http://www.sqlservercentral.com/Forums/Topic945011-61-1.aspx

If you are connected to the database restore jobs will fail as they require exclusive access, so make sure you are not connected to the database when the restore jobs...

balasach82 (6/29/2010)

---

Thanks for the query.

Present size of DB is around 940MB and the max limit is set to 1000MB(i.e. restricted growth to 1000MB). So what would happen on reaching the...

select db_name(database_id),name,size,max_Size from sys.master_files

size and max_size are in 8K pages.

max_size = -1 means unlimited

Greg_ (6/28/2010)

---

george sibbald (6/28/2010)

---

Correct, with this setup for SQL to use memory above 4Gb you need to enable AWE. Also allocate the 'lock pages in memory' right to the SQL...

Correct, with this setup for SQL to use memory above 4Gb you need to enable AWE. Also allocate the 'lock pages in memory' right to the SQL service account.

Its not...

There are plenty of backup compression tools out there you could use, they are quite cheap. hopefully you would just have to license the source server and restore only license...

if you are logshipping from SQL 2000 to SQL2008 and you want the SQL2008 database available you won't be able to do it.

If you use the with standby option to...

In SQL2000 always change the accounts SQL services run under via properties ---> security in enterprise manager

Has maxsize been set for tempdb?

Hello? Can anyone hear me out there?

Run a backup LOG, not a full backup.

I did not mean backup log with truncate_only, just a normal backup log dbname to disk = ' wherever'

you cannot put a mirrored database into any recovery mode than full.

to...

backup the log to clear space within the log (i.e. truncate it). You can then shrink the log if you really need to, but only to the size required to...

refer to

http://www.sqlservercentral.com/Forums/Topic942386-391-1.aspx